Sr. Data Engineer

Job Description

One of Insight Global’s customers is looking for a senior-level data professional to help build and support its growing Microsoft Fabric data environment. This person will be responsible for building and supporting Southland’s Microsoft Fabric data environment, with a focus on data ingestion, ETL/ELT pipelines, and data transformation. They will bring data from multiple source systems into Fabric and move it through Bronze, Silver, and Gold layers using Medallion Architecture, ensuring the data is cleansed, standardized, validated, and ready for reporting. The role will also build and monitor Fabric pipelines, write and optimize SQL/T-SQL queries, support Fabric and SQL Server databases, and manage deployments across development, testing, and production environments. In addition, this person will partner closely with Power BI resources to deliver reliable, business-ready datasets while helping establish data quality, documentation, and pipeline standards as their data platform continues to grow. This is a permanent and hybrid opportunity, working 3 days a week onsite in Garden Grove, CA, or Carrollton, TX.

Skills and Requirements

5+ years of experience working in data engineering, database engineering, or a related data platform role. Strong hands-on experience with Microsoft Fabric, including pipelines, workspaces, warehouses, or lakehouses. Experience building ETL or ELT pipelines and moving data between multiple source systems. Strong understanding of Medallion Architecture, including Bronze, Silver, and Gold data layers. Advanced SQL or T-SQL skills, including querying, stored procedures, data manipulation, and performance tuning. Experience working within an Azure or Microsoft-based data environment. Experience cleansing, transforming, validating, and reconciling data. Understanding of dimensional modeling, fact tables, dimension tables, and reporting-ready datasets. Ability to independently own technical work from design through deployment and production support. Ability to contribute quickly in an environment with limited training and ramp-up time. Familiarity with Power Automate and Power Apps. Experience using Git or GitHub for source control and deployment. Experience supporting separate development, testing, and production environments. Experience migrating SSIS packages or legacy data processes into Microsoft Fabric. Experience ingesting data through REST APIs. Experience with Azure Data Factory, Azure Synapse, Databricks, or Snowflake. Python or PySpark experience for data engineering. Experience with Microsoft Purview or other data governance and lineage tools. Experience preparing data for AI or machine learning initiatives. Experience with construction, ERP, or project-based data from systems such as COINS, Stratus, or Autodesk Construction Cloud. Microsoft Fabric or Azure certifications.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to [email protected].