Analytics Engineer

Job Description

Are you passionate about enabling analytics teams to make fast, confident, data-driven decisions? Do you enjoy building and optimizing the foundational data assets that power business intelligence? Do you thrive in a dynamic environment where you get to partner with diverse teams to solve complex data challenges? Join us in strengthening the data backbone of our product analytics capabilities. We are seeking an Analytics Engineer that partners with cross-functional teams within the organization to build, maintain, and optimize the data assets, BI infrastructure, and data engineering workflows critical for monitoring the health of Cox Automotive Consumer & Marketing Solutions products and businesses.

• Partners with cross-functional teams within the organization to make data-driven business decisions aimed at growth and business optimization.

• Builds and maintains foundational assets (e.g., Data Dictionary, Query Repository) that provide standards and records of data critical for monitoring the health of Cox Automotive Consumer & Marketing Solutions products and businesses. Works with stakeholders to find ways to optimize these assets.
• Collaborates with analysts to establish requirements for data assets, translating analysts’ metrics and analytics use cases into data asset development based on database schema or through coordination with data scrum teams across portfolios. Identifies opportunities to optimize existing assets, with a focus on runtime performance.

• Supports the development and maintenance of data models using dbt (data build tool) and SQL-based transformations deployed to Snowflake, following a structured model lifecycle from stakeholder intake through production deployment.
• Participates in version-controlled development workflows using Git Hub, including branching, pull requests, code review, and CI/CD pipeline processes to ensure reliable and repeatable data deployments.

• Supports the maintenance of data lineages that document metrics included in each report, along with their queries and data sources. Proactively suggests improvements to existing documentation to facilitate more efficient future updates and troubleshooting efforts.
• Contributes to semantic layer documentation and metadata that enable AI-powered analytics tools (e.g., Snowflake Cortex Analyst) to accurately interpret and respond to natural language queries against business data.

• Develops and maintains anomaly detection and alerting capabilities for data assets. Continuously improves detection methods and thresholds to ensure data quality and reliability.

• Applies advanced analytics methodologies and collaborates with analysts and/or scrum teams across portfolios to identify root causes of data anomaly alerts.

• With limited manager oversight, responsible for the administration of account access for analytics tools.
• Working with Manager, supports various BI tool strategy projects by focusing on optimizing existing platforms to ensure proper technologies that align with analytics needs.

• Maintains and optimizes technologies that enable the analytics practice and team operations, including SharePoint, operational insights, and various types of automation such as insights automation, workflow automation, and similar.
• Leverages AI/GenAI applications to augment task execution, improve workflow efficiency, and accelerate delivery of analytics operations deliverables.
• Must be able to learn and use analytics and other relevant technologies (e.g., web analytics tools, SQL-based databases, data visualization software, AI/GenAI capabilities). Must be able to work directly with vendors to resolve issues.

• Supports Analytics Leads or other leaders for company initiatives and projects; may lead project execution to meet milestones and timelines after working closely with Manager…