This position is no longer open for applications

SQL Server BI/DW Developer

SQL Server BI/DW Developer (BBBH403) Sydney, Australia

 

Reporting to the Commercial Manager , the BI/DW Developer will provide Design and Build of a new Data Warehouse Solution with further technical, functional and operational development of BI capabilities within this growing organisation. The key focus is on operational excellence and supporting the delivery of the BI solutions and strategy.

BI/DW development may include, but is not limited to, data structure design, application support, dashboard development, incident management, providing training support and implementing enhancements and new technologies / ways of working that will best meet organisational needs. As a senior member of the team, the Senior BI/DW developer will typically lead on BI projects and regularly share technical expertise with other members of the team.

Responsible for:

  • Ingesting data from multiple different sources and performing data transformations.
  • Designing effective layouts using themes and report grids
  • Design effective BI data models in line with the Kimball Methodology
  • Use Power BI to guide readers through a data driven story
  • Work on a backlog of Power BI reports and tasks
  • Be comfortable writing DAX and Power Query
  • Publish reports via the Power BI service, manage them through distribution apps
  • Work with the testing teams to manage the processes around client User Acceptance Testing (UAT)
  • Shaping an approach for governance and deployment of Power BI in large organisations, including advising on licensing and providing training and support

Required Skill Set:

  • Prior experience designing and building a Data Warehouse
  • Advanced SQL
  • Power BI and one other visualisation tool
  • MS SQL Server 2016, 2019
  • Full MSBI Stack (SSIS/SSAS/SSRS)
  • MDX & DAX (Tabular model development
  • Experience of designing conceptual and logical data models
  • The ability to take client requirements, understand them and turn them into appealing visuals using Power BI
  • Experience with one of; Azure Data Warehouse / Azure Data Lake / Azure Data Factory / Azure Analysis Services is an advantage but not essential
  • Strong communication with stakeholders at all levels

Apply below or call Mark for more details, 0438198849

;