Tech Business Analyst

About XPT

• XPT Software Australia PTY Ltd, incorporated in 2016, is a Software Services company
  
• XPT works with top clients across Australia in Banking, Insurance, Telecom, Retail, Energy, Mining and Manufacturing domains.
  
• We have 120+ technocrats in Australia working at our client locations. 
  
• XPT Software Australia is part of group companies which has global presence across India & Europe.
  
• We have served 100+ clients globally, fulfilling their onsite-offshore needs.
  

Position Overview

The Technical Business Analyst – Snowflake Data Platform will work closely with business stakeholders, data engineers, architects and platform teams to support Snowflake data delivery. This role requires a strong mix of business analysis, SQL, Snowflake technical knowledge and hands-on data analysis capability.

The role will translate business discussions into clear technical documentation, review Snowflake views and data logic, create Snowflake objects where required, and support engineers with well-defined requirements, business rules and acceptance criteria.

Role Purpose

The purpose of this role is to bridge the gap between business users and engineering teams by converting business needs into clear, technical and delivery-ready requirements.

The role requires someone who can understand business processes quickly, ask the right questions, review and create Snowflake objects, validate data logic, and support engineers throughout design, build, testing and implementation.

The person in this role should be comfortable working directly in Snowflake to create and maintain approved objects such as views, tables, schemas or prototype datasets to support analysis, validation and engineering handover.

Requirements

Key Responsibilities

Work with business stakeholders to understand business processes, reporting needs, data issues and analytical use cases.

Translate business discussions into clear business requirements, technical requirements, user stories and engineering-ready documentation.

Review Snowflake views, tables, schemas and SQL logic to understand existing data flows, business rules and transformation logic.

Create, update and maintain Snowflake objects such as views, tables, schemas and prototype datasets to support analysis, testing and engineering delivery.

Write Snowflake SQL scripts for data profiling, investigation, reconciliation, validation and requirement clarification.

Document source-to-target mappings, data rules, transformation logic, field definitions, calculations, dependencies and expected outputs.

Support engineers by clarifying business rules, data definitions, source system expectations, dependencies and acceptance criteria.

Analyse existing Snowflake objects to identify data quality issues, duplicate logic, missing definitions, ownership gaps or requirement gaps.

Assess whether existing Snowflake views can support business requirements or whether new data modelling is required.

Support impact analysis for changes to Snowflake objects used by downstream reports, dashboards, users or data products.

Support testing by validating outputs against source data, business rules and expected results, and coordinating feedback from business users.

Work with data engineers, architects, platform teams and business users to ensure requirements are clearly understood and delivered correctly.

Ask relevant questions to confirm scope, assumptions, data meaning, usage, exceptions and expected outcomes.

Learn business processes quickly and build enough domain understanding to support better data and reporting outcomes.