Quality Analytics Specialist – KPI Dashboards & Automation

Lincoln Motor Company; Dearborn (MI); On-site; USD 72,000 - 162,000; Full time

Benefits offered by this job

Medical coverage

Dental coverage

Tuition assistance

Vehicle discount program

Job summary

Ford Motor Company in Dearborn, MI, is seeking a data analytics professional to design, develop, and maintain analytics tools for Quality teams and enterprise customers. You will analyze diverse data sources, monitor performance, and partner with Ford IT and stakeholders to implement enhancements and ensure data quality.

You’ll lead data visualization, reporting, and cross-functional collaborations, driving improvements in KPI measurement and automation across the organization.

Qualifications

• Bachelor's degree in computer science, Physics, Mathematics, Engineering, or a closely related field.
• 5+ years of experience in data analytics, statistical analysis, or a related analytical role.
• 3+ years of experience with Python, SQL, VBA, and GCP tools for data processing and automation.
• 3+ years of experience creating dashboards and visualizations using Power BI or Looker Studio.
• 3+ year of experience automating processes within Microsoft Office applications, including Excel, PowerPoint, and Word.

Responsibilities

• Deep Data Analysis: Dive into internal and external data sources to uncover emerging trends, critical patterns, and any anomalies that need attention.
• Data Quality Assurance: Ensure the accuracy and completeness of our data sources, metrics, and reports – because reliable insights start with reliable data.
• Impactful Insights Reporting: Transform complex findings into clear, comprehensive reports that effectively communicate key insights and their potential business impact.
• Engaging Visualizations: Design and build compelling data visualizations that connect disparate data points, making weekly KPI status easy to understand at a glance.
• Process Enhancement: Document, streamline, and identify areas for automation within our processes to improve reaction times to KPIs, boost efficiency, minimize errors, and maintain data integrity.
• Quality Systems Management: Partner strategically with IT and Operating teams to manage requests for system enhancements, investigation of data quality issues and issue remediation and maintenance and delivery of training and supporting system documentation
• KPI Measurement Leadership: Take the lead in identifying and implementing new tools and data sources to refine how we measure our Key Performance Indicators, including establishing robust closed-loop feedback systems.
• Cross-functional Collaboration: Partner daily with functional teams to proactively identify and address gaps or errors in both our data and our processes.

Education

Bachelor's degree in computer science, Physics, Mathematics, Engineering, or a closely related field

Tools

Python

SQL

VBA

GCP

Power BI

Looker Studio

Excel

PowerPoint

Word

Job description

Ford Motor Company in Dearborn, MI, is seeking a data analytics professional to design, develop, and maintain analytics tools for Quality teams and enterprise customers. You will analyze diverse data sources, monitor performance, and partner with Ford IT and stakeholders to implement enhancements and ensure data quality.

You’ll lead data visualization, reporting, and cross-functional collaborations, driving improvements in KPI measurement and automation across the organization.