BI & Data Engineer

Terra Firma; Melbourne; On-site; AUD 120,000 - 170,000; Full time

Job summary

Terra Firma is seeking a Business Intelligence Engineer/Analyst in Melbourne to deliver high-quality BI services for clients. You will build relationships with stakeholders, understand business data context, and develop visualisations that provide meaningful insights.

Key strengths include strong Microsoft BI experience, 5+ years crafting Power BI dashboards, 7+ years SQL & scripting, SSRS, and 5+ years Azure Data Factory, with solid ETL and data integration skills.

Qualifications

• Gathers requirements from stakeholders and understands business data context.
• Ensures data quality and standardisation across sources.
• Creates informative data visualisations and BI support.

Responsibilities

• Engage with stakeholders to gather requirements and understand business data context.
• Develop compelling data visualisations and provide BI support to stakeholders.
• Collaborate to classify and standardise business information and data quality practices.
• Acquire, transform, cleanse and standardise data for BI investigations.
• Drive continuous improvement of BI and data platforms to align with business objectives.

Skills

Stakeholder engagement

Data storytelling

Data quality

Tools

Power BI

SSRS

Azure Data Factory

SQL

Python

ETL tooling

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