Position Summary
Owns the pipelines, data layers and databases that move source data into Microsoft Fabric and make it ready for reporting.
Data moves from source systems such as Stratus, COINS and Autodesk through Fabric pipelines into bronze (raw), silver (cleaned and conformed) and gold (business-ready) layers, and from gold into Power BI. Your primary focus is the data side: landing data in bronze, cleansing it in silver and delivering the gold tables the Senior Power BI Developer reports on, plus the SQL Server and Fabric databases behind them. This is a senior individual contributor role: you own your area end to end, make independent design decisions and mentor others. We build on Microsoft Fabric today and expect to adopt new tools as the platform grows, so experience across modern data platforms counts.
Position Details
- Ingest data from SQL Server, ERP, SaaS apps, APIs, and files into bronze using Fabric pipelines. • Build full and incremental loads, including change data capture where sources support it.
- Cleanse and conform data in silver and build gold fact and dimension tables for reporting.
- Implement data quality checks, reconciliation to source and alerting at each layer.
- Orchestrate, schedule, and monitor pipelines, and own their reliability and failure recovery.
- Administer SQL Server and Fabric warehouse databases: configuration, patching, indexing, statistics.
- Tune query and pipeline performance using execution plans, Query Store and Fabric capacity metrics.
- Manage access, encryption and auditing, and test backup, restore and disaster recovery.
- Deploy database and pipeline changes through Git and deployment pipelines across Dev, Test and Prod.
- Lead the migration of legacy SQL Server jobs, SSIS packages and spreadsheet feeds into Fabric.
- Evaluate new data platform tools and AI capabilities, and recommend what the team should adopt.
- Set modeling and pipeline standards, maintain lineage and documentation, and mentor engineers.
Basic Qualifications
- Bachelor's degree in a relevant field, or equivalent experience.
- Five or more years working with SQL Server, including at least three years building data pipelines and ETL into a data warehouse or lakehouse.
- Professional certification in the specialism is common and is never a substitute for scope.
- 5+ years administering production SQL Server: security, indexing, backup, restore and performance tuning.
- 5+ years of advanced T-SQL, including stored procedures, query tuning and execution plans.
- 3+ years building ETL/ELT pipelines into a warehouse or lakehouse, with incremental loads and monitoring.
- 2+ years on a cloud data platform such as Microsoft Fabric, Azure Data Factory, Azure Synapse, Databricks or Snowflake.
- Experience with medallion architecture and dimensional modeling, including slowly changing dimensions.
- Experience implementing data quality, validation and reconciliation checks.
- Working knowledge of Power BI semantic models and how reporting tools consume gold-layer data.
Preferred Qualifications
- Python or PySpark for data engineering; orchestration and transformation tools such as Airflow or dbt.
- Azure SQL Database or Managed Instance, and Always On availability groups.
- REST API ingestion and integration platforms such as Workato; migrating SSIS packages to modern pipelines.
- Data governance and lineage tools such as Microsoft Purview.
- AI-assisted development (e.g., GitHub Copilot) and preparing data for AI and machine learning.
- Construction ERP and project data from systems such as COINS, Stratus or Autodesk Construction Cloud.
Pay
Final pay is determined by the education, experience, knowledge, skills, and abilities of the applicant, internal equity, and alignment with market data. For California , this range is $118,119-$144,368 plus annual incentive, benefits, and retirement programs as outlined above.