Reporting Solutions Engineer

twentysix; El Segundo (CA); On-site; USD 110,000 - 160,000; Full time

Job summary

twentysix in El Segundo, CA seeks an analytics engineer to design data models, pipelines, and dashboards for cross-channel media measurement. You will gather requirements, build scalable ETL, validate sources, and deliver actionable insights using Looker or Data Studio.

The role emphasizes SQL, dbt, and cloud platforms like BigQuery, with collaboration across stakeholders to ensure accurate, timely reporting.

Qualifications

• 5+ years in reporting, BI, or analytics engineering.
• Experience with SQL, database design, and data manipulation methodologies.
• Experience gathering requirements and delivering data visualizations in Looker or Data Studio.
• Familiarity with dbt and cloud platforms like BigQuery, Snowflake, or Redshift.
• Strong Google/Excel Sheets skills, preferably with Apps Script.
• Experience with API calls for gathering and storing large datasets.

Responsibilities

• Gather data source, data joining, data model, and transformation requirements.
• Develop reporting and insights solutions/tools for cross-channel measurement.
• Manage multiple data pipelines and ETL tasks for client data streams.
• Create dashboards in Looker or Data Studio to tell a compelling business story.
• Validate data from multiple sources to provide an integrated overview of digital marketing efforts.

Skills

SQL

Data visualization

Data modeling

ETL pipelines

Looker

Data Studio

dbt

BigQuery

Python

APIs

Excel/Sheets

Analytical-thinking

Tools

Looker

Data Studio

dbt

BigQuery

Python

Tableau

PowerBI

Job description

You Will Be

Gathering data source, data joining, data model, and data transformation requirements from stakeholders (clients and internal teams)

Gathering and evaluating data visualization requirements in order to develop unique reporting and insights solutions/tools for cross-channel media measurement

Managing and monitoring multiple data pipelines and ETL tasks related to multiple client data streams

Assisting in the creation of a reliable and scalable infrastructure for data model builds, data set QA, and data set outputs

Working with internal stakeholders to understand and then execute against data transformation, data model, and inbound/outbound data pipeline requirements

Assisting with the design of client data pipelines to flexibly and efficiently deploy data for new dashboards and apps within Polaris, our proprietary tech platform

Working with data engineers to validate data from multiple sources to provide an integrated, comprehensive overview of our digital marketing efforts

Creating reporting dashboards in Google Data Studio and Google Looker, using best practices for visualizations and user experience, to communicate a compelling business story

Gathering feedback on the dashboard to better understand its functionality and user experience, and documenting for product improvements

Assisting the engineering team in creating data requirements for future platform enhancements

Identifying areas for improvement and propose potential solutions, building process documentation to assist in the scaling of all reporting efforts

You Must Have

5+ years of experience in reporting, BI, or analytics engineering

Experience with SQL, database design, and data manipulation methodologies

Experience gathering requirements and delivering data visualizations in Looker (preferred) or Data Studio within an Advertising Agency or similar client environment

Familiarity with Data Build Tools (dbt)

Strong Google/Excel Sheets skills, preferably with appscripts experience

Experience working with API calls for the purposes of gathering and storing large datasets (batch or streaming)

Experience with at least one cloud platform (BigQuery, Snowflake, Redshift, etc.)

Experience with at least one programming language (Python, R, AppScript, JavaScript, etc.), preferably JavaScript or Python

Knowledge of database and data warehousing design and management

Understanding of ETL process and data modeling experience using SQL

Attention to detail with the ability to debug and troubleshoot code/queries

A collaborative mentality with the ability to work independently

General business and marketing data acumen including an understanding of common marketing goals, KPIs, and tactics

Experience integrating and automating pipelines from multiple data sources

Strong organizational skills with superior attention to detail with the ability to handle the balancing of multiple tasks and projects

The desire to learn new tools, skills, and strategies and the initiative to take on new tasks

Both an analytical and design mindset

Strong written and verbal communication skills

Nice to Have

Experience with digital analytics tools (Google Analytics, Adobe Analytics)

Experience with Project Management Platforms (JIRA, Asana)

Knowledge/experience in the digital marketing industry

Curiosity to continuously learn more about digital marketing and marketing technology

Experience in working with data from different ad platforms (Google, Facebook, Microsoft) and digital analytics tools (Google Analytics, Adobe Analytics)

Data Integration Platforms: Funnel, Domo

Data Visualization Platforms: Tableau, PowerBI

Data Warehouses: BigQuery

Project Management Platforms: Asana or similar experience