Senior Principal Consultant, Data Architect

We are seeking a highly experienced Data Architect with relevant years of experience in designing, implementing, and governing enterprise-scale data platforms. The ideal candidate will have deep expertise in modern cloud data stacks, including dbt, Snowflake, and Fivetran, along with strong knowledge of Master Data Management (MDM) and advanced data modeling techniques.

Requirements

• Define and own the enterprise data architecture strategy and roadmap.
• Design scalable data warehouse, lakehouse, and ELT architectures.
• Architect modern cloud-based data platforms using Snowflake and associated tools.
• Establish architecture standards, best practices, and governance frameworks.
• Design ELT workflows leveraging Fivetran for ingestion and dbt for transformation.
• Define transformation standards, modular dbt architecture, and testing frameworks.
• Optimize Snowflake performance (clustering, partitioning, cost optimization).
• Implement CI/CD and DevOps best practices for analytics engineering.
• Lead conceptual, logical, and physical data modeling initiatives.
• Implement dimensional modeling (Star/Snowflake schema), Data Vault, and hybrid models.
• Design and implement Master Data Management (MDM) solutions.
• Establish golden records, data harmonization, and entity resolution strategies.
• Define metadata management and lineage frameworks.
• Define enterprise data governance policies.
• Ensure data security, privacy, and regulatory compliance.
• Establish data quality frameworks and monitoring mechanisms.
• Implement role-based access control and secure data-sharing practices.
• Provide architectural guidance to Data Engineers and Analytics teams.
• Collaborate with business stakeholders to translate requirements into scalable data solutions.
• Evaluate and recommend emerging data technologies.
• Mentor engineering teams and drive best practices adoption.

Benefits

• Paid Time Off
• 401k Matching
• Retirement Plan
• Health Insurance
• Dental Insurance
• Vision Insurance
• Life Insurance
• Disability Insurance