Data Engineer (Warehouse, BI & SQL DBA)
On-site · Scottsdale, Arizona, United States
Job Summary
Own end-to-end Microsoft data platform from database design and administration through reliable data pipelines into a governed enterprise Data Warehouse/Lakehouse (Azure Synapse and/or Microsoft Fabric) to enable analytics and reporting in Power BI. Design, implement, and administer SQL Server and Azure SQL databases; build and optimize ELT/ETL pipelines; develop scalable transformation patterns using T-SQL and Spark; manage warehouse/lakehouse dimensional modeling (star/snowflake) and semantic layer alignment; implement data quality, governance, and observability; enforce security controls; automate deployments with Git-based workflows and CI/CD; create technical documentation; collaborate with application teams, stakeholders, and analytics users in an Agile environment.
Required Qualifications
- 6+ years of hands-on experience in data engineering and/or data warehouse engineering, including building production-grade pipelines and curated datasets
- 4+ years administering and tuning SQL Server and/or Azure SQL (query optimization, indexing, security, backup/restore, and maintenance)
- Strong proficiency with T-SQL, relational data modeling, and performance tuning (execution plans, statistics, partitioning, and concurrency patterns)
- Experience building ELT/ETL with Azure Data Factory/Synapse Pipelines and/or Fabric Data Factory; familiarity with event/file-based ingestion patterns
- Experience designing and operating a modern warehouse/lakehouse using Azure Synapse and/or Microsoft Fabric (Lakehouse/Warehouse, notebooks/Spark, and orchestration)
- Strong understanding of data warehouse concepts and modeling techniques (Kimball dimensional modeling, SCD, data marts, and semantic layer alignment)
- Power BI experience supporting enterprise reporting (datasets/semantic models, refresh strategies, performance optimization, and workspace governance)
- Experience with Azure security and identity patterns (Azure AD, managed identities, Key Vault, RBAC) and protecting sensitive data (PII) end-to-end
- Hands-on experience with DevOps practices: Git branching, code reviews, CI/CD, and automated deployments (Azure DevOps and/or GitHub)
- Strong troubleshooting skills across data pipelines, databases, and BI; ability to communicate clearly with technical and non-technical stakeholders
- Bachelor's degree in Computer Science, Engineering, Information Systems, or equivalent experience
Apply with one swipe on Sorce. We auto-fill applications and apply on your behalf — no cover letters, no 40-minute forms.
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.