Microsoft Azure Data Engineer
ONE51 CONSULTING PTY LTD
- Sydney, NSW
- $100,000 per year
- Permanent
- Full-time
Ability to write SQL queries against Azure SQL Database / Synapse.
Provide production support for Azure SQL Database / Synapse issues such as data load, transformation, and translation problems.
Integration of on-premises infrastructure with cloud (Microsoft Azure) infrastructure.
Effectively translate business intelligence, reporting and analytics requirements to database modelling and design.
Ability to understand data pipelines and modern ways of automating data pipelines using cloud-based and on-premises technologies.
Actively test and document implementations, so others can easily understand the requirements, implementation, and test conditions.
Partner with the Data Architects, Product Managers and Scrum Masters to deliver data integration solutions required for various projects.
Ensure effective technical and project documentation across all phases of delivery.Required:Comprehensive, hands-on experience working as a Microsoft Azure Data Engineer. Ideally, at least 3 years in Data Warehousing, ETL/ELT, BI, and Analytics projects.
Must have experience with at least one (1) end-to-end implementation of an Azure Cloud Data Warehouse and two (2) end-to-end data warehouse implementations.
Expertise in data modelling, ELT using ADF, implementing complex views, stored procedures and standard DWH and ETL/ELT concepts.
Extensive design and implementation experience in Azure cloud data platform and modern data warehousing. Including aspects such as Security, Azure Logging and Monitoring, Azure Databricks, Synapse, Azure Blob Storage, Azure Data Lake, Azure Data Factory, Azure SQL Database, Azure Analysis Services, Power BI
Deep understanding of relational and NoSQL data stores, methods, and approaches (star and snowflake, dimensional modelling).
Experience with data security and data access controls and design.
Proficiency in RDBMS, complex SQL queries, database performance tuning and troubleshooting.
Commercial experience with full-stack MS Power BI modelling (M code), Dax, data storytelling, report publishing, security, and knowledge of how people make decisions with data.
Provide resolution to complex data pipeline-related problems proactively and as issues surface.
Must have experience with Agile development methodologies.
Experience working directly with technical and business teams.
Strong written communication skills. Effective and persuasive in both written and oral communication.About One51One51 Consulting is home to the collective knowledge and experience of diverse backgrounds but like-minded individuals.At the core of our culture, we value the following:
A passion for what we do: "We believe in the positive impact data, and analytics can have in the data-driven organisation and individual".
Trust goes a long way: This starts with our employees and extends naturally to our clients. We are committed to building long-term partnerships based on trust, clear communication, and understanding.
Creativity and curiosity: Simple solutions to complex problems are possible when the solution design focuses on solving problems and is supported by the correct use of previous experiences and the appetite to keep learning daily.At One51, you will have the opportunity to work with companies in different business sectors in a relaxed and supportive environment.One51 uses a hybrid working arrangement - primarily from home, with optional office days scheduled 1-2 days per week at our Sydney office.