Ascentt
Data Architect / Data Modeler
Plano, TX
Sponsorship not specifiedDetected 26 days ago
Data StructuresSQLBigQuerySnowflakeRedshiftDatabricksAWSGCPAzureMachine LearningdbtData AnalysisData EngineeringData VisualizationSupply ChainLogisticsUnityLeadershipCommunicationProblem Solving
About the role
- We turn enterprise data into real-time decisions using advanced machine learning and GenAI.
- We're hiring passionate builders to shape the future of industrial intelligence.
Responsibilities
- Design and maintain conceptual, logical, physical, and semantic data models to support reporting, analytics, operational, and advanced data use cases.
- Develop semantic models that establish consistent business definitions, KPIs, metrics, hierarchies, dimensions, and calculation logic across analytics and BI platforms.
- Partner with data engineering teams to ensure data models are accurately implemented across data pipelines, warehouses, lakehouses, and semantic layers.
- Support modern data platform architecture across technologies such as Databricks, Snowflake, Azure Synapse, Microsoft Fabric, AWS Redshift, Google BigQuery, Delta Lake, or similar platforms.
- Design models across raw, curated, and consumption layers, including bronze/silver/gold or equivalent lakehouse patterns.
- Review and optimize existing models for performance, scalability, usability, consistency, and maintainability.
- Support data product design by defining domain-aligned entities, data contracts, reusable metrics, and governed consumption models.
Requirements
- Minimum 10 years of experience in data architecture, data modeling, data warehousing, business intelligence, enterprise analytics, or related areas.
- Strong hands-on experience in conceptual, logical, physical, and semantic data modeling.
- Experience designing semantic layers or business consumption layers for enterprise reporting and self-service analytics.
- Experience with modern cloud data platforms such as Databricks, Snowflake, Azure, AWS, GCP, Microsoft Fabric, or similar.
- Experience with BI and analytics tools such as Power BI, Tableau, Looker, Qlik, or similar.
- Strong understanding of metadata management, data lineage, governance, data quality, master data, and reference data concepts.
- Ability to engage with business stakeholders, data engineers, BI developers, product owners, and governance teams.
Nice to have
- Experience with semantic modeling tools or frameworks such as Power BI semantic models, AtScale, Looker, dbt Semantic Layer, Tableau semantic layer, or similar.
- Experience with governance and catalog tools such as Collibra, Alation, Informatica, Microsoft Purview, Unity Catalog, or similar.
- Experience with data mesh, data products, domain-driven architecture, and enterprise metric stores.
- Exposure to graph modeling, business ontology, metadata-driven architecture, or knowledge graph concepts is a plus.
- Experience supporting AI/ML or GenAI use cases through well-governed and analytics-ready data models is preferred.
- The ideal candidate will have a minimum of 10 years of experience designing scalable data solutions, building conceptual, logical, physical, and semantic models, and enabling trusted analytics across the enterprise.
- The candidate should have hands-on experience with modern cloud data platforms, lakehouse architecture, data warehousing, BI platforms, and governed data consumption layers.
- Define scalable data modeling patterns including dimensional models, star schemas, snowflake schemas, canonical models, entity relationship models, data vault concepts, and curated consumption-layer models.
Apply directly at Ascentt →Create a free account for alerts like thisView Ascentt immigration profile
This listing is sourced directly from Ascentt's careers page and normalized into a canonical job model.