Data Engineer
Job Overview
We are looking for a skilled Data Engineer to design, optimize, and maintain the data architecture that powers our BI environment.
This role focuses on building scalable BigQuery datamarts, optimizing data models, and ensuring reliable data pipelines to support analytics and reporting.
The ideal candidate has strong experience in cloud data warehousing, data modeling, and building analytics-ready datasets that enable efficient BI consumption.
Key Responsibilities
1. Data Architecture & Engineering
- Design, build, and maintain BigQuery datamarts and analytical tables for BI reporting.
- Develop scalable data models, including star schema, snowflake, and denormalized models.
- Optimize query performance and storage efficiency within cloud data warehouses.
- Collaborate with BI teams to ensure datasets align with semantic models and dashboards.
2. Data Pipeline & Transformation
- Build and maintain data pipelines for data ingestion, transformation, and loading into analytics environments.
- Implement transformation workflows using SQL or frameworks such as dbt.
- Ensure data quality, validation, and consistency across datasets.
3. Data Governance & Performance
- Maintain data standards, naming conventions, and proper documentation.
- Implement governance practices, including schema management and version control.
- Monitor and troubleshoot pipeline failures and data inconsistencies.
4. Collaboration with BI Teams
- Work closely with BI specialists to ensure datasets support semantic-layer requirements.
- Deliver optimized datasets that minimize the need for heavy transformations within BI tools.
Required Qualifications
- 3+ years of experience in Data Engineering or Analytics Engineering.
- Strong SQL expertise for analytical workloads.
- Experience with cloud data warehouses such as:
- BigQuery
- Amazon Redshift
- Snowflake
- Similar platforms
- Proven experience designing star-schema or dimensional data models.
- Experience building analytics-ready datamarts.
Preferred Qualifications
- Experience with dbt or similar data-transformation frameworks.
- Familiarity with Git-based workflows and CI/CD for data pipelines.
- Experience with BI tools such as:
- Background working with retail or multi-location data environments.
Key Skills
- SQL
- Prompt Engineering
- Data Engineering
- Analytics Engineering
- BigQuery
- Data Modeling
- Data Warehousing
- Data Pipelines
- BI & Analytics
- dbt
- Git / CI/CD