Lead Product AI Data Engineer
Manager
Analytics
Artificial Intelligence
Automation Developer
Business Analytics
Business Intelligence
Business Intelligence Tools
Cloud
Cloud Platform
Cloud Platforms
Data
Data Analysis
Data Analytics
Data Analytics Tools
Data Architecture
Data Engineer
Data Engineering Lead
Data Integration
Data Integration Tools
Data Pipeline
Data Platform
Data Processing
Data Science
Data Visualization
Data Warehouse
Data Warehouse Architecture
Database
Databases
Design
Digital Marketing
ETL
Hr Technology
Informatica
Lead Data Engineering
Microsoft
Microsoft Power Platform
Power BI
Power Platform
Product Management
Reporting and Analytics
Software Development
SQL
Visual Design
Job Description
DR Decisions Resources LLC is seeking a Lead Product AI Data Engineer / Architect based in Ann Arbor, MI (onsite) to define, build, and scale enterprise-grade AI-ready data platforms for the Life Sciences and Healthcare ecosystem. This role combines deep dimensional modeling with enterprise architecture leadership to enable analytics and AI data workflows.
Responsibilities
- Define and evolve enterprise-level product data architecture across multiple product lines to support scalability, reliability, and AI/ML readiness.
- Architect scalable ETL/ELT pipelines and distributed data workflows for analytics, AI, and product intelligence.
- Develop and enforce dimensional data modeling standards, including star schemas and snowflake schemas, across the organization.
- Design and maintain fact and dimension tables, ensuring proper grain, SCD handling, hierarchical dimensions, and high-performance queries.
- Establish data architecture principles, naming conventions, and best practices for ETL/ELT, event tracking, and AI pipelines.
- Act as the technical authority guiding architecture decisions to meet product, platform, and AI requirements.
- Partner with cross-functional teams to translate requirements into scalable, analytics- and AI-ready data models and pipelines.
- Curate and validate datasets for machine learning, experimentation, and advanced analytics.
- Evolve event-driven architectures to align with dimensional modeling and downstream analytics.
- Establish feature store frameworks and reusable AI data pipelines across multiple products.
Required Qualifications
- 10+ years of professional experience in Data Engineering, Analytics Engineering, or Data Architecture.
- Proven experience in enterprise-scale data architecture and distributed pipeline design.
- Expert-level proficiency in SQL and relational database design.
- Strong hands-on experience in Python for pipeline automation, orchestration, and data framework development.
- Deep expertise in dimensional modeling, including star and snowflake schemas, fact and dimension tables, SCDs, surrogate keys, and hierarchical dimensions.
- Experience designing and operating production-grade ETL/ELT pipelines for analytics and AI/ML workloads, with strong ability to influence technical outcomes through architectural leadership and enterprise strategy.
- Experience with cloud data warehouses: Snowflake, Databricks, BigQuery.
- Familiarity with modern data orchestration and transformation tools: dbt, Airflow, Fivetran, Segment.
- Experience handling semi-structured and event-driven data (JSON, logs, clickstream).
- Exposure to BI and visualization tools: Power BI, Tableau, Looker, SAP BusinessObjects.
- Experience with AWS, Azure, or GCP, including data governance, security, and compliance frameworks.
- Background in Life Sciences or Healthcare analytics.
Technology Stack
SQL, Python, Snowflake, Databricks, BigQuery, dbt, Airflow, Fivetran, Segment, JSON, Power BI, Tableau, Looker, SAP BusinessObjects, AWS, Azure, GCP, ETL/ELT, Machine learning, AI/ML, SCDs, star schemas, snowflake schemas, fact/dimension tables, surrogate keys, hierarchical dimensions.
Role Focus: AI and Product Data Enablement
- Partner with cross-functional teams to translate requirements into scalable, analytics- and AI-ready data models and pipelines.
- Curate and validate datasets for machine learning, experimentation, and advanced analytics.
- Evolve event-driven architectures to align with dimensional modeling and downstream analytics.
- Establish feature store frameworks and reusable AI data pipelines across multiple products.
Location and Experience
- Location: Ann Arbor, MI (onsite)
- Minimum Experience: 10+ years
Similar Jobs
