HiringCafe
Posted 5mo ago

Senior Data Warehouse Engineer

@ Bennett Thrasher
View All Jobs
United States
RemoteFull Time
Responsibilities:lead engagements, design schemas, build pipelines
Requirements Summary:6–10+ years in data warehousing with Kimball modeling; strong T-SQL; hands-on with Microsoft Fabric; client-facing; CI/CD.
Technical Tools Mentioned:Microsoft Fabric, Power BI, PySpark, T-SQL, OneLake, GitHub, Azure DevOps, Pipelines
Save
Mark Applied
Hide Job
Report & Hide
Job Description

Bennett Thrasher, currently ranked among the largest CPA firms in the U.S., is a premier provider of professional tax, assurance, and consulting services to businesses and high-net-worth individuals. Consistently named one of the Best Accounting Firms to Work for in the United States by Accounting Today, Bennett Thrasher offers the expertise and opportunities of a large firm while maintaining a people-first, family-like culture. We work hard to help our clients solve complex challenges, and we also believe in taking time for what matters—our benefits and flexibility reflect that mindset.

Bennett Thrasher (“BT”) is seeking a Senior Data Warehouse Engineer (Microsoft Fabric) to join our Consulting practice. The successful candidate will lead multi-client engagements to ingest data into Microsoft Fabric, design and implement dimensional data warehouses, build ETL/ELT with Fabric Pipelines, Dataflows Gen2, and PySpark notebooks, and deliver governed Power BI semantic models. This is a hands-on client-facing role that blends architecture, engineering excellence, and stakeholder partnership.

Responsibilities:

Data Architecture & Modeling

  • Design, implement, and maintain star/snowflake schemas (grain definition, conformed dimensions, SCD Types 1/2).
  • Define reference architectures for Fabric OneLake, Lakehouse ↔ Warehouse patterns, medallion zoning, and security/RLS.
  • Create technical design docs, estimates, and roadmaps; facilitate design reviews.

ETL/ELT Engineering in Fabric

  • Build Dataflows Gen2 for standardized ingestion and PySpark notebooks for scalable transformations.
  • Develop metadata-driven, reusable load patterns (parameterization, reusable templates, CDC/incremental).
  • Orchestrate workloads with Fabric Pipelines including scheduling, retries, alerting, and SLA monitoring.
  • Author performant T-SQL (staging, MERGE/UPSERT, window functions, partitioning, indexing).

Analytics Delivery (Power BI / Semantic Models)

  • Publish Power BI semantic models aligned to dimensional designs; implement RLS and incremental refresh.
  • Partner with analysts to define certified metrics, calculation groups, and dataset governance.

Data Quality, Operations & Governance

  • Embed automated data quality checks, reconciliation, lineage, and documentation/data contracts.
  • Optimize cost/performance (partitioning, caching, refresh strategies) and enforce RBAC/PII controls.
  • Implement Git-based CI/CD (Azure DevOps/GitHub) and promote Dev/Test/Prod release automation.

Client Delivery & Leadership

  • Translate business processes into scalable data solutions; present progress and risks to team/client stakeholders.
  • Mentor team members, lead code reviews, and contribute to internal accelerators/playbooks and best practices.

Audits & Client Support

  • Lead discovery sessions, current-state assessments, and target-state Fabric designs across multiple clients.

Solution Templates, Training & Enablement

  • Develop re-usable templates for Dataflows Gen2, PySpark, and Pipelines; create training materials and deliver enablement sessions for client teams.

 

Qualifications

  • Bachelor’s degree in Information Systems, Computer Science, Engineering, or related field (or equivalent experience).
  • 6–10+ years in data warehousing/analytics with deep dimensional modeling (Kimball) and production T-SQL expertise.
  • Hands-on experience across Microsoft Fabric: OneLake, Lakehouse, Warehouse, Dataflows Gen2, Pipelines, Notebooks (PySpark), and Power BI semantic models.
  • Strong engineering practices: version control, code reviews, documentation, CI/CD.
  • Excellent client-facing communication, estimation, and stakeholder management skills; ability to work independently and collaboratively on multi-disciplinary teams.

 

Bennett Thrasher is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race; color; religion; national origin; sex; pregnancy; sexual orientation; gender identity and/or expression; age; disability; genetic information; citizenship status; military service obligations; or any other category protected by applicable federal, state, or local law.