Build Your Business Virtual Assistance

Data Engineer

We are looking for a skilled Data Engineer to design, optimize, and maintain the data architecture that powers our BI environment.

Job Description

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

Data Architecture & Engineering

  • Design, build, and maintain BigQuery datamarts and analytical tables for BI reporting

  • Develop scalable data models (star schema, snowflake, or denormalized) optimized for analytics workloads

  • Optimize query performance and storage efficiency within cloud data warehouses

  • Collaborate with BI teams to ensure datasets align with semantic models and dashboards

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

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

Collaboration with BI

  • 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 (BigQuery, Redshift, Snowflake, or similar)

  • Proven experience in 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 working with BI tools such as Looker, Tableau, or Power BI

  • Background in retail or multi-location data environments