Data Analyst / Data Engineer

The Lead Product Development Data Engineer role in Auburn Hills focuses on designing and operating core data processes and analytics applications that support the Product Development Process (PDP). The position bridges Engineering with enterprise functions to standardize data workflows and deliver scalable analytics solutions across cloud platforms, including support for AI and predictive analytics.

Responsibilities

• Build, improve, and maintain big data pipelines and architectures using Snowflake, Databricks, or Microsoft Fabric.
• Create scalable data models and storage solutions such as Lakehouse and DirectLake using SQL, Python, PySpark, and cloud tooling across Azure or AWS.
• Modernize legacy data workflows by moving them to cloud architectures while establishing data governance, pipeline security, and data lineage.
• Promote global consistency through documentation and continuous refinement across assigned PDP processes and digital applications.
• Develop, deploy, and maintain executive-level dashboards and reporting tools using Power BI, PowerApps, and Palantir Foundry.
• Support operational alignment by streamlining cross-functional engineering tasks using Power Automate and Microsoft 365 tools.
• Collaborate with IT, Manufacturing, Finance, Purchasing, and Program Management to capture technical requirements and align solutions with business goals.
• Assist with the integration of machine learning models and predictive analytics into existing engineering data pipelines.
• Communicate complex technical details and process trade-offs into decision-ready packages, business cases, and leadership presentations.

Requirements

• Bachelor of Science degree in Engineering from an accredited program.
• Hands-on experience with Snowflake or Databricks.
• Proficiency in SQL, Python, and/or PySpark.
• Proven experience with data modeling and tools including Power BI, SharePoint, PowerApps, Power Automate, Azure, and/or Palantir Foundry.
• Hands-on experience with modern cloud architectures, including Microsoft Fabric (including Lakehouse, DirectLake, DAX, and Dataflows) and/or AWS services.
• Demonstrated leadership, strong organizational skills, self-starter mindset, and fluent English communication with the ability to present across all management levels.

Technologies

Snowflake, Databricks, Microsoft Fabric, Microsoft Fabric Lakehouse, DirectLake, SQL, Python, PySpark, Lakehouse, DAX, Dataflows, Azure, AWS, Power BI, PowerApps, Palantir Foundry, Power Automate, Microsoft 365, SharePoint

Preferred Qualifications

• Master’s degree in Data Science, Business Analytics, Computer Science, Information Technology, or a related field.
• Experience supporting core engineering processes such as Sourcing, Quality, Validation, Manufacturing, Logistics, or Program Management.
• Experience integrating predictive models or AI capabilities into production data pipelines.
• Proven ability in business process mapping, writing Business Requirements Documents (BRDs), and documenting technical processes.
• Familiarity with open-source frameworks such as Apache Spark or Hadoop.