Technical Business Analyst

The HR Ally; Sydney; Remote; AUD 96,000 - 207,000; Part time

Job summary

The HR Ally is seeking a Technical Business Analyst (Data) in Sydney. This contract role bridges business stakeholders and data teams, translating requirements into data mappings and specifications for engineers, architects and analysts.

Ideal candidates will be hands-on with SQL, data profiling, and end-to-end data solutions—from discovery to testing and delivery—with strong communication and documentation skills.

Qualifications

• 7+ years as a Business Analyst with data focus
• Strong SQL for profiling and validation
• Experience writing data mappings and specifications
• Knowledge of data warehousing and ETL/ELT concepts
• Experience with cloud data platforms (Azure, AWS, Snowflake)
• Experience with BI tools (Power BI, Tableau)
• Agile/Scrum delivery experience
• Excellent documentation (BRDs, FRDs)
• Strong stakeholder communication and collaboration

Responsibilities

• Engage with stakeholders to elicit, analyze and document data requirements
• Translate needs into functional/technical specs, user stories and acceptance criteria
• Perform data profiling to assess quality and structure
• Produce source-to-target mappings, data dictionaries and lineage docs
• Collaborate with data engineers and BI developers on pipelines and models
• Define transformation logic and data quality checks
• Support data migration and warehouse initiatives
• Plan and support UAT with test cases and validation
• Identify gaps/risks and propose solutions
• Support governance and metadata management
• Contribute to Agile ceremonies and status updates
• Manage stakeholder expectations through delivery

Skills

SQL

Data profiling

Data mapping

ETL/ELT

Data warehousing

Cloud platforms

BI tools

Agile/Scrum

Documentation

Stakeholder mgmt

Analytical thinking

Education

Bachelor's degree in relevant field

Tools

dbt

Azure Data Factory

Snowflake

Power BI

Jira

Confluence

Job description

Technical Business Analyst (Data)

Location: Sydney, NSW (Remote)

Job Type: Contract Experience: 7+ years

Eligibility: Australian Citizens / PR holders only

About the Role

Our client is looking for an experienced Technical Business Analyst (Data) to join a high-performing data and analytics team on a contract basis. You will act as the bridge between business stakeholders and technical data teams, translating business needs into clear, well-defined data requirements, mappings and specifications that engineers, architects and analysts can build against.

This is a hands-on role for someone who is equally comfortable in a workshop with senior stakeholders and in a SQL editor profiling source data. You will shape data solutions end to end, from discovery and requirements through to testing and delivery.

Key Responsibilities

• Engage with business and technical stakeholders to elicit, analyze and document data and reporting requirements
• Translate business needs into functional and technical specifications, user stories and acceptance criteria
• Perform source system analysis and data profiling using SQL to assess data quality, structure and completeness
• Produce source-to-target mappings, data dictionaries, business glossaries and data lineage documentation
• Work closely with data engineers, data architects and BI developers to design and deliver data pipelines, data models and reports
• Define and validate business rules, transformation logic and data quality checks
• Support data migration, integration and data warehouse / Lakehouse initiatives
• Plan and support User Acceptance Testing (UAT), including preparing test cases and validating outputs against requirements
• Identify data gaps, risks and dependencies, and recommend practical solutions
• Support data governance, metadata management and data privacy practices
• Contribute to Agile ceremonies, including backlog refinement, sprint planning and show-and-tells
• Provide clear status updates and manage stakeholder expectations throughout delivery

Essential Skills and Experience

• 7+ years of experience as a Business Analyst, with a strong focus on data, analytics or data platform projects
• Strong SQL skills for querying, profiling, validating and reconciling data
• Proven experience writing source-to-target mappings and data transformation specifications
• Solid understanding of data warehousing, data modelling (dimensional, relational) and ETL / ELT concepts
• Experience working with modern cloud data platforms (for example Azure, AWS, Snowflake, Databricks or Microsoft Fabric)
• Experience gathering requirements for BI and reporting solutions (for example Power BI, Tableau or similar)
• Strong knowledge of data quality, data governance and metadata management principles
• Experience working in Agile / Scrum delivery environments
• Excellent documentation skills, including BRDs, FRDs, user stories, process flows and data models
• Strong stakeholder management and communication skills, with the ability to explain technical concepts to non-technical audiences
• Strong analytical and problem-solving skills with attention to detail

Desirable Skills

• Experience with data catalogue or governance tools (for example Microsoft Purview, Collibra or Alation)
• Familiarity with transformation tools such as dbt, Azure Data Factory or similar orchestration tooling
• Working knowledge of Python for data analysis
• Experience with Jira and Confluence
• Exposure to data migration programs or large-scale data platform modernisation
• Industry experience in financial services, government, utilities, retail or similar data-rich sectors
• Relevant certifications (for example CBAP, IIBA-CBDA, Azure Data Fundamentals or similar)