BI & Data Engineer

Terra Firma Pty Ltd; Melbourne; On-site; AUD 110,000 - 140,000; Full time

Job summary

Terra Firma Pty Ltd in Melbourne seeks a Business Intelligence Engineer/Analyst to deliver high-quality BI services to clients and build insights through data visualisation and integration.

You will engage with stakeholders, align data with business processes, and drive data quality across BI platforms using Microsoft technologies.

Qualifications

• 5+ years of experience creating & editing Power BI dashboards.
• 7+ years of experience with SQL and scripting (Python) for data processing.
• 5+ years of experience creating/managing/editing paginated SSRS reports.
• 5+ years of experience creating Azure Data Factory pipelines for data ingestion.
• 7+ years of ETL and data integration experience.

Responsibilities

• Engage with stakeholders to gather business requirements and understand context of data and processes.
• Develop informative data visualisations and provide ongoing BI support to stakeholders.
• Collaborate with stakeholders to define and standardise business information and data quality.

Skills

Stakeholder engagement

Data interpretation

Data visualization

Problem solving

Tools

Power BI

SQL

Python

SSRS

Azure Data Factory

ETL

Job description

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
• 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
• 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

All Terra Firma employees, contractors and consultants are required to complete security and background checks, including any checks mandated by our clients, before employment or engagement.