Data Analyst
Location: Dearborn, MI
Duration: 12 months
Description: Position Description:
Responsible for developing and supporting analytic deliverables to the business.
Deliverables include (but are not limited to) sales and business performance reporting, campaign and marketing program analytics, dealer and customer analytics as well as dashboard development or other data visualization to assist with business consumption of insights.
Strategic ad hoc analyses to support overall business strategy, day to day business decisions and provide a deeper understanding of business, marketing campaign and customer behavior past and future trends.
Work with business partners to identify analytic needs, understand key business challenges and answer key business questions while working with data and analytics team members to deliver insights.
Skills Required:
Excellent Data Wrangling skills - Ability to query, join, manipulate data (e.g., create new variables as needed), automate processes.
Experience analyzing business and marketing program performance (e.g., response, sales, incremental sales, net profit, customer profiling), ad hoc exploratory analyses, etc.
Strong knowledge of SQL, Alteryx, Qlik (dashboarding), GCP, Big Query and Microsoft Office preferred.
Subject Matter Expertise in sales, business, and program reporting
Subject Matter Expertise in Customer Analytics, Customer Experience Analytics, Program Analytics
Ability to develop and support Business Performance Metrics and Reporting (BPR) •Familiarity with automotive service and parts business (not required)
Experience meeting with clients directly to understand business needs and discuss findings.
Ability to organize findings for business consumption create PowerPoints containing graphs and insights
Ability to present findings to the client and in team meetings
Skills Preferred:
Experience with complex problem solving - data manipulation, data quality, statistical analysis and/or reporting.
Highly proficient utilizing SQL and Alteryx, tableau, Qlik, etc.
to manipulate, arrange, query, visualize and present data.
•Excellent interpersonal skills with people at all management and organizational levels
Team player able to collaborate across departments and skill sets to meet client deliverables
Ability to respond in an effective and timely manner
Subject matter expert in an analytics specialty
BA / BS or advanced degree in Statistics, Mathematics, Data Science, Econometrics or Computer Science, Analytics, Finance, etc.
Min 5-year experience+ as analyst
Inventive 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
Strong oral and written communication skills (English) -Strategic and clear thinking to translate discreet and sophisticated ideas to get results
Attention to detail with a strong drive to enforce common standards
Demonstrated acceptance and adherence to high ethical, moral, and personal value
Experience Required:
5+ years in analytics
Education Required:
BS is related field
As an equal opportunity employer, ICONMA provides an employment environment that supports and encourages the abilities of all persons without regard to race, color, religion, gender, sexual orientation, gender identity or express, ethnicity, national origin, age, disability status, political affiliation, genetics, marital status, protected veteran status, or any other characteristic protected by federal, state, or local laws.