Depending on experience

Work location: Dearborn, MI (hybrid)

Essential Job Functions:

Top Qualifications for this Role

• High proficiency in Python/PySpark, Alteryx and SQL for data manipulation and translation
• Programming SQL in a cloud-based distributed data environment
• Proficiency in Business Intelligence tools: Domo or Datorama
• Familiarity with APIs, RSS feeds and web services

The Day-to-Day

• Data wrangling and ingestion of data sources from multiple parties into analytics platforms such as a DMP or Data Lake environment.
• Devise business rules for data acceptance, translation and mapping.
• Transform data feeds into reliable and easily updatable data extracts for use in reporting and modeling.
• Collaborate with stakeholders to build and upgrade reports leveraging analytics tools.
• Identify data relationships and develop solutions in various data blending tools.
• Identify and supply proper data sets, write required rules and extract data sets for use by team members and partners.
• Prioritize requests from multiple stakeholders, create project plans, determine level of effort, and maintain milestones.
• Coordinate communication with internal teams.

Minimum Qualifications and Job Requirements:
Work Experience:
Experience working in analytics, research, business intelligence or IT (5 years).
Data engineering within digital marketing/advertising, automotive preferred (5 years).
Experience automating routine data tasks using various software tools.
Experience creating data visualizations, dashboards, executive reports or models.
Education:
Bachelor's degree from a four-year college or university in Computer Science, MIS, Mathematics, Statistics, Economics or other quantitative discipline.

Other Responsibilities:

• Abide by the policies, procedures, and Code of Conduct of the company.
• Handle personal information ('PI') that pertains to any individual (e.g., leads, dealers, employees, job applicants, etc.) in accordance with Client's Privacy Policy and public facing privacy statements on client's managed websites.
• Complete any required training.
• Promptly report any known or suspected loss, theft or unauthorized disclosure or use of PI to the General Counsel/Chief Compliance Officer or Chief Information Officer.
• Adhere to the company's compliance program.
• Safeguard the company's intellectual property, information, and assets.
• Other duties as assigned.