Enterprise Data and BI Specialist

Overview

Build & maintain ETL pipelines, data models, and BI using Informatica, Snowflake, Fivetran

Key Responsibilities

• data modeling
• metadata design
• ingestion automation
• etl pipelines
• performance monitoring
• requirements gathering

Tasks

-Work closely with business analysts, architects, and stakeholders to gather requirements and translate them into technical specifications -Design and implement data models (e.g., star/snowflake schemas, SCD Type-2) -Apply metadata-driven design principles to standardize ingestion and transformation logic -Automate ingestion from APIs, databases, and file systems into Snowflake using Informatica Cloud Services (CDI, CAI, CMI) -Develop and maintain ETL/ELT pipelines using Fivetran for ingestion and Informatica for transformation -Monitor pipeline performance, troubleshoot issues, and implement enhancements

Requirements

• snowflake
• fivetran
• power bi
• sql
• etl/elt
• agile scrum

What You Bring

-Proficiency in Snowflake, Fivetran, and Informatica advantageous -Exposure to legacy system migration and cloud and on-premises data sources -Knowledge of cloud applications integration strategies -Familiarity with data warehousing concepts, data governance, and security policies -Experience with Agile/SCRUM methodologies and version control tools (e.g., Git, Jira) -Strong analytical and problem-solving skills -Experience with Power BI or other BI tools -Strong SQL skills and experience with relational databases (e.g., DB2, SQL Server, Oracle, Snowflake) -3–7 years of experience in ETL/ELT development coupled with relevant tertiary qualifications

People Also Searched For

Benefits

We are committed to providing our people with opportunities to learn, grow and thrive. By investing in their careers, we are not only supporting the growth of the engineering and construction industries, but ensuing Australia is well-positioned to deliver the nation-building projects that will enable a more sustainable future. -Industry leading paid parental leave program from the day you join -Special offers on private health insurance, salary packaging, banking, retail and more -Flexible and remote work options to manage work and lifestyle commitments -Numerous mental health and well-being programs -Salary continuance insurance (criteria applies) -Excellent end of trip facilities and free gym onsite -A competitive remuneration package -Ongoing learning and development opportunities (through Engineers Australia, AIM Training, LinkedIn Learning and more)

About Clough

-A global leader in integrated project delivery, offering engineering, procurement, construction, and asset services. -Operates across energy, industrial, infrastructure, and water resources sectors. -Known for handling complex, large-scale projects in challenging environments. -Delivers iconic projects such as oil and gas plants, infrastructure developments, and energy facilities. -Specializes in offshore construction and heavy industrial projects. -Adopts an innovative approach, leveraging new technologies to enhance project outcomes and safety.

Sector Specialisms