Enterprise Data and BI Specialist

Overview

Develop and maintain ETL/ELT pipelines, data models, and BI using Informatica, Fivetran, Snowflake.

Key Responsibilities

• metadata design
• data modeling
• etl development
• ingestion automation
• stakeholder collaboration
• performance monitoring

Tasks

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

Requirements

• etl/elt
• agile
• sql
• snowflake
• power bi
• git

What You Bring

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

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. -Numerous mental health and well-being programs -Special offers on private health insurance, salary packaging, banking, retail and more -A competitive remuneration package -Salary continuance insurance (criteria applies) -Excellent end of trip facilities and free gym onsite -Flexible and remote work options to manage work and lifestyle commitments -Industry leading paid parental leave program from the day you join -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