Data Engineer

Deputy

Sydney, NSW
Permanent
Full-time

1 month ago
Apply easily

At Deputy, we're on a mission to simplify shift work. We empower businesses to build thriving workplaces - ones where staff are engaged, customers are served well, businesses are legally compliant, and companies' profits thrive. Our reach extends across 70+ countries worldwide, serving more than 320,000 workplaces.Deputy is a global SaaS workforce management company headquartered in Sydney, San Francisco, and London, backed by top investors and recently surpassed 100m ARR. We've helped millions of workers across industries and aim to empower 60% of the global workforce. If you're passionate about simplifying shift work and driving industry change, join us at Deputy and help shape the future of hourly employment!MISSION “THE WHY”As a Data Engineer, you will be working closely with your team (including two Senior Data Engineers), software engineers, product, design, analytics and leadership teams to shape and execute the data strategy at Deputy. You are able to design, architect and build high performance scalable data pipelines while continually building upon Deputy's guiding principles around data.Responsibilities:

Design, implement, test, deploy, and maintain stable, secure, and scalable data engineering solutions and pipelines in support of data and analytics projects, including integrating new sources of data into our data warehouse.
Maintain and build on our data warehouse and analytics environment.
Produce scalable, replicable code and engineering solutions that help automate repetitive data management tasks.
Identify, design, and implement process improvements such as: improving database performance, optimising data delivery and re-designing infrastructure for greater scalability, and maintainability among many things
Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources within our AWS and data warehouse ecosystem.
Implement and monitor best in class security measures in our data warehouse and analytics environment, with an eye towards the evolving threat landscape.
Work with stakeholders including the Engineering, Product, Data Analytics and Design teams to assist with data-related technical issues and support their data infrastructure needs.
Work with data and analytics experts to strive for greater functionality in our data systems.
Help data analysts troubleshoot their SQL, Python, or R code.

Skills & Experience:

Strong command of relational databases and SQL. Extract, Transform, and Load (ETL) data into a relational database. We use Snowflake, Redshift, DynamoDB, MySQL and DBT.
Proficiency with Python or R, especially for data manipulation and analysis, and ability to build, maintain and deploy sequences of automated processes with these tools.
Advance data manipulation skills: read in data, process and clean it, transform and recode it, merge different data sets together.
Demonstrated ability to write clear code that is well-documented and stored in a version control system. We use Git.
Use APIs to push and pull data from various data systems and platforms.
Experience in building and maintaining a dimensional data model using type 2 dimensions.
Demonstrated ability to learn new techniques and troubleshoot code without support, ex. find answers to common programming challenges on Google. In other words, be able to learn on the job.
Excellent listening, interpersonal, communication and problem solving skills.
Demonstrated ability to work effectively in teams, in both a lead and support role.
Demonstrated ability to work independently and be a self-starter.

Nice to have:

Software engineering, data science, data analytics experience
Experience in Docker
Knowledge of building data lake or data warehouse.
Knowledge of handling streaming data.
Experience in Infrastructure as Code and CICD practice.
ML or predictive analytics experience.
Experience in web or mobile application development.

Employee Perks- Share Options- Paternity/Maternity Leave Policies- Flexible Work Policy- Company wide Development & Coaching- Hackathons- Awards - "Your Time to Shine & Celebrate Success"- Social Events & variety of social clubs (Books, LGBT, Games, Sports)- Mental Health Support- Munch & LearnsDeputy believes in equal opportunity and that inclusiveness and diversity promotes innovation. Our global team members are from a variety of cultures. And we welcome different perspective and skills.

Deputy