Sr. Data Engineer

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.

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.