Brooksource · 18 hours ago
Senior Data Architect
KC Metro Area
Full-time
Onsite
Senior Level, Lead/Staff
8+ years expBrooksource is seeking a Senior Data Modeler responsible for designing, developing, and optimizing data models that power enterprise analytics, reporting, AI/ML initiatives, and data products. The ideal candidate will combine strong technical skills with the ability to translate business requirements into scalable data structures, collaborating with various stakeholders to ensure data models are performant and aligned with enterprise strategy.
Human ResourcesInformation TechnologyEmployment
Responsibilities
Design and implement dimensional models (star and snowflake schemas), Data Vault 2.0 structures, and medallion architecture patterns (Bronze/Silver/Gold) to support enterprise analytics and reporting
Build and optimize semantic models using Power BI, dbt Semantic Layer, and other technologies to enable consistent, self-service analytics across the organization
Lead the migration of legacy SSAS tabular models to modern cloud-based semantic layers while establishing tool-agnostic metric definitions
Design event schemas and data models for streaming architectures, including Kafka topics, CDC pipelines, and schema registries (Avro/Protobuf), ensuring proper schema evolution strategies
Partner with data engineers to optimize table designs, partitioning strategies, and materialized views for query performance across cloud platforms (Databricks, Snowflake, BigQuery, Azure Synapse)
Partner with data scientists to design ML-ready data models and feature stores, supporting feature engineering and training vs. serving patterns
Design data models with embedded governance, including ensuring data security at all levels, data lineage documentation, data quality rules, sensitivity classifications (PII/PHI), and business glossary alignment
Document and maintain data models, mappings, and business rules within enterprise data catalogs (Alation or similar), ensuring full traceability and impact analysis capabilities
Implement slowly changing dimension (SCD) patterns and historical tracking strategies appropriate to business requirements
Establish and enforce data modeling standards, naming conventions, and best practices across the data organization
Create data products and semantic layers that enable business users to perform self-service analytics while maintaining governance and data consistency
Partner with data scientists to design feature stores and ML-ready data models, understanding feature engineering requirements and training vs. serving data patterns
Serve as a subject matter expert and thought leader for data modeling and semantic layer design, mentoring team members and influencing architecture decisions
Contribute to enterprise data strategy by shaping how data products, metrics, and insights are standardized and scaled across the organization
Collaborate with stakeholders across business units to gather requirements, translate business needs into data model designs, and recommend solutions for new and existing data products
Mentor junior data modelers and data engineers on modeling methodologies, best practices, and modern data architecture patterns
Implement data models as code using dbt and version control (Git), establishing CI/CD pipelines for model testing and deployment
Ensure operational reliability of data models, address data quality issues promptly, and work with technical and non-technical users to troubleshoot and resolve data discrepancies
Research and recommend new tools, methods, or technologies to continuously improve data modeling practices and data platform capabilities
Qualification
Required
Bachelor's degree in Computer Science, Information Systems, Data Science, Engineering, or related field
8+ years of experience in data modeling with demonstrated expertise in enterprise data warehouse and analytics environments
Deep expertise in dimensional modeling methodologies (Kimball star/snowflake schemas, conformed dimensions, slowly changing dimensions) and familiarity with Data Vault 2.0 or normalized modeling approaches
Proactive mindset in championing and establishing AI agent workflows within data engineering, reporting, and AI/ML initiatives to drive automation and intelligent data operations
Advanced proficiency in SQL (including modern dialects for Snowflake, BigQuery, Databricks SQL), DAX, and Power Query (M)
Strong experience with semantic layer platforms, including Power BI Desktop/Service, and familiarity with dbt Semantic Layer, LookML, or similar
Hands-on experience with cloud data platforms: Databricks, Snowflake, Google BigQuery, Azure Synapse, or AWS Redshift
Solid understanding of ELT/ETL patterns, change data capture (CDC), and data integration best practices
Experience with data catalogs and lineage tools (Alation, Collibra, Atlan, or similar) for documentation and governance
Proficiency with Git-based version control and familiarity with CI/CD concepts for data model deployment
Strong analytical and problem-solving abilities with excellent attention to detail
Excellent verbal and written communication skills with the ability to explain complex data concepts to both technical and non-technical audiences
Proven ability to collaborate across cross-functional teams and facilitate requirements-gathering sessions
Experience mentoring junior team members and establishing team standards
Preferred
Experience with event-driven architecture and streaming data modeling (Apache Kafka, Confluent, Azure Event Hubs) including schema registries and schema evolution patterns
Experience with dbt (data build tool) for transformation modeling and testing
Familiarity with typical corporate business terms and data used in Finance, Human Resources, Marketing, etc
Familiarity with feature engineering concepts, feature stores, and designing data models for machine learning workloads
Understanding of data mesh principles, data products, and domain-oriented data ownership
Experience with graph databases (Neo4j, Amazon Neptune) or knowledge graph modeling
Knowledge of OpenLineage or similar open standards for data lineage
Background in AEC (Architecture, Engineering, Construction) or related industries
Relevant certifications in cloud platforms (Azure, GCP, AWS) or data modeling
Company
Brooksource
Brooksource is a single source for project and supplemental support through contract employment, contract-to-hire labor employment.
1001-5000 employees
H1B Sponsorship
Brooksource 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
2020 (10)
Funding
Current Stage
Late StageLeadership Team
Ashley Cigolotti
Director, Global Partnerships
Matt Ayala
National Account Executive (Global Partnerships)
Recent News
Technically Media
2025-05-27
Technically Media
2025-05-17
2025-05-06
Company data provided by crunchbase