Address
SalaryI'm currently partnering EXCLUSIVELY with one of my favourite national Law Firms to recruit a Senior Data Engineer role - This is a permanent role and is based out of the Sydney CBD office and also offers a hybrid working environment.
The role
The Senior Data Engineer is part of the technology team and plays a two-part role in:
- Data Engineering: responsible for design, deployment, and optimisation of data pipelines and SQL queries
- Data Platform administration: managing and maintaining Data Platform services based on Azure SQL environments and SQL databases.
You will work closely with internal stakeholders, the technology team and subject matter experts to elicit relevant information and deliver reporting & business intelligence to improve efficiency and transparency of data.
Responsibilities
- Acquire, ingest, and process data from various sources using Azure Data Factory.
- Perform data filtering, cleansing, de-duplication, and validation, identifying gaps.
- Develop and test complex reports from different systems, focusing on practice and case management.
- Build reports using tools like SSRS and possess familiarity with Tableau or Power BI.
- Design data architecture for informed business decisions and recommend scalable technical solutions.
- Demonstrate proficiency in SQL Query language, Database objects, and analyse diagnostic logs.
- Maintain security awareness, audit user access, and support ISO 27001 accreditation, including database encryption.
- Proven expertise across Azure Cloud Architecture
- SQL Server (on Azure VM) or Azure SQL (setup, configuration, and security)
- Deployment and management of Azure Data Lake Storage, Azure Data Factory, Data Bricks and Power BI
- Fluency in SQL is required including the ability to analyse, design, develop, test, and debug complex reports using SSRS 2012-2019
- Microsoft Certifications relative to SSRS, SSIS, SSAS, Power BI and Azure
- Exposure to Azure DevOps practices and processes
