Data Analyst

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 escalate 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 Bidisha.Swayamprava@davidsonwp.com, quoting reference JN -102026-44447. To learn more about Davidson, visit davidsonwp.com.