Apply on Employer Site

Bennett Thrasher · 2 months ago

Senior Data Warehouse Engineer

United States

Full-time

Remote

Senior Level

6+ years exp

Bennett Thrasher is a premier provider of professional tax, assurance, and consulting services. They are seeking a Senior Data Warehouse Engineer to lead multi-client engagements, design and implement dimensional data warehouses, and deliver governed Power BI semantic models in a hands-on client-facing role.

ConsultingInformation Technology

Growth Opportunities

H1B Sponsor Likely

Responsibilities

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

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)

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

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

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

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

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

Qualification

Microsoft FabricData WarehousingT-SQLPower BIPySparkClient CommunicationStakeholder ManagementTeam Mentoring

Required

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

Company

Bennett Thrasher

Bennett Thrasher is the eighth largest Atlanta-based full-service certified public accounting and consulting firm.

Founded in 1980

Atlanta, Georgia, USA

201-500 employees

http://www.btcpa.net/

H1B Sponsorship

Bennett Thrasher has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (1)

2024 (1)

2022 (1)

2020 (1)