Analytics Scientist

Jobtailor; Dearborn (MO); On-site; USD 110,000 - 140,000; Full time

Job summary

Ford Motor Company seeks a data product professional to own end-to-end development of analytics data products for Ford Customer Service Division.

You will translate user needs into actionable data requirements, lead discovery with analytics teams, and engage cross-functional stakeholders to integrate solutions with existing systems. Collaboration with data scientists and business stakeholders aims to drive growth and enhance dealer satisfaction.

Qualifications

• Bachelor’s degree or foreign equivalent in Computer Science, Computer Engineering, or related field with 5 years of progressive post-baccalaureate experience.
• 5 years of experience with SQL for data mining and writing efficient queries.
• 5 years of experience with data visualization tools (Qlikview, Business Objects, Cognos).
• 5 years of experience with ETL/data warehousing and BI tech (Teradata, Hadoop, Informatica).
• Experience performing validation and user acceptance testing for business process solutions.
• Experience translating design requirements into functional specifications and data curation including Informatica and Cognos.

Responsibilities

• Own end-to-end development of data products to support analytics within Ford Customer Service Division.
• Translate user needs into actionable data requirements for curated data products.
• Lead data analysis and discovery with analytics teams for new data product development.
• Engage stakeholders across cross-functional teams throughout development lifecycle.
• Collaborate with data scientists and business stakeholders to drive growth and customer satisfaction for Ford/Lincoln dealers.
• Lead design and development of data models and products using BigQuery, Informatica, EDC, and data privacy platforms.
• Develop data governance frameworks and security models to ensure data integrity and compliance.
• Architect scalable solutions for fast response times across business cases.
• Integrate heterogeneous data sources across platforms to support high-quality data products.
• Deliver data-driven solutions to achieve profitability and high customer satisfaction.
• Ensure products are scalable and provide reliable performance.

Skills

SQL

Data mining

Data visualization

Data modeling

Data governance

Education

Bachelor’s degree in Computer Science, Computer Engineering, or related field

Tools

Qlikview

Business Objects

Cognos

Informatica

Teradata

Hadoop

Job description

Responsibilities

• Take ownership of end-to-end development of data products to support analytics consumption within the Ford Customer Service Division.
• Translate user needs into actionable data requirements, ensuring the curated data products effectively address business challenges.
• Lead data analysis and discovery efforts in collaboration with analytics teams to gather comprehensive details and requirements for new data product development.
• Actively engage stakeholders from cross‑functional teams throughout the development lifecycle to solicit feedback, enhance product features, and ensure seamless integration into existing systems or processes.
• Collaborate closely with data scientists, business stakeholders, and other team members to drive profitable growth and enhance customer satisfaction for Ford/Lincoln dealers.
• Lead architectural design and development of robust data models and data products utilizing GCP BigQuery, Informatica BDM/DEI, EDC, and Data Privacy Management platforms.
• Develop and execute comprehensive data governance frameworks and security models to ensure data integrity, compliance, and accessibility.
• Architect and develop scalable product solutions designed for optimal response times and applicability across diverse business cases.
• Facilitate integration of heterogeneous data sources across multiple platforms to support the development and consumption of high‑quality complex data products.
• Deliver impactful data‑driven solutions to achieve profitable growth and maintain high levels of customer satisfaction.
• Apply expertise to ensure products are scalable and provide effective solutions for a wide range of business cases with reliable performance.
• Work collaboratively with cross‑functional teams while demonstrating the ability to independently perform tasks and drive projects to successful completion.

Requirements

• Bachelor’s degree or foreign equivalent in Computer Science, Computer Engineering, or a related field and 5 years of progressive, post‑baccalaureate experience in the job offered or a related occupation.
• 5 years of experience with each of the following skills is required:
• Utilizing RDBMS technologies including SQL for data mining by writing efficient database queries and applying techniques including indexing, triggers, and other performance optimization methods.
• Leveraging data visualization tools and experience on creating customer reporting and dashboards with tools including Qlikview, Business Objects, or Cognos.
• Utilizing Data warehousing (ETL) and Business Intelligence technologies to implement solutions in big data technologies including Teradata, Hadoop, or Informatica.
• Performing validation and user acceptance testing for business process solutions.
• Translating high‑level design requirements into functional specifications and providing actionable business insights and decision support based on data curation including Informatica and Cognos skills.
• Designing and implementing large‑scale logical, physical, or metadata data models.
• 3 years of experience with each of the following skills is required:
• Formulating data management standards and applied data governance practices aligned with data privacy regulations including CCPA and GDPR for large‑scale rollouts to internal teams.