Customer Data Consultant / Analyst

Ford Motor Company - Dearborn, MI (30+ days ago)4.2

Job Description

Job Description/Overview:
This role falls under Data Operations within the Ford GDIA organization which was formed to support Ford’s Blueprint for Mobility strategy. The Data Operations team is responsible for ingesting data into the Ford GDIA big data environment, as well as cleansing, standardizing, and preparing that data for the downstream use of our business partners. In this role you will support Ford’s Intelligent Customer Interactions group working with data scientists to build and support analytical models as well as the campaign teams to execute against the goals of our marketing business customers.

You will be responsible for providing the data support for enterprise data integration tasks, including ingestion, standardization, enrichment, mastering and assembly of data products for downstream applications. In addition, you will:
Drive the data strategy and align it with continuously changing business landscape
Work primarily with customer data but can also expect to work with other data types across the enterprise including dealer, vehicle, manufacturing, etc.
Evaluate, explore, and select the right data platform technologies including Big Data, RDBMS & NoSQL to meet the analytics requirements of a given project
Serve as general data consultant to answer ad-hoc questions about a given data source – contents, usage, accessibility, etc.
Understand the goals and requirements of our business partners and develop work flows or scripts to wrangle data to meet those needs
Drive data profiling and data exploration for basic understanding and profiling of the data
Provide visibility to data quality issues and work with the business owners to fix the issues
Perform any necessary data mapping, data lineage activities and document information flows
Build the metadata model & business glossary by gathering information from multiple sources: business users, existing data sources, databases and other relevant documents and systems

Job Requirements

Basic Qualifications:
Bachelor’s degree is required
5 years of experience in a Data Management role including writing, troubleshooting, and running SQL queries and compiling data for analytics or reporting use
3 years of experience in data design, data architecture and data modeling (both transactional and analytic)

Preferred Qualifications:
Master’s degree in Informatics, Business, Economics or related field
Consulting experience preferred
Experience in Big Data technologies including Hadoop (HDFS, MapReduce, Hive, Spark, etc.)
Ability to work with different database technologies and platforms including Big Data / Hadoop, RDBMS and NoSQL.
Experience in creation of scripts to manipulate files within HDFS is preferred
Knowledge of data transfer and ingestion technologies including Attunity
Demonstrated experience building visualizations using Tableau/Qlikview
Ability to write complex SQL queries needed to query & analyze data
Knowledge of data management standards, data governance practices and data quality
Ability to communicate complex solution concepts in simple terms
Ability to apply multiple solutions to business problems
Ability to quickly comprehend the functions and capabilities of new technologies
Strong Oral and written communication skills

Desired Characteristics
Ability to execute small and medium projects working through dependencies across multiple workstreams and coordinating input from more than one team
Demonstrated customer focus, with the ability to evaluate decisions through the eyes of the customer, build strong relationships, and create processes with customer viewpoint
Strong analytical and problem solving skills, with the ability to communicate in a clear and succinct manner and effectively evaluates information / data to make decisions
Strong interpersonal, and leadership skills, with proven abilities to communicate complex topics to leaders and peers in a simple, clear, plan oriented manner
Ability to anticipate obstacles and develop plans to resolve those obstacles
Change oriented, with the ability to actively generates process improvements, support and drives change, and confront difficult circumstances in creative ways
Resourceful and quick learner, with the ability to efficiently seek out, learn, and apply new areas of expertise , as needed
Highly self-motivated, with the ability to work independently
Superior organization, coaching and interpersonal skills, combined with effective leadership, decision-making, and communication
Strong oral and written communication skills (English)
Strategic and clear thinking to translate discreet and complex ideas to business-driven results
Detail-oriented with a strong drive to enforce common standards

The distance between imagination and …. Creation. It can be measured in years of innovation, or in moments of brilliance. And, it can be a road you start traveling right now. When you join Ford Motor Company, your journey begins. You become part of a team that is already leading the way, with ingenious solutions and attainable products – and it is always ready to go further.

Candidates for positions with Ford Motor Company must be legally authorized to work in the United States on a permanent basis. Verification of employment eligibility will be required at the time of hire. Visa sponsorship is not available for this position.

Ford Motor Company is an equal opportunity employer committed to a culturally diverse workforce. All qualified applicants will receive consideration for employment without regard to race, religion, color, age, sex, national origin, sexual orientation, gender identity, disability status or protected veteran status.