![One51 Consulting](https://media.trabajo.org/img/noimg.jpg)
Consultant - One51 Consulting
1 month ago
We are looking for a Microsoft Azure Data Engineer who will be responsible for developing and maintaining the data architecture, data models and standards for various Data Integration & Data Warehouse projects in Azure. Ensure new features and subject areas are modelled to integrate with existing structures and provide a consistent view. In addition, develop and maintain the documentation of the data architecture, data flow, and data warehouse data models appropriate for both technical and business audiences.
Responsibilities:
- Design and develop ETL pipelines in and out of a data warehouse using Azure Data Factory (ADF)
- Ability to write SQL queries against Azure SQL Database / Synapse.
- Provide production support for Azure SQL Database / Synapse issues such as data load problems, transformation, and translation problems.
- Integration of on-premises infrastructure with cloud (Microsoft Azure) infrastructure.
- Effectively translate requirements for Business Intelligence, Reporting and Analytics 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 integrations 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, a minimum of 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 an extensive range of 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. Is effective and persuasive in both written and oral communication.
About One51
One51 Consulting is home to the collective knowledge and experience of diverse backgrounds but like-minded individuals.
At the core of our culture, we value:
- 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 by nature 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 every day.
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 working from home, with optional office days scheduled 1-2 days per week at our Sydney office.
-
Azure Data Engineer
1 month ago
Sydney, New South Wales, Australia One51 Consulting Full timeWe are seeking a highly skilled Azure Data Engineer to join our team at One51 Consulting. In this role, you will be responsible for designing, developing, and maintaining data architectures, data models, and standards for various Data Integration and Data Warehouse projects in Azure. Your expertise should include ETL pipelines, data warehousing, and big data...
-
Cloud Data Engineering Expert
3 weeks ago
Sydney, New South Wales, Australia One51 Consulting Full timeOne51 Consulting seeks a Cloud Data Engineering Expert who will be responsible for developing and maintaining data architecture, data models, and standards for various data integration and data warehouse projects in Azure. This role involves designing and implementing ETL pipelines in and out of a data warehouse using Azure Data Factory (ADF), ensuring new...
-
Design Consultant
6 months ago
Sydney, Australia XAM Consulting Full time**DESIGN CONSULTANT** Are you a creative problem solver with a passion for design? Join our innovative software development consultancy as a Design Consultant and unleash your expertise to transform digital experiences. As a key member of our team, you'll collaborate with clients to understand their unique challenges and craft elegant solutions that exceed...
-
Management Consultant
6 months ago
Sydney, Australia Boston Consulting Group Full time**ABOUT US** **ROLE PROFILE** As a member of our consulting team, you’ll work alongside some of the world’s top minds on cases that reshape business, government, and society. You’ll collaborate on challenging projects with team members from many backgrounds and disciplines, increasing your understanding of complex business problems from diverse...
-
Sales Consultant
7 months ago
Sydney, Australia MYM Consulting Full timeOpportunity to develop into a client facing role at C level - Collaborative and team based with hybrid working and extensive benefits - Reporting directly into the Australian MD **What’s in it for you**: We are seeking a motivated and energetic Sales Consultant to join our client’s dynamic business development team. You will be assisting with driving...
-
Transformation Consultant
3 weeks ago
Sydney, New South Wales, Australia Anton Murray Consulting Full timeSydney, Investment Banking, Contract or TemporaryOur client, a leading global financial services firm, is seeking an experienced Change Consultant to join their Melbourne or Sydney office. This role will be part of a high-profile Risk & Compliance project, with a focus on delivering risk and regulatory remediation programs.The Transformation Consultant will...
-
Environmental Consultant Opportunity
3 weeks ago
Sydney, New South Wales, Australia EMM Consulting Full timeAt EMM Consulting, we're committed to helping our clients and the community achieve a sustainable future. We're looking for an Environmental Consultant who shares our passion for making a positive impact.About the Program:Our Graduate Program is designed to provide you with a comprehensive learning experience that includes formal training, coaching,...
-
Graduate Environmental Consultant
3 months ago
Sydney, Australia ADE Consulting Full timeAbout us ADE Consulting Group offers high calibre environmental consultants, occupational hygienists and geotechnical engineers to provide a wide range of services, including: contamination assessments and remediation, air and water quality assessments, occupational health and safety services including asbestos, mould and hazardous materials surveys,...
-
Transformation Consultant
3 weeks ago
Sydney, New South Wales, Australia Parity Consulting Full timeJob OverviewWe are seeking an experienced Transformation Consultant to join our team at Parity Consulting.About the OrganisationOur client is a respected leader in the superannuation sector, committed to delivering innovative solutions and improved experiences for their members. They are embarking on exciting enterprise-wide transformation projects.Key...
-
LMS Consultant/specialist
7 months ago
Sydney, Australia Quay Consulting Full timeThis major brand (retailer) has embarked on a number of digital initiatives, with a key element being around implementation of a leading LMS. The project is currently underway and they are looking for an LMS expert who can review and report on the project (as it stands) and "potentially" guide the latter part of the project based upon the recommendations...
-
Implementation Consultant – Xero
5 months ago
Sydney, Australia Mane Consulting Full timeABOUT THE ORGAINSATION A specialist professional services firm based in the heart of Sydney is seeking a Cloud Implementation Consultant to assist in the implementation and delivery of Xero accountancy software to a varied SME client base. The company boasts a reputation as one of Australia’s most successful firms, with an outstanding record of delivering...
-
Solutions Consultant
6 months ago
Sydney, Australia 4Twenty Consulting PTY LTD Full timeSales & Account Management **Details** **About the job** We are looking for a Solutions Consultant on behalf of one of our SaaS partners to join our team in Sydney!**What you will do** As a Solutions Consultant you will be proving value to prospects and customers by supporting the sales team during the assessment period from a technical standpoint,...
-
SAP SuccessFactors Consultant
1 month ago
Sydney, Australia Mane Consulting Full timeSeeking an experienced SAP SuccessFactors Consultant to lead and deliver cutting-edge HR solutions. This is a client-facing consultancy role, specialising in SAP SuccessFactors modules including Employee Central, Payroll, and Time.Key Responsibilities:Lead end-to-end SAP SuccessFactors implementations, delivering quality solutions aligned with business...
-
Strategic Management Consultant
1 month ago
Sydney, New South Wales, Australia Boston Consulting Group Full timeLocations: Sydney | AucklandAbout UsBoston Consulting Group is a leader in business strategy when it was founded in 1963. Today, we help clients drive bottom-line impact by blending digital and human capabilities. Our diverse, global teams bring deep industry and functional expertise to spark change. We deliver solutions through management consulting,...
-
Data & Analytics Consultant
3 months ago
Sydney, Australia Mane Consulting Full timeFeel empowered in this Innovative company with AI and data analytics in its DNA. Leverage their global footprint to solve clients’ business needs. You’ll drive results that combines cutting edge advanced analytics and automated AI with an integrated suite of leading tools and technologies. Role Description The Senior Consultant / Data Engineer role is...
-
Sydney, New South Wales, Australia EMM Consulting Full timeEMM Consulting: A Leader in Sustainable FuturesAs a Graduate Hydrologist at EMM Consulting, you will embark on an incredible journey that combines passion, purpose, and professional growth. Our team is dedicated to nurturing exceptional talent for the environmental industry, and we invite you to join us on this exciting path.About the ProgramYou will...
-
Senior Power Platform Consultant
1 month ago
Sydney, New South Wales, Australia Xam Consulting Full timeXAM Consulting is a high-growth company seeking a seasoned Senior Consultant to work on cutting-edge projects in the application innovation space. This role is ideal for a polyglot developer with expertise in Power Platform, Power Apps, Power Automate, and Copilot Studio.As a Senior Consultant, you will contribute to solving complex problems, designing...
-
Consultant/ Senior Consultant, Climate Change
1 month ago
Sydney, Australia SLR Consulting Full timeConsultant/ Senior Consultant, Climate Change & Net-Zero StrategyAbout the business and the roleAt SLR we Make Sustainability Happen. SLR is an international environmental consultancy with a globally recognised reputation for providing high quality tailored services. With close to 850+ staff in APAC alone, we provide consultancy advice and support on a...
-
Strategic Management Consultant with MBA
4 weeks ago
Sydney, New South Wales, Australia Boston Consulting Group Full timeAre you ready to embark on a rewarding career in strategic management consulting? At Boston Consulting Group, we offer an exciting opportunity for individuals with an MBA to join our team of top minds and work on cases that shape the future of business, government, and society.About UsBoston Consulting Group is a global leader in management consulting,...
-
Technical Consultant
3 weeks ago
Sydney, New South Wales, Australia Xam Consulting Full timeXam Consulting is a high-growth company, offering an exciting opportunity for a Senior Technical Consultant. This role provides the chance to work with cutting-edge technologies, including Power Platform, Power Apps, and Azure.This position involves solving complex problems, designing solution architectures, mentoring teams, implementing software best...