Senior Data Engineer

Job Summary

At OUTFRONT Media, a leader in Digital Out of Home (DOOH) advertising, we blend cutting‑edge technology with our nationwide network of digital billboards and transit displays to create innovative solutions. We are seeking a Senior Data Engineer for our Data & Analytics team. The role focuses on building and scaling modern data pipelines, designing reliable data models, and enabling business decision‑making through high‑quality dashboards and self‑service reporting, primarily in Sigma Computing.

The ideal candidate possesses deep expertise in data engineering and strong business intelligence experience.

• Build and maintain high‑performance data pipelines that enable deeper analysis, reporting, and insights across the business.
• Design and implement scalable data models and warehouse structures that support analytics, reporting, and data science needs, optimizing for speed, reliability, and maintainability.
• Create seamless data ingestion and transformation processes using modern ETL/ELT practices, leveraging AWS, Snowflake, dbt, and Fivetran to ensure smooth and reliable data flow.
• Own and improve the backend data foundation that powers dashboards, reporting, and self‑service analytics.
• Collaborate with business teams to understand data and reporting needs, and translate them into flexible, scalable technical solutions.
• Develop and maintain dashboards, reports, and analytic views in Sigma Computing, ensuring business users have access to trusted, actionable, and easy‑to‑use insights.
• Partner with stakeholders to define KPIs, business logic, and reporting requirements, and translate them into scalable data models and reporting solutions.
• Establish best practices for data quality, governance, documentation, and reporting consistency across both engineering and analytics workflows.
• Continuously improve reporting and analysis by automating processes, streamlining workflows, and empowering teams with self‑service data tools.
• Operate effectively within Agile delivery processes, contributing to sprint planning, backlog refinement, estimation, story development, and cross‑functional execution using Jira and Confluence.

• 7+ years designing and implementing modern data warehouse and analytics engineering solutions, with a focus on scalability, reliability, and performance.
• 7+ years writing advanced SQL and developing robust ETL/ELT pipelines to transform and integrate data across multiple systems.
• 7+ years using Python or similar languages to build scalable, efficient, and maintainable data solutions.
• Strong hands‑on experience with AWS, Snowflake, dbt, Fivetran, and Sigma Computing.
• Experience building and optimizing data models in Snowflake and managing transformation workflows in dbt.
• Experience using Fivetran or similar ingestion tools to build and maintain reliable source‑to‑warehouse pipelines.
• 5–7 years of dashboarding and BI experience overall, with strong hands‑on experience delivering reporting solutions for business users.
• Hands‑on Sigma Computing experience is required; ideally 5–7 years, with at least 3+ years of direct Sigma experience and prior Tableau or Power BI experience.
• Proficient in cloud technologies, especially AWS, and experienced in building scalable data solutions in cloud‑native environments.
• Experience working in Agile teams and collaborating across engineering, analytics, and business stakeholders.
• Strong working knowledge of Jira and Confluence for backlog management, sprint planning, documentation, and team collaboration.

• Deep expertise in modern data engineering and analytics engineering practices.
• Strong hands‑on experience with AWS, Snowflake, dbt, Fivetran, and Sigma Computing.
• Expertise in building and optimizing data models, transformations, and reporting‑ready datasets in Snowflake and dbt.
• Strong hands‑on experience delivering business‑facing dashboards and self‑service reporting in Sigma Computing, supported by well‑modeled, scalable data structures in Snowflake and dbt.
• Prior experience with Tableau and/or Power BI is preferred.
• Strong understanding of data modeling, semantic layer design, and self‑service analytics enablement.
• Solid…