Business Intelligence Developer

Datacom Connect Pty Ltd

Design and Develop data models , develop and perform ET:s to meet business requirements. Support BAU BI Solutions !

  • Great team culture
  • Opportunity can be based in Adelaide or Sydney
  • Build your career in Analytics
The Business Intelligence Developer will be responsible for the service delivery of contact centre work within Datacom Connect BPO (AUS).

What you’ll do

The core objectives of the Business Intelligence Developer include:
  • Design and development of data models, develop and perform ETL’s to meet business requirements
  • Supporting BAU BI Solutions by monitoring and tuning queries and data loads, addressing issues regards data Integrity, monitoring performance and communicating functional and technical issues.
  • Debug, monitor, optimise and troubleshoot database solutions.
  • Research and deliver best practices methodologies
Role Responsibilities

The Business Intelligence Developer is responsible for:
  • Design and development of efficient queries, stored procedure and functions for reporting
  • Define and clarify requirements, propose and develop appropriate solutions, and provide feedback to the reporting team and internal customers
  • Design and implement ETL procedures for intake of data from both internal and outside sources including API calls
  • Establish and maintain automation procedures with a large range of internal and external data sources
  • Create and maintain required documentation
  • Serves as the subject matter expert for Microsoft SQL Server related tools
  • Ensure that issues encountered in production environments are resolved in a timely manner.
  • Perform performance tuning / query optimisation
  • Conduct regular maintenance and improvements to queries and databases
  • Working closely with key Stakeholders to clearly define and understand reporting and data
  • Adapt quickly and effectively to changes in departmental or strategic priorities by responding to requests for additional adhoc requests
  • Perform data reconciliation/verification of reporting
What you’ll Bring
  • Minimum 1 year experience working in a BI, Analytics, Reporting, Database management role
  • Strong Database systems experience
  • Awareness of Business Intelligence and analytical concepts, data visualisation techniques
  • Strong analytical skills and experience of writing complex SQL queries
  • Working knowledge of SQL Server 2008, 2012 & 2016 including SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
  • Strong ETL experience
  • Data modelling skill in SSAS, Tabluar, DAX
  • Programming skills in C#, .Net or Java
  • Business Requirements Analysis and Documentation
  • Demonstrates strong verbal and numerical skills (complex calculations, data analysis and reconciliation, numerical and verbal logical reasoning)
  • Statistical analysis skills
  • Change Management
  • Strong problem solving skills
  • Strong attention to detail
  • Time management & ability to work under pressure.
  • Working knowledge of programming languages ASP.Net/C#/.Net/VB
  • Previous client and stakeholder management experience  
Education
  • Tertiary IT-related degree qualification with 1 years experience preferred OR minimum 2 years experience in the BI industry
  • One major industry certification (MCTS, MCP, MCSA, MSCE etc)
About Datacom

Here at Datacom we connect people and technology in order to solve challenges, create opportunities and discover new possibilities for the communities we live in.
We have over 6,500 people across our global offices and generate an annual revenue of over AU $1.1 billion annually. This makes us one of Australasia’s largest professional IT services companies. We are committed to hiring, developing and promoting diverse talent.
Datacom has extensive expertise in the operation of contact centres, data centres, engineering and application management, as well as payroll and customer service design and operations.
Founded in 1965, we have a successful trading history of consistent growth, profitability and a track record of delivering innovative, cost effective technology solutions. We are local at heart, yet world-class in capability.

Datacom offers a complete employee life cycle: from flexible working arrangements, inspiring leadership programs, development opportunities through to corporate wellness programs and a passion for the importance of work life balance.