Key deliverables to be performed by the consultants include, but are not limited to, the following:
- Participating in the analysis, design, development, and unit testing of all the project’s BI components i.e. Data Mart; Reports, Cubes, and Dashboards;
- Developing Cubes, Reports, and Dashboards using SSAS and SSRS;
- Developing Reports and Dashboards using Power Pivot, Power BI, and Cognos;
- Provide input in ETL requirements and development of ETL solutions using SSIS or Informatica;
- Creating and/or updating data processing overview, technical design, source to target mapping, operation manual and other technical documentation;
- Participating in project design and code walkthroughs;
- Participating in Quality Assurance (QA), System Integration (SIT) testing and supporting the System Acceptance(SAT) and User Acceptance (UAT) Testing;
- Developing, testing, and deploying full code packages for the solution in Visual Source Safe (VSS) and Team Foundation Server (TFS);
- Perform day-to-day tracking, reporting and facilitating resolution of issues and risks for all project activities in TFS;
- Working closely with the subject matter experts, managers, and staff of the ministries on issues and business needs;
- Proposing and developing proof of concept solutions for extending the use of BI technologies within DDSB;
- Participating in discussions with Infrastructure Technology Services (ITS), Corporate Security Branch (CSB), Centre of Excellence for Accessibility and Information Privacy and Archives (IPA) Office to ensure the application remains compliant with all applicable GO-ITS standards;
- Participating in discussions with the business analyst regarding any changes required to business and/or system requirements, as well as requirement gathering sessions;
- Supporting the analysis of existing business processes, design and recommending process improvements to effectively harness the benefits of using the application(s);
- Providing input into and/or completing required architectural/development artifacts;
- Liaising with IT specialists and unit leads and working closely with support team members and relevant stakeholders;
- Contributing to realistic work breakdown structures and project schedules; and
- Developing deployment plans for the production environment.
Skills and Experience
Based on the scope, the Developer must have a minimum of 10+ years of the following skills and experience:
- All General Skills outlined in the “Task-Based I&IT Services” Agreement Programmer/Developer, Level 3
- Demonstrated development experience in an environment where SQL Server, Oracle, SSIS, SSAS, SSRS, Power View, Power BI and SharePoint are used together;
- Demonstrated development experience with SQL Server 2012, 2016, Oracle 10.x, 11.x, 12c databases, and DB2
- Demonstrated experience developing and using re-usable components to assist with BI processes, and providing detailed documentation for the tools that are developed
- Demonstrated experience enhancing performance of SQL Queries
- Demonstrated experience in database management and administration
- Demonstrated experience in debugging queries, cubes, reports and dashboards
- Demonstrated experience working on projects within a multi-client/partner environment, involving multiple highly inter-dependent applications and/or data sources
- Demonstrated experience implementing star schema multi-dimensional models and documenting detailed design models
- Demonstrated analytical, problem-solving, decision-making skills, interpersonal and negotiation skills
- Demonstrated experience working with both the business users and IT development teams to ensure business requirements are properly reflected in the system design and technical specifications
- Demonstrated experience performing system testing and unit testing, and conducting SIT, SAT and UAT Testing
- Demonstrated experience with SDLC processes, Agile and Waterfall methodologies
- Demonstrated written and oral communication skills, as well as presentation skills
- Demonstrated ability to work collaboratively, with the ability to coordinate multiple projects with competing priorities and a track record for meeting strict deadlines