First Table

Data Engineer – Cloud, BI Architecture

First Table

full-time

Posted on:

Location Type: Remote

Location: New Zealand

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

AirflowAmazon RedshiftAWSCloudDockerEC2ETLPHPPythonSQL

About the role

  • Build the Foundation: Act as the technical SME to design, build, and maintain our cloud data warehouse (Snowflake/AWS) from the ground up.
  • Architect the Semantic Layer: Comfortable designing robust Star Schema and Kimball models for data application.
  • Engineering & Orchestration: Build bespoke ETL/ELT pipelines using Python, Airflow, and middleware connectors, moving data from marketing platforms, product DBs, and third-party APIs.
  • Legacy Refactoring: Read, interpret, and refactor legacy PHP scripts and data modelling into modern, pythonic data flows.
  • Power BI Mastery: Optimise ingestion and semantic layers specifically for Power BI.
  • Historical Integrity: Implement Slowly Changing Dimensions (Type 2) to allow Data Scientists to perform accurate point-in-time longitudinal and cohort analysis.
  • Technical Leadership: Establish best practices for our data architecture, including warehouse set up, data pipelines, ML/AI CI/CD, Infrastructure as Code (IaC), and system monitoring to ensure 99.9% pipeline reliability.
  • Strategic Support: Partner with Data Scientists to provide the underlying data structures for pricing engines, LTV analysis, and churn prediction.

Requirements

  • 2–4 years of hands-on professional experience in Data Engineering
  • Cloud Warehousing: experience building Snowflake, AWS Redshift, or similar cloud data architecture environments from day zero
  • Technical Stack: Proficient in Python, Airflow, and building APIs
  • Solid experience with AWS services (S3, Lambda, EC2, Glue), Git, and Docker
  • Power BI Expertise: Deep understanding of the Power BI ecosystem, including DAX, Power Query, and semantic layer design
  • SQL Mastery: Exceptional proficiency in writing complex, optimized SQL for high-scale data transformation
  • Architectural Mindset: Strong understanding of Fact/Dimension logic and how to maintain data lineage from raw source to final report
  • Communication: The ability to explain complex architectural choices to non-technical stakeholders and translate business needs into technical specs.
Benefits
  • Free First Table bookings
  • Regular team recognition and social events
  • The chance to work with a purpose-led, award-winning brand
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
PythonAirflowETLELTSQLDAXPower QueryData WarehousingData ModelingSlowly Changing Dimensions
Soft Skills
Technical LeadershipCommunicationArchitectural Mindset