Data Engineer

About the role

The Data Engineer at BusPatrol will be responsible for building and maintaining our data infrastructure to support reporting, analytics, and data science initiatives. The ideal candidate will have strong skills in data architecture, ETL, SQL, and Python within a Git-managed environment, as well as a proven ability to collaborate with both business stakeholders and data team colleagues to deliver robust, scalable data frameworks.

What you'll do

• Create and orchestrate data pipelines within a state-of-the-art AWS environment (Redshift, EC2, EMR/Spark, S3, Lambda, Glue, etc.)
• Manage all aspects of the data and analytics ecosystem—from ingestion to ETL to aggregate tables—to meet analytics and reporting needs
• Design and implement internal data pipeline processes and improvements using modern techniques such as automation, optimization
• Develop scripts for scheduling data ingestion and synchronization and implement backend logic to create data marts based on business requirements for stakeholder…
• Partner with data architects to build frameworks for defining metrics as code and optimizing data search and retrieval

What you need

• 5–9 yrs of experience
• SQL
• Python
• Redshift
• Data modelling
• Statistics
• Snowflake
• Any graduate

Good to have

• Machine learning
• Data visualisation
• JIRA
• Tableau
• Databricks
• ETL