Data Analytics Engineer

Ford • Dearborn, MI

77d

About The Position

This role focuses on the development and maintenance of comprehensive Verification & Validation (V&V) Key Performance Indicator (KPI) dashboards. These dashboards are designed to be intuitive, providing critical insights into V&V readiness and quality trends for both the internal V&V team and CVS executive management. The position involves close collaboration with the CVS data management team to establish and maintain robust data connections, ensuring seamless integration with other relevant organizational dashboards. All dashboard creation and deployment must adhere to Ford's compliant toolchain. Tailored to V&V Goals Dashboards are customized to align with the specific strategic objectives and informational needs of executive management. This ensures that the data presented is directly relevant to their decision-making processes. Simplicity and High-Level Overview Recognizing that executives have limited time, the dashboards prioritize simplicity by presenting only essential information and avoiding an overcrowded display. They provide a quick 'temperature check' of V&V performance rather than overwhelming detail. Organized for Insight Information is structured to naturally draw the executive's attention to the most important and actionable insights. This often means placing the most critical metrics and KPIs at the top, following natural reading patterns. Clear Visual Design Intuitive dashboards utilize clear and easy-to-understand charts, graphs, and other visualizations. Consistent color schemes enhance readability and highlight critical insights without distraction. Accessibility is also considered in color choices. Focus on Key Performance Indicators (KPIs) The dashboards center around V&V readiness and quality trends, which serve as crucial KPIs. These indicators are presented in a simplified, easily digestible format, allowing executives to quickly grasp the health and performance of V&V activities. Actionable Insights and Storytelling Beyond just presenting data, the dashboards are designed to provide actionable insights. They aim to tell a compelling story, guiding decision-making by highlighting opportunities, identifying risks, and indicating areas that require immediate attention or adjustment. Real-time Data and Interactivity Dashboards are powered by real-time data to ensure executives have access to the most current information, enabling timely and informed decisions. Interactive elements, such as drill-down capabilities, allow executives to explore specific details if needed, transforming static data into a dynamic tool. Proactive Information The dashboards are designed to be proactive, helping executives understand not just past performance but also current trajectory, allowing them to anticipate future needs and make timely adjustments or pivots to their strategies.

Requirements

• Bachelor's Degree in data analytics, data science, statistics, or Engineering.
• 3+ years of experience in automotive data analytics.
• 2+ years experience using SQL, Programming Languages (R or Python), and Data Visualization Tools: Microsoft Power BI, Qlik, Grafana, Jira Analytics.
• 1+ year of experience in automotive software testing.

Nice To Haves

• Master's Degree in data analytics, data science, statistics, or an MBA in business analytics.
• Certifications: Google Data Analytics Certificate, Microsoft Certified: Power BI Data Analyst Associate, Tableau certifications, or the Certified Analytics Professional (CAP).
• Data Cleaning and Wrangling.
• Machine Learning Basics.
• Data Management per Ford IT standard.

Responsibilities

• Gather data from various sources, ensuring its accuracy and completeness.
• Integrate data from disparate systems to create a unified data source for analysis.
• Clean and preprocess data to ensure it's suitable for analysis.
• Use statistical methods and data analysis tools to interpret data and extract actionable insights.
• Create scripts to connect data from V&V tool chains (e.g Jira, Jama, Testrail, dSpace, NI, ECUTest, Github, etc.).
• Design and create interactive dashboards using tools like Tableau, Power BI, or similar platforms.
• Develop key performance indicators (KPIs) and metrics to monitor business performance.
• Ensure that dashboards are updated in real-time or at appropriate intervals to reflect the latest data.
• Work closely with business stakeholders to understand their data needs and ensure that dashboards and reports meet those requirements.
• Generate regular and ad-hoc reports to provide insights into various aspects of business performance.
• Ensure that data handling practices comply with organizational data governance policies and security standards.
• Provide support and training to end-users to help them understand and effectively use data analytics tools and dashboards.
• Continuously seek ways to improve data processes, tools, and techniques to enhance the quality and efficiency of data-driven decision-making.

Benefits

• Immediate medical, dental, vision and prescription drug coverage.
• Flexible family care days, paid parental leave, new parent ramp-up programs, subsidized back-up child care and more.
• Family building benefits including adoption and surrogacy expense reimbursement, fertility treatments, and more.
• Vehicle discount program for employees and family members and management leases.
• Tuition assistance.
• Established and active employee resource groups.
• Paid time off for individual and team community service.
• A generous schedule of paid holidays, including the week between Christmas and New Year's Day.
• Paid time off and the option to purchase additional vacation time.

What This Job Offers

• Career Level: Mid Level
• Industry: Transportation Equipment Manufacturing
• Education Level: Bachelor's degree