Data Engineer

• 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 align datasets with semantic models and dashboards
• 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
• Maintain data standards, naming conventions, and documentation
• Implement governance practices, including schema management and version control
• Monitor and troubleshoot pipeline failures and data inconsistencies
• Deliver optimized datasets that minimize heavy transformations within BI tools

• 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, or similar platforms
• Proven experience designing star-schema or dimensional data models
• Experience building analytics-ready datamarts
• 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, or Power BI
• Background working with retail or multi-location data environments