This position reports to the Manager of Business Intelligence within the ITS department of the client. 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 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 and Experience
| 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: |
– 3+ years’ experience with master data management, development on big data platforms (Hortonworks, Cloudera or Azure) and languages such as Python, R or SPARQL
– 5 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 DevOps engineering, team management and collaboration – ITIL certification |
| Minimum required technical or professional qualifications or certifications/designations: |
| · Passionate about business intelligence, the use of BI and analytics to improve business operations
· Deep understanding of multidimensional and tabular data models · Ability to ensure smooth software deployment by writing script updates and running diagnostics · Ability to create standards and go from design to implementation · Capable of performing SQL Server database backups, restores and patching on Windows environments and advanced database tuning · Excellent oral and written communication skills and ability to present to client groups, to consult with technical and non-technical staff and to prepare reports and proposals · Proficiency in documenting processes and monitoring metrics · Advanced knowledge of best practices related to data encryption and cyber security · Must be able to handle multiple priorities in a fast paced environment · Excellent organizational skills to deliver projects on-time and on-budget · Excellent interpersonal and conflict resolution skills, sensitivity and tact |
| Preferred technical or professional qualifications or certifications/designations: |
| · Experience with working on large scale and multiyear initiatives
· Experience with Microsoft BI stack · Experience with Microsoft Azure, Power BI or other modern BI tools · Experience building SSAS / Tabular cubes and Power BI dashboards / reports against such cubes · Experience in building / designing / maintaining a SQL Server data warehouse · Has worked in large data migration projects · Knowledge and experience with Hadoop, Hortonworks HDP and Linux server environment is a plus · Experience with social housing management is a plus · Excellent analytical skills, able to manage multiple projects under strict timelines, work well in a demanding dynamic environment and meet overall objectives · High level of personal integrity, and the ability to professionally handle confidential matters and show an appropriate level of judgment and maturity · High degree of initiative, dependability and ability to work with little supervision |
Key Responsibilities
| Key Responsibilities | % of Time |
| · Consult with management on the operational requirements of software solutions | |
| · Contributing expertise on information system options, risk and operational impact | |
| · Mentoring junior software developers in gaining experience and assuming DevOps responsibilities | |
| · Managing the installation and configuration of solutions
· Collaborating with developers on software requirements as well as interpreting test stage data |
60 / 100% |
| · Completing code and script updates as well as resolving product implementation errors | |
| · Overseeing routine maintenance procedures and performing diagnostic tests | |
| · Documenting processes and monitoring performance metrics | |
| · Conforming to best practices in network administration and cyber security | |
| · Performs ad-hoc database migrations, upgrades, installations, configurations, troubleshooting and monitoring of SQL Server databases | |
| · Assists with BI project work efforts estimation | |
| · Develops detailed technical specifications, User Guides and ETL documentation including training of users | 20 |
| · Serves as Subject Matter Expert in BI tool development concepts | / 100% |
| · Researches into the current state of BI marketplace to make recommendations and selection criteria for the procurement of new BI tools and technologies | |
| · Coordinates and supports development efforts of technical and corporate staff with database tuning efforts as well as ongoing application implementation, support and upgrades | |
| · Supports production issues and maintenance as necessary – acting as second level support for troubleshooting and resolving BI related applications / databases | 20
/ 100% |
| · Participates in BCP and DR planning, ITSM process improvement, run book creation and service catalog updates | |
| 100% |
More Information
- Salary Offers tbd
- Experience Level Senior
- Total Years Experience 5-10
