Data Analyst (x5 Roles) (Locations: VIC, TAS, SA)

Advance Delivery Consulting; Hornsby; On-site; AUD 80,000 - 110,000; Full time

Job summary

Advance Delivery Consulting is seeking a data analyst with 5–7 years of experience to profile and present data for business and management teams, and to lead ETL development and data migration tasks. You will interpret data and reporting aspects, identify patterns and trends, collaborate with cross-functional teams, and document data mapping rules for migration.

Experience with SSIS/SSRS and SQL is essential.

Qualifications

• 5-7 years of experience in data analysis and development.
• Solid consulting ability across SSIS/SSRS, data profiling, SQL, and data cleansing.
• Strong problem-solving and prioritization skills.
• Experience in client-facing roles with stakeholder management.

Responsibilities

• Analyze, profile and present data for business and management teams.
• ETL development and data migration tasks.
• Interpret data and reporting aspects for business users and stakeholders.
• Present data to business consumers, highlight gaps and issues on data from Source.
• Identify patterns and trends in data sets.
• Collaborate with business, solution, or technical teams to define needs.
• Document data mapping rules for migration.

Skills

Data analysis

Data development

SQL proficiency

Problem-solving

Client-facing experience

Tools

SSIS

SSRS

SQL

Data profiling tools

Data cleansing tools

Job description

• Expertise in SQLskills to profile the data.
• Analyze, Profile and systematically present the data for Business and management team understanding.
• ETL development and Data Migration tasks
• Interpreting the functional aspect of data & reporting aspects of data.
• Present the data to business and the consumers of the data which qualifies the scope and highlight gaps/issues on data from Source.
• Identifying patterns and trends in data sets
• Working alongside teams within the business, Solution team or the Technical team to establish business needs.
• Documenting the data mapping rules for migration.

Job Description

• Expertise in SQLskills to profile the data.
• Analyze, Profile and systematically present the data for Business and management team understanding.
• ETL development and Data Migration tasks
• Interpreting the functional aspect of data & reporting aspects of data.
• Present the data to business and the consumers of the data which qualifies the scope and highlight gaps/issues on data from Source.
• Identifying patterns and trends in data sets
• Working alongside teams within the business, Solution team or the Technical team to establish business needs.
• Documenting the data mapping rules for migration.

Skills And Experience

• 5-7years of experience in Data Analysis & Development experience
• Have solid consulting ability across SSIS, SSRS, and expert in data profiling/analysis, SQL, and data deduplication/cleansing processes
• Strong Problem-Solving Skills – Ability to analyze and critically evaluate gathered information to resolve conflicts, anticipate issues, and make priority decisions.
• You will have ideally worked within a client-facing capacity, with the interpersonal and communication skills to manage and influence key relationships with stakeholders.