Quick Overview
Seniority
Mid Senior
Work mode
Hybrid
Location
United States
Posted
13 hours ago
SQLETLSnowflakeDatabricks
Job Description
Responsibilities
- Design and implement scalable enterprise data architecture solutions using Databricks Lakehouse and modern cloud data platform principles.
- Lead development and governance of Medallion Architecture patterns across Bronze, Silver, and Gold layers.
- Design conceptual, logical, and physical enterprise data models.
- Design dimensional models including star schemas, snowflake schemas, fact tables, dimension tables, conformed dimensions, reporting models, and SCD Type 1 and Type 2 structures.
- Define enterprise data architecture standards, modeling standards, naming conventions, and design best practices.
- Partner directly with business stakeholders, product owners, analytics teams, and engineering teams to gather requirements and drive architecture decisions.
- Design data solutions integrating multiple source systems while maintaining consistency, governance, and data integrity.
- Define source-to-target mappings, business definitions, transformation rules, and lineage requirements.
- Support migration and modernization initiatives from traditional data warehouse platforms into Databricks Lakehouse environments.
- Create and maintain architecture diagrams, ERDs, data dictionaries, standards, and technical documentation.
- Support governance initiatives involving metadata, lineage, data quality, stewardship, security, and access controls.
Required Qualifications
- 10+ years of experience in Data Architecture, Data Engineering, Data Warehousing, or enterprise data platform leadership roles.
- Extensive hands-on experience designing and implementing solutions in Databricks.
- Strong experience with Databricks Lakehouse, Delta Lake, and Medallion Architecture.
- Strong experience designing conceptual, logical, physical, and dimensional data models.
- Advanced SQL skills and experience designing large-scale analytical data structures.
- Experience translating complex business requirements into scalable enterprise data architecture.
- Experience leading architecture discussions and influencing technical and business decision-makers.
- Strong understanding of ETL/ELT architectures, data integration, transformation, governance, lineage, metadata management, and data quality principles.
- Experience managing multiple applications, stakeholders, projects, and competing priorities simultaneously.
- Exceptional written and verbal communication skills.
- Ability to proactively identify risks, dependencies, and opportunities while driving initiatives forward with minimal oversight.
Similar jobs
- OR
Senior Data Architect Oracle Health Federal
NewOracle Corporation
United States🇺🇸$71.2k - $166.1k/yrHybrid13 hours agoOracleSQLETL+1Technology - ZI
Head of Business Data
Zip
San Francisco🇺🇸Remote6 weeks ago401kLookerSalesforce+7 - WH
Director, Data Governance
NewWhoop
Boston🇺🇸YesterdaySnowflakeAirflowCompliance+3 - TO
Head of Data, Director
Tomo
New York City🇺🇸Remote1 week agoSQLSnowflakeCompliance+3 - TD
Enterprise Reporting Architect
Telus Digital
Maryland Heights🇺🇸2 weeks agoAWSMachine LearningSplunk+6 - SN
Principal Data Platform Architect
Snowflake
US-CA-Menlo Park🇺🇸2 weeks agoSQLETLFlink+9