Job description
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:
Looker
Tableau
Power BI
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
Salary: Up to $17/hrOriginally posted on Himalayas
Who can apply
The source lists worldwide eligibility. Accepted UTC offsets: UTC-11, UTC-10, UTC-9.5, UTC-9, UTC-8, UTC-7, UTC-6, UTC-5, UTC-4, UTC-3.5, UTC-3, UTC-2, UTC-1, UTC+0, UTC+1, UTC+2, UTC+3, UTC+3.5, UTC+4, UTC+4.5, UTC+5, UTC+5.5, UTC+5.75, UTC+6, UTC+6.5, UTC+7, UTC+8, UTC+8.75, UTC+9, UTC+9.5, UTC+10, UTC+10.5, UTC+11, UTC+12, UTC+12.75, UTC+13, UTC+14. Review the full description for employer-specific work authorization, residency and schedule requirements.