Digital Solutions Consultant I

About us 

Worley is a global company of energy, chemicals and resources experts headquartered in Australia. We partner with our customers to deliver projects and create value across the life of their assets. We specialize in consulting, engineering, procurement and construction across the project lifecycle, with services extending through to operations and decommissioning. Leveraging extensive experience and AI-enabled delivery, we support customers in navigating complexity as they meet today's needs and transition to more sustainable solutions. 

The Role
 

As a Digital Solutions Consultant I with Worley, you will work closely with our existing team to deliver projects for our clients while continuing to develop your skills and experience etc.                                                                           

• Design, develop, test and maintain ETL/ELT pipelines using Microsoft Fabric or comparable modern cloud data-platform technologies.
• Build and support Lakehouse and Warehouse solutions that integrate data from ERP, project, engineering, operational and other enterprise systems.
• Develop SQL-based transformations, views and reusable data-processing logic with appropriate error handling and documentation.
• Implement data-quality checks, reconciliation controls, logging, monitoring and operational support procedures.
• Investigate pipeline, refresh and performance issues and drive them through to evidence-based resolution.
• Contribute to scalable storage, partitioning, incremental processing and workload-performance patterns where relevant.
• Translate reporting and analytical requirements into maintainable fact and dimension models
• Develop reusable Gold-layer datasets and semantic models that provide consistent, business-ready measures and attributes.
• Apply practical star-schema principles, including appropriate grain, keys, relationships and slowly changing dimension considerations.
• Support common KPI definitions, conformed dimensions, data documentation and controlled change management.

Additional Responsibilities:

• Perform source-to-target mapping, data profiling, validation and impact analysis for new or changed data products.
• Design and develop enterprise dashboards and reports when required, while providing technical guidance on Power BI modelling and design standards.
• Create and review DAX measures, semantic models, Row-Level Security and report-performance improvements.
• Promote reuse of governed models and reduce duplicated business logic across reports.
• Support publishing, refresh, release and production support processes for Power BI solutions.
• Lead technical design discussions for assigned solutions and explain trade-offs in clear, practical terms.
• Mentor junior team members through code reviews, modelling guidance, troubleshooting and knowledge sharing.
• Work with business stakeholders, product owners, architects and technical specialists to clarify requirements and delivery priorities.
• Contribute to delivery standards, templates, documentation and continuous improvement across analytics engineering.                 

About You

To be considered for this role it is envisaged you will possess the following attributes:

• 6-10 years of relevant experience across data engineering, data warehousing, business intelligence or analytics engineering.
• Strong SQL skills, including complex transformations, performance troubleshooting and systematic data validation.
• Hands-on experience developing ETL/ELT pipelines and integrating data from multiple enterprise sources.
• Practical experience with Microsoft Fabric, Azure data services, Databricks or another comparable modern data platform.
• Hands-on Power BI experience covering semantic models, DAX, Power Query and report development or technical oversight.
• Working knowledge of dimensional modelling, including fact tables, dimension tables, grain, relationships and star schemas.
• Experience diagnosing production issues and supporting reliable scheduled data or reporting workloads.
• Ability to lead assigned technical work, communicate with stakeholders and mentor less-experienced developers.
• Bachelor’s degree in Computer Science, Information Technology, Engineering, Analytics or a related discipline, or equivalent practical experience.
• Hands-on experience with Fabric Data Factory, pipelines, Dataflows Gen2, Lakehouse, Warehouse, notebooks or Direct Lake.

Other Qualifications:

• Experience implementing medallion architecture using Bronze, Silver and Gold layers.
• Practical knowledge of incremental loading, watermarking, partitioning, orchestration, retry handling and pipeline observability.
• Experience designing conformed dimensions, reusable Gold-layer data products or enterprise semantic models.
• Experience with Spark, Python, PySpark, Delta tables or notebook-based transformations.
• Familiarity with Microsoft Purview, data lineage, access controls, metadata management or broader data-governance practices.
• Experience modernising legacy data warehouses, SQL reporting estates or on-premises analytics solutions.
• Awareness of Kimball methodology, Data Vault concepts or other structured data-modelling approaches.Experience delivering enterprise analytics solutions in engineering, project delivery, project controls, operations, finance or supply chain environments.
• Experience integrating ERP, engineering, project or operational datasets with complex business rules.
• Experience working with distributed or global stakeholders and delivering through Agile or product-oriented teams.
• Relevant Microsoft certification in Fabric, Azure Data Engineering or Power BI.
• Experience establishing coding standards, peer-review practices, technical documentation or operational support runbooks.
• Data engineering and structured problem solving
• Pragmatic architecture and design judgement
• Data modelling and analytical thinking
• Technical leadership and mentoring
• Stakeholder communication and facilitation
• Quality, ownership and operational discipline.

Moving forward together

We want our people to be energized and empowered to drive sustainable impact. So, our focus is on a values-inspired culture that unlocks brilliance through belonging, connection and innovation. We're building a diverse, inclusive and respectful workplace. Creating a space where everyone feels they belong, can be themselves, and are heard.

And we're not just talking about it; we're doing it. We're reskilling our people, leveraging transferable skills, and supporting the transition of our workforce to become experts in today's low carbon energy infrastructure and technology. Whatever your ambition, there's a path for you here.

And there's no barrier to your potential career success. Join us to broaden your horizons, explore diverse opportunities, and be part of delivering sustainable change.