Data Analyst

Davidson; City of Melbourne; Hybrid; AUD 90,000 - 130,000; Full time

Benefits offered by this job

Hybrid work arrangement

Job summary

Davidson is seeking a Data Analyst to support a hybrid Melbourne-based role, focusing on data migration, analysis and transformation using Microsoft Fabric and BI tools. You will ensure data quality and assist with governance while engaging with business stakeholders.

The role requires 3–6 years of experience, strong SQL skills, and expertise with Microsoft Dynamics CRM and Power BI. 6-month contract with hybrid work arrangement and the chance to influence data strategy.

Qualifications

• 3–6 years of experience in data migration, analysis and transformation projects.
• Strong SQL skills for analysing, validating and reconciling data.
• Experience with Microsoft Dynamics CRM.
• Experience building Power BI reports and dashboards.
• Experience with Microsoft Fabric or similar Microsoft data platforms (e.g. Azure Synapse, SQL Server).
• Attention to detail and methodical approach to resolving data issues.
• Excellent communication skills across stakeholders.

Responsibilities

• Data analysis and mapping between source and target systems.
• Profile source data to identify quality issues and inconsistencies.
• Create and maintain source-to-target mappings; define transformation rules.
• Write SQL queries to analyse data and test transformations.
• Collaborate with data engineers to implement rules in Fabric.
• Run and monitor migration loads; investigate failures or unexpected results.
• Build Power BI reports to track migration progress and data quality.
• Document mappings, rules, tests and issue logs.

Skills

SQL proficiency

Attention to detail

Communication skills

Independence

Collaboration

Education

Bachelor's degree in Computer Science or IT

Tools

Microsoft Dynamics CRM

Power BI

Microsoft Fabric

Azure Synapse

SQL Server

Job description

JOB TITLE: Data Analyst (Microsoft Dynamics CRM)

JOB LOCATION: Melbourne, VIC (Hybrid)

JOB DURATION: 6-month contract

About the Role:

We are seeking a skilled and detail-oriented Data Analyst to join our team. The ideal candidate will have 3-6 years of experience in data migration, analysis, and transformation projects, with a strong background in Microsoft Fabric and business intelligence (BI) tools. This role involves ensuring the seamless migration of data between systems while maintaining data quality, integrity, and performance standards.

Key Responsibilities:

Data analysis and mapping

• Analyse source and target systems to understand data structures, relationships and business meaning.
• Profile source data to identify quality issues, duplicates, gaps and inconsistencies.
• Create and maintain source-to-target mappings.
• Work with business stakeholders to define transformation and cleansing rules.

Migration support

• Write SQL queries to analyse data and test transformation logic.
• Work with data engineers to make sure transformation rules are implemented correctly in Fabric.
• Run and monitor migration loads and investigate failures or unexpected results.
• Support cutover activities, including readiness checks and post-cutover validation.

Testing, validation and reconciliation

• Plan and run pre- and post-migration testing.
• Reconcile source and target data using row counts, totals and field-level comparisons.
• Log, track and follow up data issues through to resolution, and escalte risks early.
• Build Power BI reports to track migration progress, data quality and reconciliation results.

Data quality and governance

• Help business owners decide how to handle data quality issues, such as cleansing, excluding or accepting them.
• Handle sensitive and personal information in line with the Privacy Act 1988 and internal data policies.
• Support governance activities such as data definitions, ownership and classification.

Collaboration and documentation

• Act as the link between business stakeholders and the technical team on data requirements.
• Maintain clear documentation, covering mappings, business rules, test results and issue logs.
• Provide regular status updates to the project team.

Key Selection Criteria:

• Please address each of the following in your application, in [no more than two pages].
• Demonstrated experience in data migration or data analysis projects, including data profiling and source-to-target mapping.
• Strong SQL skills for analysing, validating and reconciling data.
• Your experience with Microsoft Dynamics CRM.
• Experience building Power BI reports and dashboards.
• Experience working with Microsoft Fabric or similar Microsoft data platforms (e.g. Azure Synapse, SQL Server).
• Strong attention to detail and a methodical approach to investigating and resolving data issues.
• Excellent communication skills, including gathering requirements and explaining data issues to non-technical stakeholders.

Education & Experience:

• Bachelor's degree in computer science, Information Technology, or related field.
• 3-6 years of experience as a Data Analyst, preferably with Microsoft Dynamics CRM.

Other Skills:

• Strong problem-solving skills and ability to troubleshoot technical issues.
• Excellent communication and collaboration skills.
• Ability to work independently and as part of a cross-functional team.

Preferred Qualifications:

• Knowledge of Agile methodologies.
• Relevant Data/Business Analysis certifications.

Please submit your current resume to apply. If you'd like a confidential discussion about the role, please contact Bidisha Swayamprava on [e-mail], quoting reference JN -102026-44447. To learn more about Davidson, visit davidsonwp.com.