Get AI-powered advice on this job and more exclusive features.
Direct message the job poster from CloudMarc
Our client is mid-flight on a multi‑source data migration and warehouse modernisation initiative feeding downstream analytics, finance, and regulatory reporting layers. We need a Senior Test Analyst who lives and breathes data quality — someone who can interrogate complex SQL, reconcile billions of rows across stages, and translate anomalies into actionable defect reports business leaders can trust.
Role Snapshot
You will own end‑to‑end test planning and execution across data ingestion, transformation, and reporting validation streams. The role spans source‑to‑target mapping verification, ETL batch validation, record‑level and aggregate reconciliation, and functional validation of reporting objects (where applicable: Power BI, Tableau, or similar).
Key Responsibilities
* Analyse source-to-target data mapping specs; design test conditions and sampling strategies for migration waves.
* Write and execute complex SQL queries to validate counts, sums, referential integrity, and business rules across staging, warehouse, and reporting layers.
* Perform large-volume data reconciliation (row-level & aggregate) between legacy and target platforms.
* Conduct data quality checks (nulls, duplicates, format/length, domain values, surrogate keys, slowly changing dimensions).
* Support validation of reporting artefacts (e.g., Power BI datasets, DAX measures, visuals) to ensure alignment with underlying data.
* Log, triage, and track data defects; drive resolution with Data Engineering, BI, and Business SMEs.
* Produce metrics dashboards: requirement traceability, data validation coverage, defect burn‑down, and migration readiness status.
* Communicate progress, issues, and go/no‑go data quality recommendations to project leadership.
Required Skills & Experience
* 7+ years overall testing, with strong recent focus on data migration / data warehouse testing.
* Advanced SQL (joins, window functions, aggregation, subqueries, CTEs; performance-aware scripting for large datasets).
* Experience validating data warehouse / data lake environments (row counts, balancing, schema checks, partitioning, historical loads).
* Solid understanding of ETL/ELT workflows, data modelling concepts (star/snowflake, slowly changing dimensions), and data quality frameworks.
* Proven ability to build repeatable data reconciliation packs and defect/traceability reporting for stakeholders.
* Experience with Power BI testing (datasets, DAX measures, visuals) preferred.
* Excellent communication and stakeholder engagement — able to translate technical data findings for non-technical audiences.
Nice to Have
* Python or shell scripting for data comparison automation.
* Experience with data profiling tools (Great Expectations, dbt tests, Informatica Data Quality, Talend).
* Familiarity with test management / reporting tools (Azure DevOps Test Plans, Zephyr, XRay, TestRail).
About CloudMarc CloudMarc partners with enterprise and government organisations to deliver software and data outcomes with quality engineered in from day one. Our teams span Australia, India, and the Philippines, bringing deep capability across test automation, performance engineering, data quality, and large‑scale program delivery. Contractors joining via CloudMarc gain access to playbooks, peer forums, and rapid mobilisation support so you can focus on delivery.
Seniority level
* Seniority level
Not Applicable
Employment type
* Employment type
Contract
Job function
* Job function
Consulting
* Industries
IT Services and IT Consulting
Referrals increase your chances of interviewing at CloudMarc by 2x
Get notified about new Test Analyst jobs in Sydney, New South Wales, Australia .
Senior Test Analyst - Automation, 12 month FTC
Sydney, New South Wales, Australia 6 days ago
Sydney, New South Wales, Australia 5 days ago
Sydney, New South Wales, Australia 1 day ago
Sydney, New South Wales, Australia 5 days ago
Millers Point, New South Wales, Australia 1 day ago
Senior Test Analyst - Functional Testing
Sydney, New South Wales, Australia 4 days ago
Sydney, New South Wales, Australia 3 weeks ago
Sydney, New South Wales, Australia 1 day ago
Millers Point, New South Wales, Australia 1 day ago
Parramatta, New South Wales, Australia 1 week ago
Bella Vista, New South Wales, Australia 2 weeks ago
Sydney, New South Wales, Australia 7 hours ago
Senior Quality Engineer - SAP Success Factors
Sydney, New South Wales, Australia 4 days ago
Sydney, New South Wales, Australia 3 weeks ago
Bella Vista, New South Wales, Australia 3 weeks ago
North Ryde, New South Wales, Australia 1 week ago
Sydney, New South Wales, Australia 13 hours ago
Sydney, New South Wales, Australia 3 days ago
Senior Business Analyst / Quality Assurance (BA/QA)
Sydney, New South Wales, Australia 6 days ago
Sydney, New South Wales, Australia A$70.00-A$90.00 2 weeks ago
Sydney, New South Wales, Australia 4 days ago
Sydney, New South Wales, Australia 3 weeks ago
Chatswood, New South Wales, Australia 2 weeks ago
Sydney, New South Wales, Australia 2 weeks ago
Sydney, New South Wales, Australia 4 days ago
Sydney, New South Wales, Australia 2 weeks ago
Sydney, New South Wales, Australia 3 days ago
Sydney, New South Wales, Australia 2 weeks ago
Sydney, New South Wales, Australia 1 day ago
Sydney, New South Wales, Australia 2 months ago
We're unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr