Lead AI Data Architect & Engineer – Product Platforms

DR Decisions Resources LLC; Ann Arbor (MI); Hybrid; USD 42,000 - 95,000; Full time

Job summary

DR Decisions Resources LLC is seeking a Lead Product Development AI Engineer to design and optimize end-to-end data architecture and scalable data platforms powering product analytics and AI-driven capabilities.

The role targets professionals with 7+ years in data engineering, analytics, or architecture-heavy roles, proficient in SQL, Python, and dimensional modeling. Hybrid work and cloud data warehouse expertise are highly valued.

Qualifications

• 7+ years of professional experience in data engineering, analytics engineering, or data architecture-heavy roles.
• Expert-level proficiency in SQL and relational database design.
• Strong programming experience in Python for data pipelines and automation.
• Deep hands-on experience with data architecture and dimensional data modeling (star/snowflake schemas).
• Experience designing and operating ETL/ELT pipelines for production analytics and AI/ML workloads.
• Ability to influence technical outcomes through architectural leadership and collaboration.

Responsibilities

• Own and evolve product-level data architecture, ensuring scalability, reliability, and alignment with analytics and AI/ML use cases.
• Design and implement scalable data pipelines supporting product analytics, user behavior tracking, and AI/ML initiatives.
• Define and maintain enterprise-aligned dimensional data models (star and snowflake schemas).
• Design and maintain fact and dimension tables with correct grain, performance, and consistency.
• Contribute to data architecture standards, naming conventions, and ETL/ELT best practices within product teams.
• Provide architectural guidance to ensure data solutions align with product requirements and platform constraints.

Skills

SQL

Python

Data architecture

Dimensional data modeling

ETL/ELT pipelines

SCDs & surrogate keys

Data pipelines

BI tools

Architecture leadership

Tools

Snowflake

Databricks

BigQuery

Redshift

dbt

Airflow

Fivetran

Segment

Job description

DR Decisions Resources LLC is seeking a Lead Product Development AI Engineer to design and optimize end-to-end data architecture and scalable data platforms powering product analytics and AI-driven capabilities.

The role targets professionals with 7+ years in data engineering, analytics, or architecture-heavy roles, proficient in SQL, Python, and dimensional modeling. Hybrid work and cloud data warehouse expertise are highly valued.