Data Analyst II

Summary

Cox Automotive is a company focused on technology and experiences for drivers and dealers. The Data Analyst II supports Mobile Inspections by building and maintaining reports, dashboards, data processes, and analyses that help leaders understand operational performance and make informed decisions. The role partners with Operations, Quality Assurance, Dispatch, engineering, and other business teams to deliver reporting, analyze trends, and support business needs.

Responsibilities

• Perform analysis: Work on service, auction lifecycle of vehicle. Define business questions. Collaborate with engineering teams to identify data sources and queries. Tidy, clean and transform data. Analyze data and identify trends. Visualize data. Draw conclusions, present insights and tell compelling stories
• Support data science: Help data-science and data-engineering teams perform and implement complex analyses. Select key problems to solve. Define goals. Source data. Share domain knowledge. Identify data features. Measure outcomes. Tune performance
• Build data processes: Lead projects to build better data processes. Understand input data, output data and transformations required to bridge the two. Work with data suppliers. Design, build and manage processes to deliver required data. Ensure data quality. Help manage projects to build new, and to improve existing, data pipelines. Drive deliverables. Measure KPI. Report progress to leadership
• Support product management: Understand opportunities and competition around service, pricing and repair data. Interview customers and stakeholders. Research new features and sources of product differentiation. Be the liaison between technology and product strategy. Define KPI. Be technology’s go-to person for questions related to Operational Data, integration with other systems
• Performs data analysis and validation
• Translates data into meaningful insights
• Develops reports and data visualizations to present insights in the most effective way to enable decision making
• Monitors and analyzes key metrics and executes recurring analyses and reporting
• Mines and interprets data, monitors and analyzes key metrics and interprets performance and provides insight into the data and metrics generated
• Handles data preparation and data analysis portions of various projects
• Writes, maintains and/or updates queries to develop analyses in response to queries from internal customers
• Ensures accuracy of results produced as a result of data analysis
• Coordinates data feeds and updates and sources additional data required for analysis
• Determines the value of new internal and external data sources, merges disparate data sets, ingests data, cleans and munges data, derives metrics, and transforms the data into usable information
• Assists development teams in creating and maintaining data reporting models
• Assists in the development and implementation of data monitoring and measurement systems
• Develops monitoring mechanisms for quality and data management purposes
• Builds and validates new derived metrics and associated business rules
• Ensures the quality of specific data stores for collection, tracking and reporting of research data
• Other duties as needed or required
• Requires physical ability and mental acuity to execute the duties of the position successfully within required timeframes in order to meet business requirements

Skills

• Applicants must currently be authorized to work in the United States for any employer without current or future sponsorship. **No OPT, CPT, STEM/OPT or visa sponsorship now or in future.**
• BS/BA Degree in related discipline **plus 2 years** of relevant experience or an equivalent combination of education and work experience in related field required
• 2+ years experience building and maintaining reporting and dashboards
• 2+ years' experience troubleshooting or supporting web-based applications
• 2+ years' experience with databases and database query tools (Snowflake)
• Experience with the following technology areas: SQL, Alteryx, Snowflake, AWS
• 2+ years of performing analysis and building data processes
• Strong experience with reporting tools (PowerBI required)
• Working experience conducting quantitative and qualitative analysis
• Working experience working with SQL (Oracle, MS-SQL, DB2)
• Working experience working with large scale datasets
• Working experience presenting data to leadership for decision making
• Knowledge of data extrapolation, interpretation and chart compilation
• Working experience with SQL and strong Stored Procedures
• Power user of the MS Office suite, including Excel and PowerPoint, for doing business analysis
• Passion for analysis and focus on business results. Entrepreneurial mindset
• Effective written, listening and oral communications
• Collaborative nature and the ability to balance vision and execution

Qualifications

Must Haves

• Applicants must currently be authorized to work in the United States for any employer without current or future sponsorship. **No OPT, CPT, STEM/OPT or visa sponsorship now or in future.**
• BS/BA Degree in related discipline **plus 2 years** of relevant experience or an equivalent combination of education and work experience in related field required
• 2+ years experience building and maintaining reporting and dashboards
• 2+ years' experience troubleshooting or supporting web-based applications
• 2+ years' experience with databases and database query tools (Snowflake)
• Experience with the following technology areas: SQL, Alteryx, Snowflake, AWS
• 2+ years of performing analysis and building data processes
• Strong experience with reporting tools (PowerBI required)
• Working experience conducting quantitative and qualitative analysis
• Working experience working with SQL (Oracle, MS-SQL, DB2)
• Working experience working with large scale datasets
• Working experience presenting data to leadership for decision making
• Knowledge of data extrapolation, interpretation and chart compilation
• Working experience with SQL and strong Stored Procedures
• Power user of the MS Office suite, including Excel and PowerPoint, for doing business analysis
• Passion for analysis and focus on business results. Entrepreneurial mindset
• Effective written, listening and oral communications
• Collaborative nature and the ability to balance vision and execution

Benefits

• Can work remotely anywhere in the specified country
• Position may be eligible for additional compensation that may include an incentive program.
• Eligible employees may 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
• Up to 160 hours of paid wellness annually for their own wellness or that of family members
• Additional paid time off in the form of bereavement leave, time off to vote, jury duty leave, volunteer time off, military leave, and parental leave
• Health care insurance (medical, dental, vision) may be offered
• Retirement planning (401(k)) may be offered
• Paid days off, including sick leave, parental leave, flexible vacation/wellness days, and/or PTO, may be offered