Analytics Engineer

• Design, build, and maintain scalable data models in Amazon Redshift to support reporting, dashboards, and ad hoc analysis.
• Collaborate with data engineering teams to expand and optimize the analytics warehouse architecture.
• Establish and enforce standards for schema design, naming conventions, and data lineage.
• Develop, maintain, and optimize data pipelines that deliver clean and reliable data to business users.
• Partner with stakeholders to gather requirements and translate business needs into scalable data solutions.
• Create and maintain comprehensive data documentation, including metrics definitions and transformation logic.
• Support BI platforms by ensuring analytics-ready datasets and assisting with dashboard development.
• Monitor data quality and implement testing, alerting, and validation processes to ensure warehouse reliability.
• Identify opportunities to improve data accessibility, consistency, and usability across the organization.
• Promote best practices in analytics engineering, including version control, code reviews, and reproducible workflows.

Analytics Engineer – Digital Media

• Implement the curated data model layer in dbt across 18 data domains, working closely with the Onshore Analytics Engineering Lead.
• Design and build dbt models across the full layered architecture: staging, intermediate, and mart layers.
• Implement comprehensive dbt testing strategies, including unique, not_null, accepted_values, relationships, and custom tests to ensure data quality and reliability.
• Develop and optimize incremental models to handle high-volume domains processing billions of events efficiently.
• Generate and maintain thorough project documentation, including column descriptions and lineage graphs, to support transparency and team collaboration.

See all jobs on JobTailor

Analytics Engineer – Digital Media

Analytics Engineer