Software Engineer–Junior and Mid

Advance Delivery Consulting; Council of the City of Sydney; On-site; AUD 50,000 - 120,000; Full time

Job summary

A consulting firm in data analysis is seeking a Software Engineer to analyze master data sets and troubleshoot data issues. You'll need strong SQL skills and experience in data analysis tools. This role demands excellent problem-solving skills and the ability to work with business stakeholders. The expected salary for Junior roles ranges from $50,000 to $80,000, while Mid roles offer $80,000 to $120,000 per year.

Qualifications

• 1+ years for Junior role, 3+ years for Mid role.
• Experience in data profiling and analysis.
• Experience in a client-facing capacity.

Responsibilities

• Analyse master data set and troubleshoot data issues.
• Document data mapping rules for migration.
• Identify patterns and trends in data sets.

Skills

SQL skills

Data analysis

ETL development

Data profiling

Problem-solving

Communication skills

Education

Relevant degree in IT industry

Certification in Relevant Technologies

Tools

SSIS

SSRS

Informatica

Job description

Advance Delivery Consulting – Sydney CBD NSW

You will have the opportunity to work with one of the largest companies in Australia based in the Sydney CBD/Melbourne. You will be challenged to take responsibility for analysing master data set and troubleshooting data issues. To do well in this role you need a very fine eye for detail, experience as a software engineer in a data space, and deep understanding of popular data analysis tools and databases. The role will also encapsulate extensive knowledge and experience in ETL development using Informatica

Job Description

• Expertise in SQL skills to profile the data.
• Analyse, 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 aspect 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

• 1+ years of experience in Data Analysis & Development experience – Junior role
• 3+ years of experience in Data Analysis & Development experience – Mid role
• 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.
• Experience in Health Cover and insurance domain desirable not mandatory.

Qualification

• Relevant degree in IT industry mandatory
• Certification in Relevant Technologies

Role Code: Software Engineer

Junior Role: $50,000.00 – $80,000.00 per year

Mid Role: $80,000.00 – $120,000.00 per year