Analytics Engineer

Analytics Engineer role at Cox Automotive in Atlanta, GA (onsite) with a salary range of USD 101,500 to 169,100 per year.

Responsibilities

• Partner with cross-functional teams to drive data informed decision making for growth and business optimization.
• Build and maintain foundational assets such as a Data Dictionary and a Query Repository, establishing standards and traceability for monitoring the health of Cox Automotive Consumer & Marketing Solutions products; collaborate with stakeholders to optimize these assets.
• Collaborate with analysts to define data asset requirements, translating metrics and use cases into asset development based on database schemas or by coordinating with data scrum teams; identify opportunities to optimize assets with a focus on runtime performance.
• Support the development and maintenance of data models using dbt and SQL transformations deployed to Snowflake, following a lifecycle from stakeholder intake to production deployment.
• Participate in version controlled development workflows using GitHub, including branching, pull requests, code reviews, and CI/CD processes to ensure reliable data deployments.
• Maintain data lineages that document metrics in each report, their queries, and data sources; proactively suggest improvements to documentation to ease future updates and troubleshooting.
• Contribute to semantic layer documentation and metadata to enable AI powered analytics tools to interpret natural language queries against business data.
• Develop and maintain anomaly detection and alerting capabilities for data assets; continuously improve detection methods and thresholds to ensure data quality.
• Apply advanced analytics methods and collaborate with analysts or scrum teams to identify root causes of data anomaly alerts.
• With limited manager oversight, administer access to analytics tools.
• Support BI tool strategy projects with leadership, focusing on optimizing platforms to align with analytics needs.
• Maintain and optimize technologies that enable the analytics practice and team operations, including SharePoint, operational insights, and various automation such as insights and workflow automation.
• Leverage AI and GenAI applications to augment task execution, improve workflow efficiency, and accelerate delivery of analytics deliverables.
• Learn and apply analytics technologies (web analytics tools, SQL-based databases, data visualization software, AI/GenAI capabilities) and coordinate with vendors to resolve issues.
• Support Analytics Leads or other leaders on company initiatives; may lead project execution to meet milestones after aligning with leadership.
• Guide other analysts on advanced techniques and validate their work.
• Collaborate with managers to define priorities and deliver against business goals, working independently and with cross-functional teams.
• Operate with limited supervision; proactively optimize existing solutions.
• Travel up to 5 percent for same-day or overnight business trips.
• Perform other related duties as assigned.

Requirements

• 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 the future.
• Residence within commutable distance to the Atlanta office.
• Bachelor's Degree and 6+ years of experience, or 18 years of related experience.
• Intermediate SQL programming skills and knowledge of SQL based relational databases; experience with ETL processing of big data.
• 6+ years experience with SQL based relational databases (e.g., Athena, Redshift, Snowflake); Snowflake preferred.
• 6+ years experience with BI tools (Power BI, Domo, Tableau).
• Strong Microsoft Excel skills; proficiency with the Microsoft Office Suite.
• Web analytics knowledge (Google Analytics, Adobe Analytics) highly preferred.
• Experience with data transformation tools such as dbt, including model development, testing, and documentation preferred.
• Familiarity with version control systems (GitHub) and CI/CD workflows for data pipeline deployment.
• Experience with or willingness to learn Snowflake capabilities, including Cortex AI features for semantic layer and natural language analytics.
• Previous experience with AI/GenAI applications to augment tasks or workflows, including AI assisted development tools (Claude Code, GitHub Copilot).
• Ability to learn and apply AI/GenAI capabilities as part of analytics operations, including using large language models for code generation, documentation, data quality analysis, and automation.
• Previous experience with machine learning or automation, especially anomaly detection, threshold setting, or natural language generation, a plus.
• Tableau Server certification and AWS Data Analytics certification are pluses.
• Ability to work directly with vendors to resolve issues and support long term projects and initiatives.
• Willingness to learn and use analytics technologies (web analytics tools, work management software, AI/GenAI capabilities).
• Demonstrated ability to build relationships and collaborate across teams; capable of consulting stakeholders for optimal outcomes.
• Ability to anticipate stakeholders' needs and provide proactive solutions that strengthen partnerships.
• Ability to develop scalable processes and standards to improve team efficiency.
• Excellent communication skills; able to present findings clearly to stakeholders and translate analytical insights into a cohesive narrative.
• Creative problem solver who questions assumptions and tests hypotheses with data; translates requests into actionable tasks with timelines.
• Strong organizational and prioritization skills in a deadline-driven, evolving environment; flexible and adaptable to agile workflows.
• Proactive, self-motivated, with curiosity and a commitment to continuous learning in the digital and automotive spaces.
• Travel up to 5 percent.

Technologies

• dbt
• SQL
• Snowflake
• GitHub
• Power BI
• Domo
• Tableau
• Excel
• Google Analytics
• Adobe Analytics
• Snowflake Cortex Analyst
• Cortex AI
• SharePoint

Benefits

• Flexible vacation with pay
• Seven paid holidays per year
• Up to 160 hours of paid wellness annually
• Bereavement leave
• Time off to vote
• Jury duty leave
• Volunteer time off
• Military leave
• Parental leave

Compensation

• Base salary range: USD 101,500 to 169,100 per year
• Salary may vary by location and candidate knowledge, skills, and abilities
• Potential eligibility for additional compensation such as incentive programs