Business Intelligence Analyst II Job Description
The IMS Data Science Team mission is to maintain marketplace leadership in car buying and expand our marketplace and vehicle services capabilities into ownership and next life. As part of this mission, we are continuously improving our product offering to meet the evolving needs of our customers. Enterprise dealer groups need better tools and richer insights to understand both rooftop and personnel performance. The IMS Data Science Team is working to enrich our current product offerings with new business intelligence utilities to address this underserved need.
The Business Intelligence Analyst II will be an integral part of the IMS Data Science Team mission by acquiring, synthesizing, and organizing business data from internal and external sources to create actionable insights in the form of automated reporting and visualization tools. Reports and visualizations should communicate a clear and concise story that provides immediate intelligence rather than data dumps requiring additional mining.
The ideal candidate will have an in-depth understanding of relational databases and a mastery of SQL. The candidate should also be a subject matter expert on the datasets backing the Cox Automotive inventory management applications. We strongly encourage candidates to have experience with Logi and MicroStrategy software. Experience with CSS and HTML is a plus.
Key Responsibilities

• Works closely with allied / supported functions and commercial teams to understand business priorities and key performance indicators (KPIs).
• Applies accepted methods and tools to identify, gather, develop, and analyze appropriate datasets.
• Produces business intelligence by querying data repositories and generating reports.
• Works with engineering teams to integrate business intelligence tools vAuto platform
• Works on standard, recurring and ad-hoc projects and analyses.
• Assists in the development and enhancement of data pipelines, workflows, and queries.
• Manages the flow of information including the integrity, efficiency, and availability of data.

Qualifications

• 4 years of experience in data analysis, business intelligence or software engineering.

• Strong SQL programming skills are required.
• Strong CSS and HTML programming skills are a plus.
• Demonstrated ability to work relational databases, preferably Snowflake.
• Demonstrated ability to build automated dashboards from developing raw data to presenting insights with a business intelligence tool. Experience with MicroStrategy or Logi Analytics is a plus.
• Ability to work effectively cross-functionally to ensure proper customer goals are achieved.
• Aptitude for identifying and solving data issues, ensuring data integrity, and an aptitude for addressing customer needs.
• Bachelor's degree in Sata Science, Information Technology, Computer Science, or related field or equivalent experience.

USD 77,800.00 - 116,700.00 per year
Compensation:
Compensation includes a base salary of $77,800.00 - $116,700.00. The base salary may vary within the anticipated base pay range based on factors such as the ultimate location of the position and the selected candidate's knowledge, skills, and abilities. Position may be eligible for additional compensation that may include an incentive program.
Benefits:
The Company offers eligible employees the flexibility to take as much vacation with pay as they deem consistent with their duties, the company's needs, and its obligations; seven paid holidays throughout the calendar year; and up to 160 hours of paid wellness annually for their own wellness or that of family members. Employees are also eligible for additional paid time off in the form of bereavement leave, time off to vote, jury duty leave, volunteer time off, military leave, parental leave, and COVID-19 vaccination leave.
About Cox Automotive
At Cox Automotive, people of every background are driven by their passion for mobility, innovation and community. We transform the way the world buys, sells, owns and uses cars, accelerating the industry with global powerhouse brands like Autotrader, Kelley Blue Book, Manheim and more. What's more, we do it all with an emphasis on employee growth and happiness. Drive your future forward and join Cox Automotive today!
About Cox
Cox empowers employees to build a better future and has been doing so for over 120 years. With exciting investments and innovations across transportation, communications, cleantech and healthcare, our family of businesses - which includes Cox Automotive and Cox Communications - is forging a better future for us all. Ready to make your mark? Join us today!
Benefits of working at Cox may include health care insurance (medical, dental, vision), retirement planning (401(k)), and paid days off (sick leave, parental leave, flexible vacation/wellness days, and/or PTO). For more details on what benefits you may be offered, visit our benefits page .
Cox is an Equal Employment Opportunity employer - All qualified applicants/employees will receive consideration for employment without regard to that individual's age, race, color, religion or creed, national origin or ancestry, sex (including pregnancy), sexual orientation, gender, gender identity, physical or mental disability, veteran status, genetic information, ethnicity, citizenship, or any other characteristic protected by law. Cox provides reasonable accommodations when requested by a qualified applicant or employee with disability, unless such accommodations would cause an undue hardship.
Statement to ALL Third-Party Agencies and Similar Organizations: Cox accepts resumes only from agencies with which we formally engage their services. Please do not forward resumes to our applicant tracking system, Cox employees, Cox hiring manager, or send to any Cox facility. Cox is not responsible for any fees or charges associated with unsolicited resumes.