Remote Data Tech BA (Contract) - SQL & Data Warehousing

The HR Ally; Sydney; Remote; AUD 96,000 - 165,000; Full time

Job summary

The HR Ally is seeking an experienced Technical Business Analyst (Data) for a contract role in Sydney, NSW (Remote). You will bridge business stakeholders and data teams, turning needs into precise data requirements, mappings and specifications for engineers and analysts to implement.

Responsibilities cover data profiling, source-to-target mappings, data governance, UAT support and collaboration with BI developers to deliver pipelines and dashboards in a cloud environment.

Qualifications

• 7+ years as a Business Analyst with a data focus.
• Strong SQL skills for profiling and validating data.
• Experience writing source-to-target mappings and data transformations.
• Understanding of data warehousing, data modelling and ETL/ELT concepts.
• Experience with cloud platforms (Azure, AWS, Snowflake, Databricks or Fabric).
• Experience gathering requirements for BI/reporting solutions (Power BI, Tableau).
• Knowledge of data quality, data governance and metadata management.
• Experience working in Agile / Scrum delivery environments.
• Excellent documentation skills for BRDs, FRDs and data models.
• Strong stakeholder management and clear communication.

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 and structure.
• Produce source-to-target mappings, data dictionaries and data lineage documentation.
• Collaborate with data engineers, architects and BI developers to design data pipelines and models.
• Define and validate business rules and data quality checks.
• Support data migration and data warehouse/lakehouse initiatives.
• Plan and support UAT, including test case creation and validating outputs.
• Identify data gaps and risks, proposing practical solutions.
• Support data governance, metadata management and privacy practices.
• Contribute to Agile ceremonies and backlog refinement.
• Provide status updates and manage stakeholder expectations throughout delivery.

Skills

SQL

Business analysis

Data modelling

ETL/ELT

Cloud data platforms

BI reporting

Data governance

Agile / Scrum

Documentation

Stakeholder management

Analytical thinking

Tools

Jira

Confluence

dbt

Azure Data Factory

Purview

Collibra

Alation

Python

Job description

The HR Ally is seeking an experienced Technical Business Analyst (Data) for a contract role in Sydney, NSW (Remote). You will bridge business stakeholders and data teams, turning needs into precise data requirements, mappings and specifications for engineers and analysts to implement.

Responsibilities cover data profiling, source-to-target mappings, data governance, UAT support and collaboration with BI developers to deliver pipelines and dashboards in a cloud environment.