In short
Data engineer centralizing paid-media and CRM data into a BigQuery warehouse: designs scalable pipelines, builds modular dbt/Dataform transformations, and delivers Looker Studio dashboards and automated reports for marketing analytics, working with an analytics manager and client teams with a strong focus on data quality.
About the role
Ontrac Solutions Llc. is seeking an experienced Data Engineer (Marketing-oriented) to centralize data from paid media and CRM sources into a BigQuery warehouse.
You will design scalable pipelines, integrate CRM data, and create modular dbt/Dataform transformations for robust dashboards in Looker Studio. You will collaborate with the analytics manager and client teams to translate reporting requirements into reliable warehouse models and automated reports, with a focus on data quality and
Requirements
- Experience as a Data Engineer with a marketing focus
- Centralize data from paid media and CRM sources into BigQuery
- Design scalable data pipelines
- Integrate CRM data
- Create modular dbt/Dataform transformations
- Build robust dashboards in Looker Studio
- Translate reporting requirements into reliable warehouse models and automated reports
- Focus on data quality