As an Analytics Engineer II, you'll independently design and deliver high-quality data models and pipelines to support marketing analytics, ensuring data quality and collaboration with cross-functional teams.
Analytics Engineer
📜 Description
- Build and maintain pipelines to ingest data from Salesforce and various other data sources.
- Build and maintain dbt models to transform data using Medallion architecture for business intelligence tools.
- Work closely with the Business Intelligence team to monitor and implement enhancement requests for the data warehouse.
- Collaborate with team members across different time zones and develop mentoring skills.
🛠️ Requirements
- 3+ years experience in data engineering
- Experience in development of pipelines to ingest and transform data from sources using REST APIs, AWS S3 and Airflow
- Experience in building dbt models to transform data using Medallion architecture
- Experience in maintaining dimensional data models with Type 2 SCDs and star schemas
- Experience in maintaining data warehouses on SQL Server
- Experience working with Snowflake, dbt and Tableau is essential
Full job description
The international data team is undergoing a complete transformation of their data architecture, migration from a legacy SQL server, Azure Data Factory, SSAS and Power BI stack to Snowflake, dbt, Airflow, Tableau and Sigma.
Key Responsibilities:
Build and maintain pipelines to ingest data from Salesforce and various other data sources
Build and maintain dbt models to transform data using Medallion architecture for use by business intelligence tools
Work closely with our Business Intelligence team - monitoring and implementing enhancement requests for the data warehouse to meet the reporting demands of stakeholders
Work collaboratively with team members in different timezones
Requirements:
3+ years experience in data engineering
Experience in development of pipelines to ingest and transform data from sources using REST APIs, AWS S3 and Airflow
Experience in building dbt models to transform data using Medallion architecture
Experience in maintaining dimensional data models with Type 2 SCDs and star schemas
Experience in maintaining data warehouses on SQL Server
Similar jobs
Search more Analytics Engineer jobsAs an Analytics Engineer, you will develop scalable data models and pipelines, collaborating with various teams to enhance data-driven decision-making.
The Analytics Engineer will develop scalable data models and pipelines, transforming complex workflows into reliable solutions that support company-wide decision-making.
We are hiring an Analytics Engineer focused on maintaining and optimizing our finance data platform, improving reliability, efficiency, and performance of our pipelines and core datasets.
As an Analytics Engineer, you'll design, build, and monitor data models that drive user offers and lifecycle messages, collaborating closely with Marketing and Product teams.
