BI/SQL Developer

Job Title: BI/SQL Developer
Location: Brisbane
Salary: $110000.00 - $130000.00 per annum
Start Date: 2018-02-22
Reference: JO-1802-517084
Contact Name: Carolina Ferraz
Job Published: February 22, 2018 12:07

Job Description

Key Responsibilities:
- Derive data models from business requirements following industry best practices and data architecture standards;
- Design and implement database structures and dimensional models to match business requirements;
- Develop performance tuning and query optimization plans for existing database applications
- Follow database development standards and implement industry good practices;
- Design and develop SSIS packages to perform ETL tasks to and from the data warehouse and between enterprise applications;
- Design and develop and deploy SSRS reports;
- Ensure data accuracy, security, and integrity and follow established development and
migration procedures and standards;
- Timely respond and assist with ad-hoc report and data analysis requests;

Experience and Qualifications:
- Strong skills in database querying and programming;
- Sound knowledge of database design and implementation;
- Strong knowledge of SQL Server Integration Services and ETL best practices;
- Solid knowledge of SQL Server Reporting Services;
- Desirable experience with previous data warehouse implementations and BI solutions using Microsoft BI/SQL platform;
- Relevant Microsoft Certification on SQL Server is desirable;
- Excellent communication skills;

Selection Criteria:

- Demonstrated 5+ years of experience with SQL Server database implementation and programming;
- Demonstrated 5+ years of data modeling and warehouse implementation;
- Demonstrated 2+ years of experience with SSIS packages development, SSRS report development;
- Ability to meet tight deadlines and to react positively to shifting priorities;
- Strong analytical and problem-solving skills;
- Ability to work independently and as part of a team;
- Excellent communication skills;

- Relevant tertiary qualification;
- Microsoft certifications in SQL Server;
- Previous experience with finance industry