SQL Software Developer - Develop Data Cubes

Job Description

Seeking an experienced SQL Developer for design, development and maintenance of analytics applications for an initial six-month period. 

• Develop Data Cubes
• SSAS 
• Multi Dimentional Cubes 
  
  The role will have the following main responsibilities:
   Design & development of analytics applications, data marts, ETL processes, dimensions/facts, MSBI SSAS Cubes & BI reports.
   Manage ETL jobs and data quality testing for data feeds from the upstream enterprise data warehouse feeding into the data analytics applications.
   Research, analyse and implement adjustments to data marts to meet new business requirements and periodic data refresh.
   Develop and update Tabular and Multidimensional data models as well as BI reports based on business requirements.
   Monitor and maintain a high standard of data quality and database performance by optimising the solution code database and server configuration on an ongoing basis.
   Support the Applications Manager in day-to-day management and maintenance of the CaSPA Portal and applications including responding to complex data queries and requests from users of the data.
   Research, analyse and suggest advances in technology to enhance functionality and performance for the analytics applications including developing proof of concepts.
  Main challenges of the role include:
   Anticipating and planning for the technical complexities inherent in information system development, support and integration across complex and expanding data assets and applications.
   Completing the work required in the period allocated, requiring close attention to project timetables and milestones, and the capacity to organise work and meet deadlines in a high volume, high-pressure work environment.
   Successfully managing additional data quality testing, data migration and data reconciliation as new data sources including a new enterprise data warehouse are introduced.