Analytics Engineer
Novi, MI, US, 48377
Dana is a global leader in the supply of highly engineered driveline, sealing, and thermal-management technologies that improve the efficiency and performance of vehicles with both conventional and alternative-energy powertrains. Serving three primary markets – passenger vehicle, commercial truck, and off-highway equipment – Dana provides the world's original-equipment manufacturers and the aftermarket with local product and service support through a network of nearly 100 engineering, manufacturing, and distribution facilities.
Job Purpose
We are seeking a highly skilled and motivated Analytics Engineer to join our growing data team. In this role, you will be responsible for designing, building, and maintaining robust data models and solutions using Microsoft Fabric, dbt (data build tool), and Power BI. You will play a critical role in transforming raw data into clean, reliable, and analytics-ready datasets that empower business users and data scientists across the organization.
Job Duties and Responsibilities
- Design and implement scalable data models and transformations using dbt within the Microsoft Fabric ecosystem.
- Collaborate with data analysts, data scientists, and business stakeholders to understand data needs and deliver high-quality datasets.
- Ensure data quality, consistency, and governance through testing, documentation, and version control.
- Optimize performance of data transformations and queries across large datasets.
- Monitor and troubleshoot data workflows and proactively resolve issues.
- Contribute to the development of best practices and standards for data modeling, transformation, and source control.
Required Qualifications
- 3+ years of experience in data engineering, analytics engineering, or a related field.
- Proficiency with dbt (Core or Cloud) for data transformation and modeling.
- Hands-on experience with Microsoft Fabric, including OneLake, Lakehouse, Warehouse, and Power BI artifacts.
- Strong SQL skills and experience working with large-scale data warehouses or lakehouses.
- Familiarity with Git-based version control and CI/CD practices.
- Excellent problem-solving skills and attention to detail.
- Strong communication and collaboration skills.
- Experience with Power BI semantic models and DAX.
We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class.
Unsolicited Resumes from Third-Party Recruiters
Please note that as per Dana policy, we do not accept unsolicited resumes from third-party recruiters unless such recruiters were engaged to provide candidates for a specified opening. Any employment agency, person or entity that submits an unsolicited resume does so with the understanding that Dana will have the right to hire that applicant at its discretion without any fee owed to the submitting employment agency, person or entity.
Nearest Major Market: Detroit