BI & Data Engineer

Terra Firma Business Consulting; Melbourne; On-site; AUD 110,000 - 160,000; Full time

Job summary

Terra Firma Business Consulting is seeking a BI & Data Engineer/Analyst for a contract role based in Port Melbourne. Immediate start available.

You will deliver high-quality BI services, build data visualisations, and collaborate with stakeholders to understand business context, data quality, and integration needs, while improving BI platforms and pipelines using Azure and SQL-based tools. The ideal candidate has 7+ years in ETL, data warehousing, and Power BI, with strong SQL and Python

Qualifications

• Solid experience with Microsoft BI technology stack.
• 7+ years of SQL & scripting experience.
• 5+ years creating/paginated SSRS reports.
• 5+ years building Azure data factory pipelines.
• 7+ years ETL & data integration experience.

Responsibilities

• Engage with stakeholders to gather requirements and understand data context.
• Develop data visualisations and provide BI support to stakeholders.
• Classify and align business information and implement data quality standards.
• Acquire, transform, cleanse and standardise data for BI investigations.
• Drive continuous improvement of BI and Data platforms.

Skills

Power BI

SQL

Python

SSRS

Azure Data Factory

ETL

Azure Data Lake

Azure SQL Database

Azure Synapse Analytics

Data Visualisation

Stakeholder management

Tools

Azure

Job description

BI & Data Engineer/Analyst – Contract

Immediate Start

Port Melbourne location

The Business Intelligence Engineer/Analyst will be responsible for delivering high-quality BI services to our clients.

To be successful role, you will develop strong relationships with key stakeholders and taking an active approach to understanding the business context of data and its related processes. Delivering meaningful insights will also require solid capabilities in data integration, data analysis, and data visualisation.

Primary Duties And Responsibilities

• Engage with business stakeholders to gather business requirements and understand the business context of data and associated business processes
• Develop compelling and informative data visualisations and provide ongoing business intelligence support to business stakeholders
• Liaise and collaborate with business stakeholders to classify, define and align business information and implement data quality standardisation
• Acquire, transform, cleanse and standardise data using a range of techniques to support the specific BI investigations
• Drive continuous improvement of the Business Intelligence and Data platforms to ensure alignment with business objectives and strategy

Essential Skills

• Solid experience working with the Microsoft BI technology stack
• 5+ years of experience creating & editing Power BI Dashboards
• 7+ years of experience with SQL & Scripting: Develop strong proficiency in SQL for data querying and manipulation, and scripting languages like Python for automation and data processing
• 5+ years of experience creating /managing/editing paginated SSRS reports
• 5+ years of experience creating Azure data factory pipelines for ingesting data from source systems
• 7+ years of experience with ETL & Data Integration: Design and implement Extract, Transform, Load (ETL) processes and data integration patterns to move and transform data efficiently
• Azure Services: expertise in core Azure data services, including Azure Data Factory, Azure SQL Database, Azure Data Lake Storage, and Azure Synapse Analytics
• Data quality methodologies, including data cleansing and profiling techniques

Nice To Have

• Data Modelling & Warehousing: Understand fundamental concepts of data modelling and data warehousing to structure and manage data effectively
• Big Data Technologies: Familiarity with big data technologies like Apache Spark and Apache Kafka can be beneficial