JOB DETAILS

Background and job description:
  
The Senior Business Intelligence Developer plays a critical role in the successful development and delivery of Business Intelligence (BI). Taking responsibility of development oversight, guidance, and direction setting for the data warehouse and business intelligence platforms. The ideal candidate is a self-motivated, highly detail-oriented team-player with a positive drive to strategize and implement BI solutions that enable the business to derive valuable insights. You will join a tight knit group of key contributors who are actively working together to achieve aggressive goals and meet timelines to drive the business forward.


Key accountabilities include:

1. Understand the Business Context and Requirements
2. Understand the required tasks and steps for this project (e.g. Source to EDW to Cube to report)
3. Collaborate with other team members to achieve business objectives
4. Complete Design, Data Models, Loading Approaches and Source to Target mapping documents
5. Develop ETL/ELT for Azure Data Warehouse (using SSIS, PolyBase, AZCopy and PowerShell)
6. Create and manage entities, business rules and strategies in master data management
7. Deploy and Execute ETL in different Environments
8. Develop Cubes and Reports in Microsoft BI tools including Power BI and Azure Analysis Services
9. Develop and conduct unit tests
10. Develop and execute automated test cases using SQL, MDX/DAX, PowerShell, C# and manual steps
11. Conduct initial Root Cause Analysis and defect triage
12. Deploy and Execute tests in different Environments

  
Selection Criteria:

1. >5 years developing working in Business Intelligence environments
2. >5 years’ experience working with Microsoft SQL databases
3. Comprehensive SQL and DAX knowledge and experience
4. Experience in working with large, complex Data Warehouses using the Microsoft BI Stack within an Azure or cloud based environment

Please contact me directly for more information.

  
Gavin Kemp
Enterprise Practice Lead
hcmaustralia
t  +61 2 8088 1811 
m +61 424 001227
e  gavin.kemp@hcmaustralia.com.au