This position reports to the Manager of Business Intelligence within the ITS department. Performing in a senior role, this position supports both existing business software systems and develops new ones, as authorized by client business groups through ITS management. This position is involved in all areas of BI systems development, from business concept to implementation.
The public sector client is currently going through a major transformation of one of its main tenant management system to an integrated cloud based housing management solution where upwards of 40 systems will be migrated to the new system. ITS is also building out a new BI roadmap to create a unified BI strategy to provide analytics and future BI capabilities.
This position will assist the BI team to build out the new BI infrastructure to support corporate analytics, reporting and dashboards.
| Education | |
| Minimum required level and specialty/discipline: | University degree in software engineering, computer science, information technology, information systems or equivalent |
| Preferred level and specialty/discipline: | Master’s degree in a related field |
| Experience | |
|
Minimum number of years required and type/area of experience: |
10 years’ experience in designing / architecting high performance ETL programs using T-SQL and SSIS, developing dashboards and reports using Microsoft technologies (SSRS reports, SSAS / Tabular cubes, Power BI), building data warehouses, analytics,
and dimension modeling using IDE tools such as Visual Studio, Eclipse or Jupyter Notebook |
|
Preferred number of years and type/area of experience: |
– 5+ years’ experience with master data management, development on big data platforms (Hortonworks, Cloudera or Azure) and languages such as Python, R or SPARQL
– 10 years’ experience with data modeling multidimensional and tabular models, data management, data migration, data cleansing and synchronization and working with business clients directly by consulting with them to gather requirements to deliver projects – Extensive experience in data engineering, team management and collaboration in an agile environment – ITIL certification |
More Information
- Salary Offers tbc
- Experience Level Senior
- Total Years Experience 5-10
