QA Analyst/Senior Data Analyst

QA Analyst -(Senior Data Analyst)

The Esntial eCommerce Analytics Team at Cox Automotive is looking for top talent who are excited to reimagine the way people buy and sell cars online and who want to advance the way it’s done through the power of data and advanced analytics.

The QA Analyst (Senior Data Analyst) is part of the Esntial eCommerce Analytics team, you will collaborate with key business stakeholders, SMEs across the organization such as Sales, Business Operations and Product Marketing to gather requirements, build, test and deliver Data needs for Advanced Analytics tools and self-service reporting to advance the goals of the eCommerce business.

Part QA Analyst and part Developer, you will use your curiosity and collaboration expertise to define outcome-based requirements that enable quick insights and clear direction on optimization opportunities. You will use your estimation and time management skills to focus your stakeholders on what matters the most to be able to deliver iterative solutions in a fast-paced environment. All the while, your capabilities will be used across a growing client base and to drive eCommerce outcomes in a highly visible part of the organization.

Responsibilities:

Process Structured and Unstructured Data into Curated Metrics:

Gathers and processes raw, structured, semi-structured, and unstructured data using batch and real-time data processing frameworks.
Understands and enforces appropriate data master management techniques.
Leverages SQL expertise to curate key performance indicators and metrics to drive business decisioning.
Data Validation and Quality

Ensures data quality and implements tools and frameworks for automating the identification of data quality issues through proactive monitoring, anomaly detection and alerting.
Work with internal and external data providers on data validation providing feedback and making customized changes to data feeds and data mappings.
Execute test plans and perform QA to assure the functionality and integrity of the data models.
Partner with the Business Intelligence team to ensure all data requirements are met and data sources have been optimized for reporting and dashboard performance.
Product Development and Maintenance

Implements and optimizes data solutions in enterprise data warehouses and big data repositories.
Installs, maintains, monitors, and supports business intelligence, distributed computation, and big data analytics tools.
Provides ongoing support, monitoring, and maintenance of deployed products.
Actively works with less experienced data engineers providing technical guidance and oversight.
Actively participates in the engineering community, staying up to date on new data technologies and best practices and shares insights with others in the organization.
Participate in agile scrum routines and deliver in an agile scrum framework.
Candidates from the Eastern and Central Time Zones preferred.

Remote role

Up to 5% travel required.

Required Qualifications:

Bachelor’s degree in a related discipline and 4 years experience in a related field. The right candidate could also have a different combination, such as a master’s degree and 2 years experience; a Ph.D. and up to 1 year of experience; or 8 years experience in a related field.
Must have hands-on experience in building data pipelines and data warehouse ETL tools.
Must be comfortable navigating large, complex, and possibly disparate data sets and transforming and/or joining from those sets using SQL.
Must have expertise in creating business requirements documents and experienced in testing data processes and creating data validation documents.
Must have experience in building dashboards and monitoring reports in tools like Tableau using blended data sources.
Must have hands on experience at least one data warehouse software (Google Cloud Platform, AWS Redshift or Snowflake).
Experience in performing root cause analysis, unit testing, defect management and managing escalation communications.
Ability to quickly adapt to a changing environment and adjust to rapid changes in deadlines and priorities.
Experience working to deliver within an agile scrum framework.
Excellent written and verbal communication skills are a must.
Must be able to work Eastern Time Zone hours.
Preferred Qualifications:

An ideal candidate will have a combination of Analytics consultancy experience or worked in an Analytics and Business Intelligence consulting capacity within a large organization.
Experience with Python and ability to write programs for ETL purposes.
Hands on experience navigating large, complex, and possibly disparate data sets using SQL within a data warehouse is preferred.
Experience with AWS data engineering tools or Google Cloud Platform a plus.
Working experience using business intelligence tools (PowerBI, Tableau, Domo) is preferred.
Strong analytical mindset and ability to clearly communicate solution options and tradeoffs preferred.
Self-directed, driven, and enthusiastic. Has the ability to work in an ambiguous and fast paced start up environment.
Desired to have Automotive experience and understanding of Dealer and Consumer Metrics and Analytics.
Strong teambuilding skills with demonstrated problem-solving abilities.

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.

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.