Job Description :
RQ01220 - Solutions Designer Senior Toronto, ON Start Date 2021-04-01 End Date 2022-03-31 Rate: CAD $ 560/Day Assignment Type: Onsite Security Level: No Clearance Required # Business Days: 240.00 Description MSP Notes Shortlisting Date: Tuesday March 23rd at 2:00 pm EST Maximum number of Candidate Submissions: 1 (One) Must-haves: Experience with data architecture designs and technologies for BI solutions, for both on-premise and cloud solutions Experience leading projects that involve technology upgrade/migration to Microsoft BI Suite; determine which part of existing solution needs to be migrated or rebuilt 10+ years of hands on experience ETL development experience using Informatica, SSIS / ADF in a data warehousing environment or large data migration; Working experience in debugging mappings, transformations, mapplets and source qualifier files and Unit testing the newly developed ETL components Extensive experience with source control and environment management Nice to Have: Public Sector experience Assignment Type: This position is currently listed as "Onsite" due to COVID-19 related WFH direction. Once OPS staff are required to return to the office, the resource under this request will be required to work onsite as well. Responsibilities: Undertakes the design of hosting technology solutions based on the client's service specifications, standards, policies, best practices and cost models, in order to meet client application business requirement and project/initiative deliverables. General Skills: Knowledge of integrated networking technologies, mainframe, midrange server, enterprise storage and SAN, and personal computer system technologies Knowledge of related best practices, OPS directory/messaging standards, standard facilities infrastructure/architecture management, facility service delivery processes, infrastructures policies, procedures and direction, cost models and procurement processes, Ability to gather client business requirements; corporate I&IT information mandates, client information technology strategic plans, environment and standards Ability to participate in the development of solutions and provide advice on short/long term solution service development activities. Knowledge of leading edge technologies design criteria, security and recovery procedures, preparation of technical specifications for installation, testing and performance of integrated, multi-services systems; assess performance and capacity of existing system making recommendations for improving performance and develop technical documentation. Experience planning, migrating, implementing and sustaining large complex system development projects Knowledge of technology developments, trends and new products to evaluated application to client short and long term technology requirements. Basic knowledge of project management methodology (e.g. PMBOK), analytical tools and processes. Conceptual and analytical skills to assess and evaluate client needs and conduct cost/benefit analyses for new technology requirements in planning and designing solutions. Experience designing and developing large, complex, highly available, mission critical server applications Experience with systems evaluation to assess conditions, technical performance and capacity of existing systems and determine need and feasibility of expansion, renovation or replacement Excellent analytical, problem-solving and decision-making skills, verbal and written communication skills, interpersonal skills and negotiation skills, team work skills A team player with a track record for meeting deadlines Responsibilities: Undertakes the design of hosting technology solutions based on the client's service specifications, standards, policies, best practices and cost models, in order to meet client application business requirement and project/initiative deliverables. Key deliverables to be performed by the Solution Designer include, but are not limited to, the following: Complete work and achieve milestones within the assigned deadlines; Consult with clients and manages business analysis in order to assess clients' business problems/opportunities and to identify business and technology solutions suited to client needs Develop realistic work breakdown structure and contribute in preparing overall project schedule; Ensure defined Change Management Process is followed for any change from agreed scope, schedule, or quality; Liaise with IT specialists and unit leads and work closely with support team members and relevant stakeholders; Notify the cluster/ministry project manager in writing of any issues or other material concerns related to the assignment deliverables, as soon as the he/she becomes aware of them; Participate in discussions with Infrastructure Technology Services (ITS), Cyber 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; Participate in discussions with the business regarding any changes required to business and system requirements; Participate in working groups and client interviews to define and document needs, processes and problem resolution; Perform daily tracking, reporting and facilitating resolution of issues and risks for all project activities; Provide analysis covering systems requirements, screen design, workflow design, gap analysis, testing, and change management in support of any application changes; Provide clarification to designers, developers, and testers at various stages of SDLC to ensure that any changes or enhancements are fully regression tested and validated; Provide input in creation of change requests; Provide knowledge and skill transfer to a designated cluster/ministry staff; Provides expertise and assistance to cluster functional areas and external service providers in delivering effective technology solutions to clients; Submit deliverables for the cluster/ministry approval; Support the analysis of existing business processes, design and recommend process improvements to effectively harness the benefits of using the application(s); Work closely with the director, managers, and staff on issues and business needs; Work collaboratively with other groups to ensure optimal integration; Comply with the Ontario government and the cluster/ministry's guidelines, standards and procedures such as: o architecture/technology standards and best practices o conflict of interest and confidentiality guidelines o security procedures and practices o Ontario Government I&IT Directive, operational policy on the I&IT project gateway process; and o other applicable guidelines, standards and procedures. Skills: A team player with the ability to coordinate multiple projects with competing priorities and strict deadlines; Excellent analytical, problem-solving, and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills; Long term vision: be able to work with stakeholders to define technical roadmap for current applications, and provide recommendation Knowledge and experience in working in accordance with policies and procedures of the Ontario Public Service; Proven ability to lead technical team to the successful completion of an assignment of this nature, magnitude, and complexity, and demonstrated ability to help them achieve the desired business benefits on schedule and within budget; Proven experience facilitating the resolution of I&IT and Business issues. Experience: The candidate should have 10+ years of experience in the following: Demonstrated experience in performing gap fit analysis and impact analysis Demonstrated advanced experience and skills using Informatica ETL tools (experience with Oracle Data Integrator also an asset) Demonstrated development and solution design experience in an environment where SQL Server, Oracle, SSIS/ADF SSAS, ADF, Power BI are used together Experience leading projects that involve technology upgrade/migration to Microsoft BI Suite; determine which part of existing solution needs to be migrated or rebuilt Experience with data architecture designs and technologies for BI solutions, for both on-premise and cloud solutions Experience with role-based access control implementation, such as with AzureAD Extensive experience with source control and environment management Demonstrated experience designing and developing for WCAB AA (AODA) compliance in web applications Demonstrates development and solution design experience with technology, data, databases, statistics, applications, and networking techniques, tools and practices that enables the candidate to lead the design and development of business intelligence projects Demonstrates experience in working with and analyzing large and diverse data sets, data visualization, KPI development and data profiling to identify relationships and themes Experience Designing Data warehouse components and ETL Scripts Working experience in debugging mappings, transformations, mapplets and source qualifier files and Unit testing the newly developed ETL components Demonstrate experience in the analysis and planning for the modernization of large, complex multi-platform, multi-tier information technology systems; Demonstrate skills and experience with documenting deliverables outlined in Deliverables section; Experience supporting business users working on projects or programs involving multiple highly inter-dependent applications and/or data sources; Experience with requirement management, quality assurance, and change management tools. 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; Extensive experience with GO-ITS standards; Knowledge and experience with OPS corporate gating and enterprise architecture checkpoints processes; and Experience developing solutions involving technologies such as Informatica, SSIS, Oracle DBMS, MSSQL, Cognos, Microsoft BI, GO-Secure, PKI, and data encryption. Knowledge Transfer Transfer From Solution Development / Task-Based I&IT Consultant / Level 3 to Project Manager When Knowledge Will Be Transferred: Knowledge transfer must be completed one week prior to the end of the project or one week prior to the consultant leaving the ministry. What Knowledge Will Be Transferred: All deliverables, including design/supporting/release/training documents must be checked into designated version control repositories (for example, SharePoint All final documents and working drafts related to project requirements or solution design must be stored on designated project repositories (for example, SharePoint site, HPQC, TFS) Project manager and designated ministry staff must be regularly informed in writing (by email) of where documentation has been stored and must be provided a minimum of one walk-through of all documentation as part of the final knowledge transfer activities. How Knowledge Will Be Transferred: Knowledge will be transferred through 1 on 1 sessions, emails, document updates and document review with the team. Note: This position is currently listed as onsite but due to COVID-19 restrictions the consultant will be working remotely until restrictions are lifted. Note: This procurement will also include the option to extend the end date of the project if there are unused effort days and no change to the ceiling amount if the need arises. Skills Experience and Skill Set Requirements Solution Development / Solutions Designer / Senior Technical Experience - 35% Experience with data architecture designs and technologies for BI solutions, for both on-premise and cloud solutions Experience leading projects that involve technology upgrade/migration to Microsoft BI Suite; determine which part of existing solution needs to be migrated or rebuilt 10+ years of hands on experience ETL development experience using Informatica, SSIS / ADF in a data warehousing environment or large data migration; Working experience in debugging mappings, transformations, mapplets and source qualifier files and Unit testing the newly developed ETL components Experience with role-based access control implementation, such as with AzureAD Experience working with Oracle and MSSQL databases Extensive experience with source control and environment management Experience with creating documentations such as data dictionary and data source to target mapping; provide feedback/direction to team on how existing documentations can be improved Experience using PowerDesigner to review data models, as well as make changes and generate DDL's Experience in developing the Application Code package using tools such as TFS. Build automation experience is an asset Core Skills - 35% Long term vision: be able to work with stakeholders to define technical roadmap for current applications, and provide recommendation Working knowledge of systems design and development, and related methods, techniques, practices and standards enable you to analyze and define clients' business and information technology requirements pertaining to data flow and data integration; provide recommendation to business Demonstrates Analytical and problem-solving skills to assess clients' business priorities and needs; to evaluate business and technical design alternatives Working knowledge of technology, data, databases, applications, and networking techniques, tools and practices enable you to lead the design and development of infrastructure related projects. Project Experience and Techniques - 20% Demonstrates lead design experience with technology upgrade / migration projects, and show acumen in being able to evaluate and determine best path going forward Demonstrates experience leading discussions with stakeholders to elicit requirements, developing/consulting on options and solutions, facilitating the resolution of I&IT and Business issues. Ability to drill down on business pain points and determine the right solution, rather than delivering only the item that's being requested by stakeholders Demonstrates development and design experience with SDLC processes, Agile and Waterfall methodologies Public Sector Experience: 10% Previous public sector experience in an organization of equivalent size or complexity to Ontario Public Service Demonstrates experience designing and developing applications that comply with GOITS standards and general OPS processes would be an asset;
             

Similar Jobs you may be interested in ..