Quick Overview
Job Description
Key Responsibilities
Design, develop, and lead implementation of complex star-schema data models, including fact, dimension, bridge, and aggregate tables.
Build, optimize, and govern DBT frameworks, models, testing strategies, and reusable development patterns.
Architect, optimize, and troubleshoot large-scale Snowflake data structures, pipelines, and SQL workloads.
Define and enforce enterprise data modeling standards, best practices, and design patterns.
Lead architectural decisions related to dimensional modeling, normalization, denormalization, and analytical data structures.
Partner with Data Engineers, BI Developers, Product Owners, Architects, and business stakeholders to deliver scalable analytical solutions.
Mentor team members, conduct design reviews, and provide technical leadership across analytics engineering initiatives.
Drive data quality, performance, governance, documentation, and continuous improvement of the analytics platform.
Required Qualifications
Expert-level hands-on experience with DBT development, testing, and deployment practices.
Expert-level experience with Snowflake architecture, performance tuning, and SQL optimization.
Proven experience designing and implementing enterprise-scale dimensional data models.
Deep understanding of data warehousing, analytical modeling, and modern analytics engineering principles.
Experience leading technical design decisions and influencing data architecture strategy.
Strong communication and stakeholder management skills with the ability to translate complex technical concepts into business value.
Similar jobs
- PA
Manager, Analytics Engineering
NewAuto ApplyPatientPoint
Cincinnati🇺🇸Hybrid14 hours agoGCPSQLAWS+11Engineering - JI
Microsoft Fabric Analytics Engineer
NewJKV International
Atlanta, GA🇺🇸RemoteYesterdaySQLGitAzure+2Technology - CC
Payer Analytics Consultant (Defined Term)
NewCentral California Alliance for Health (Remote)
Phoenix, Arizona🇺🇸$132k/yrHybrid8 hours agoMicrosoft ExcelMicrosoft WordMicrosoft PowerPoint+3Finance - XS
Data Analytics Engineer with Security Clearance
NewXPECT Solutions, LLC
Crystal City, VA🇺🇸On-siteYesterdayOracleSQLGit+7Technology - GF
Data Quality Analytics Engineer - W2 (No C2C or 1099) - Hybrid in Irving, TX or Miami, FL (Posted SAM)
NewGlobal Force USA
Irving, TX🇺🇸Hybrid2 days agoSQLGitPython+3Technology - PG
Senior Analytics Engineer - Marketing Data
NewPerfict Global, Inc.
United States🇺🇸Hybrid2 days agoSQLGitSnowflake+3Technology - TW
Senior Analytics Engineer
NewAuto ApplyTwilio
Remote - US🇺🇸RemoteYesterdaySQLAWSLooker+7Technology - OH
Director, Analytics Engineering
NewAuto ApplyOscar Health
New York🇺🇸HybridYesterdayRecruitingSQLLooker+5Engineering - MC
Data Analytics Engineer
NewMCKESSON
Alpharetta, GA🇺🇸$111.8k - $186.4k/yrOn-site2 days agoSQLLookerSnowflake+10Technology - MC
Data Analytics Engineer
NewMCKESSON
Columbus, OH🇺🇸$111.8k - $186.4k/yrOn-site2 days agoSQLLookerSnowflake+10Technology - SA
Senior AI Data & Analytics Engineer II
NewAuto ApplySamsara
Remote - Seattle🇺🇸$137.4k/yrRemote2 days agoSQLETLMachine Learning+16Technology - CH
Manager, Forward Deployed Healthcare Analytics
NewAuto ApplyCohere Health
United States🇺🇸$123k - $148k/yrHybrid2 days agoSQLTableauPower BI+3