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 Teammission 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 requiringadditional 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 datarepositories 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 skillsare required.
Strong CSS and HTML programming skills are a plus.
Demonstrated ability to workrelational 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 Data Science, Information Technology, Computer Science, or related field or equivalent experience.
Drug Testing
To be employed in this role, you’ll need to clear a pre-employment drug test. Cox Automotive does not currently administer a pre-employment drug test for marijuana for this position.
However, we are a drug-free workplace, so the possession, use or being under the influence of drugs illegal under federal or state law during work hours, on company property and / or in company vehicles is prohibited.
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 Us
Through groundbreaking technology and a commitment to stellar experiences for drivers and dealers alike, Cox Automotive employees are transforming the way the world buys, owns, sells or simply uses cars.
Cox Automotive employees get to work on iconic consumer brands like Autotrader and Kelley Blue Book and industry-leading dealer-facing companies like vAuto and Manheim, all while enjoying the people-centered atmosphere that is central to our life at Cox.
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.