Data Engineer

About the Role

Join a highly collaborative and supportive data technology team at Macquarie Group, strategically transforming our data landscape into a key asset for our business consumers. In this role, you will have the opportunity to grow your skills in next-generation data platforms and analytics, making a positive impact. Our team focuses on delivering data solutions to our equity brokerage, equity research, and derivatives businesses.

At Macquarie, our advantage comes from bringing diverse people together and empowering them to shape all kinds of possibilities. We are a global financial services group operating in 31 markets with 56 years of unbroken profitability. You will be part of a friendly and supportive team where everyone, regardless of their role, contributes ideas and drives outcomes.

What Role Will You Play?

As part of the Data DevOps team, you will collaborate closely with cross-functional teams. Your responsibilities will include:

• Testing, developing, and supporting data solutions.
• Analyzing requirements, designing, and developing test plans, test cases, and test scripts.
• Performing data validation and verification to ensure accuracy, completeness, and consistency.

In terms of development, you will:

• Design, develop, and maintain scalable data pipelines and ETL processes.
• Build robust data solutions.
• Implement data models, reports, and dashboards.
• Optimise and tune SQL queries and database performance.

For support, you will:

• Respond to and resolve escalated operational issues.
• Participate in rostered support shifts and on-call duties as required.

What You Offer

To succeed in this Data Engineer role, you should possess:

• 2 years of experience working with database platforms and data tools such as MSSQL, AWS RedShift, SSIS, SSRS, SSAS, and dbt.
• Proven experience in business intelligence or other database technologies.
• A strong understanding of data warehousing concepts, ETL processes, and data modelling.
• Excellent problem-solving skills and keen attention to detail.
• Strong communication and collaboration skills to thrive in a globally dispersed team.

Experience with any of the following is an advantage:

• Cloud-based data platforms such as Azure, AWS, or Google Cloud.
• Data governance and data quality best practices.
• Data visualisation tools such as Power BI, Tableau, or similar.
• Exposure to any AI tools.

We encourage anyone inspired to build a better future with us to apply, even if you don't meet every single requirement.

What We Offer

At Macquarie, you’re empowered to shape a career that is rewarding in all the ways that matter most to you. Eligible Macquarie employees can access a wide range of benefits, including:

• 1 wellbeing leave day per year.
• 20 weeks’ paid parental leave for primary caregivers, 12 days of paid transition leave upon return to work, and 6 weeks’ paid leave for secondary caregivers.
• 5 days carers leave for immediate family members, in addition to annual leave.
• 2 days of paid volunteer leave and donation matching.
• Voluntary parental medical insurance plan for married employees.
• Wellbeing benefits, sessions, and events supporting physical, mental, and financial wellbeing, including comprehensive medical and life insurance cover.
• Access to our Employee Assistance Program, a robust behavioural health network with counselling and coaching services.
• Access to a wide range of learning and development opportunities, including reimbursement for professional membership or subscription.
• Hybrid and flexible working arrangements, depending on the role.
• Reimbursement for work-from-home equipment.

Key Skills/Competency

• Data Pipelines
• ETL Processes
• Data Modeling
• SQL Optimization
• AWS RedShift
• MSSQL
• SSIS
• Data Governance
• Power BI
• Cloud Platforms