Lead Data Architect (Semantic Layer)
Ann Arbor, MI, United States
USD 192K-264K (estimate) Senior-level Full Time
Tasks
- Build aggregated views
- Build curated analytic views
- Certify datasets
- Create semantic modeling standards and templates
- Create standardized KPIs
- Define KPI logic
- Define calculation rules
- Define grain and hierarchy rules
- Define metric design and governance
- Design star schemas
- Design trusted enterprise metrics layer
- Eliminate metric drift across Power BI
- Enable lineage and auditability
- Enforce access controls for semantic assets
- Establish metric versioning and change management
- Evolve semantic layer strategy
- Implement semantic layer on Databricks
- Lead semantic layer design
- Maintain canonical entities
- Maintain conformed dimensions
- Perform impact analysis
- Provide domain semantic leadership
- Review domain semantic implementations
- Use Databricks Unity Catalog for governance
Perks/Benefits
- 401k matching
- Adoption Assistance
- Childcare tuition discounts
- Company bonus
- Fertility benefits
- Fitness Nutrition Wellness Programs
- Medical/Dental/Vision
- Mental health support
- Paid Holidays
- Paid vacation
- Stock purchase discount
Skills/Tech-stack
Access Control | Change Management | Conformed Dimensions | Data Governance | Data Lineage | Data Observability | Databricks | Databricks SQL | Delta Lake | Dimension design | Dimensional Modeling | Fact Dimension Design | Fact/Dimension | Grain Management | Metric Versioning | Power BI | SQL | Star Schema | Unity Catalog
Education
N/A
Related jobs
-
AWS | Azure | Cloud Run | Django | Docker401k | Dental insurance | Medical insurance | Paid sick hours | Vision insuranceSenior-level Contract Full TimeSan Jose, CA, United States5h ago
-
Enterprise Analytics Lead USD 119K-233KABAP | Access Control | Analysis Services | Analytics Cloud | Azure SynapseExtra day off every other week | Flexible 9/80 work schedule | In-office schedule | Work-life balanceSenior-level Full TimePortsmouth, NH, United States12h ago
-
Director of AI & Data Analytics USD 175K-224KAmazon Web Services | Anomaly Detection | Apache Airflow | DBT | Data Governance401k match | Autonomy | Collaborative culture | Generous PTO | Health and wellness benefitsExecutive-level Full TimeDallas, TX, US12h ago
-
Mid-level Full TimeNashville, TN, United States14h ago
-
Mid-level Full TimeNew York, Canada15h ago
-
Sr. Manager Procurement Systems & Analytics USD 115K-141KArtificial Intelligence | Business Process | Business Process Analysis | Change Management | Data GovernanceSenior-level Full TimeWesterville, OH, United States16h ago
-
Senior Manager - Rental Analytics USD 44K-52KAS400 | Access | Capacity modeling | Data Analysis | Data QualityCoaching and Mentorship | Continuous learning culture | On site work location | Travel as neededSenior-level Full TimeReading, PA, United States16h ago
-
Software Engineer [Multiple Positions Available] USD 180K-215KAWS | Apache Kafka | Classification | Cohort Analysis | DockerBackup childcare | Financial coaching | Health care coverage | Mental health support | On-site wellness centersSenior-level Full TimeWilmington, DE, United States16h ago
-
CI/CD | Data Modeling | Data Observability | Data Validation | Data profiling401k match | Dental insurance | Health insurance | Life insurance | Paid HolidaysSenior-level Full TimePrinceton16h ago
-
Business Data Scientist, Applied Machine Learning, GCS USD 138K-198KA/B | A/B Testing | B testing | Causal Inference | Data DriftMid-level Full TimeMountain View, CA, USA; New York, …18h ago
-
Database querying | Deep learning | Graph Databases | Language Processing | Machine LearningMid-level Full TimeNew York, NY, USA; Mountain View, …18h ago
-
Access Control | Alerting | Batch Processing | Data Governance | Data ModelingSenior-level Full TimeKirkland, WA, USA; Sunnyvale, CA, USA18h ago
-
Software Engineer III, Gemini Enterprise App, Cloud AI USD 147K-211KAccess Control | Batch Processing | Data Engineering | Data Governance | Data ModelingSenior-level Full TimeSunnyvale, CA, USA; Kirkland, WA, USA18h ago
-
Senior Data Engineer, GTM USD 156K-227KAI Agents | Alerting | Data Governance | Data Modeling | Data PipelinesSenior-level Full TimeMountain View, CA, USA; Chicago, IL, …18h ago
-
Staff Software Engineer, Gemini Enterprise App, Cloud AI USD 207K-301KBatch pipelines | C++ | Data Privacy | Data Structures | Data WarehousingSenior-level Full TimeSunnyvale, CA, USA; Kirkland, WA, USA18h ago
-
Global Consolidated Customer Data & AI Lead USD 144K-216KAI Governance | Analytics | CCPA | Data Architecture | Data DeduplicationDental insurance | Health care | Paid time off | Retirement plan | Sick leaveSenior-level Full TimeWhippany, New Jersey, US20h ago
-
Alteryx | Data Mining | Data Visualization | Data cleaning | Databricks401k program | Car discounts | Cruise discounts | Dental insurance | Employee assistance programSenior-level Full TimeFort Worth, TX, US21h ago
-
Junior Data Engineer USD 48K-54KAzure | Azure Data | Azure Data Services | CI/CD | DBTHealth and wellness programs | Inclusive culture | Medical dental and disability benefits | Retirement savings programEntry-level Full TimeAtlanta, GA, US, 3033822h ago
-
API Integration | AWS | Accessibility | Azure | D3.jsCollaborative environment | Contract extension | Flexible international environment | Fully remote work | High autonomySenior-level Full TimeCanada R1d ago
-
Senior-level Full TimeRemot, USA, United States R1d ago
-
Access Control | Audio Visual | Audio/Visual Technologies | Cause analysis | Display systemsRetirement offeringsMid-level Full TimeLos Angeles, CA, United States1d ago
-
Senior Engineer-GenAI Platform Engineering USD 122K-200KAgent Framework | Agentic AI | Apache Flink | Apache Kafka | Apache SparkSenior-level Full TimeAddison, United States1d ago
-
Lead Data Engineer USD 126K-165KApache Spark | Application Insights | Azure Data | Azure Data Factory | Azure MonitorOn-call support | Remote workSenior-level Full TimeUnited States - Remote, United States R1d ago
-
Power Platform & AI Engineer USD 109K-174KALM | APIs | Copilot Studio | DLP | DataverseDiscretionary year end shutdown | Family planning benefits | Fitness and mental health support programs | Fitness support | Global recharge daysMid-level Full Time325 Binney St - Cambridge - …1d ago
-
Sr. Power Platform & AI Engineer USD 130K-209KALM | APIs | Copilot Studio | Data Loss Prevention | Data lossDiscretionary year end shutdown | Family planning benefits | Fertility adoption and surrogacy support | Fitness and mindfulness resources | Global recharge daysSenior-level Full Time325 Binney St - Cambridge - …1d ago