SQL Software Developer - Develop Data Cubes
SQL Software Developer - Develop Data Cubes
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Job Description
Seeking an experienced SQL Developer for design development and maintenance of analytics applications for an initial sixmonth 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 daytoday 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 highpressure 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.
Employment Type
Full-Time
