Resource Logistics, Inc.

RFS-RAU-4345: AA SHSM - Software Dev - Senior (BB-B6B62)

Found in: Neuvoo CA

Description:
Must-haves:

  • Demonstrated experience designing, developing and implementing Reports, Dashboard and other Business Intelligence solutions using Cognos 10 or higher and Microsoft Power BI




Nice to Have:


  • Public Sector experience

  • Experience delivering highly scalable, multi-tier, enterprise web applications utilizing the full Microsoft .NET Stack, including: ASP. NET, Web Forms, MVC, WCF, WWF, Microsoft Dynamics, C#, Entity Framework, LINQ, XML/XSLT, Dapper, BreezeJS




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:



Required to translate technical systems specifications into working, tested applications. This includes:

developing detailed programming specifications

writing and/or generating code

compiling data-driven programs, maintaining, and conducting unit tests

Resolves and troubleshoots technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion and migrations



General Skills:



Experience in programming and analysis; specialized software package support at the specified experience level

Ability to collaborate with IT Professionals throughout the Software Development Life Cycle

Experience in structured methodologies for the development, design, implementation and maintenance of applications

Experience in design, code, test, debug and document applications

Experience in the use of object and/or third generation language development tools

Experience in one or more programming languages

Experience in application design, latest design patters, deployment and troubleshooting

Experience with relational and hierarchical database technologies

Experience in the use of information retrieval packages using query languages

Experience with one or more communications protocols

Experience in structured methodologies for the design, development, implementation and maintenance of applications

Experience eliciting and documenting information from diverse business area stakeholders and subject matter experts

Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills

A team player with a track record for meeting deadlines



Desirable Skills:



Knowledge and experience with programming Internet-ready applications

Knowledge and experience in rapid application development (RAD) methodologies

Knowledge and understanding of Information Management principles, concepts, policies and practices

Experience with middleware and gateways

Experience reviewing, analyzing, and modifying product installation scripts including encoding, testing, debugging

Ability to provide post-implementation support and resolve any post-implementation technical issues

Experience conducting design walkthrough sessions with project team

Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards

Ability to provide user and system documentation as required



Background:



The Community Services I&IT Cluster (CSC) of the Ontario Public Service serves the Training, Colleges, and Universities (MTCU), Education (EDU), Municipal Affairs and Housing (MMAH), and Tourism, Culture and Sport (MTCS) Ministries. The Data Collection and Decision Support branch (DDSB) within CSC provides data collection and analytic service to all four client ministries.

DDSB supports the ministries by providing information management tools that help enable public policy decision making, business and strategic planning, and program support and improvement.



Objective:



A Senior Software Developer is required to develop a new solutions for the data collection and reporting tool used to support the Student Achievement Division (SAD) projects initiative and develop enhancements for the existing applications being used by the Student Achievement Division in production today. The successful candidate will work with various technology teams to translate business needs and work through the analysis and lead the development phases. The successful candidate will also work on research activities to understand industry standards and best practices to help develop a cluster wide solution.

Scope:

The resource will provide services for multiple data collection projects under the direction of the Senior Technical Manager, Data Collection Projects team. The Software Developer will provide innovative solutions for the support tasks described below in this RFS.



Responsibilities/Assignment Deliverables:

Services and deliverables to be provided by the Vendor s Personnel will include 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 IBM Cognos & Microsoft Power BI, SSRS, SSAS, SSIS

  • Proven Infomatica ETL development experience in a complex environment

  • Strong working experience in an environment where Informatica (vers 9.x or higher), DB2 or

  • Oracle, and Sun Solaris are used together

  • Experience working with Oracle 10.x and 11.x databases

  • Knowledge and experience with technologies including: .NET framework (4.0+), ASP.NET, MVC, Entity framework, WCF;

  • Experience in implementing projects tracking solutions with Workflow engine + accessibility;

  • Knowledge and experience with OPS corporate gating and enterprise architecture checkpoints processes; and

  • Experience designing solutions involving technologies such as .NET, SOA, Oracle DBMS,

  • Cognos, GO-Secure, PKI, and data encryption.

  • 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;

  • Complete work and achieve milestones within the assigned deadlines;

  • Consults 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;

  • Lead discussions with the business regarding any changes required to business and/or system requirements;

  • 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 and complete architectural artifacts;

  • Provide input in creation of change requests;

  • Provide knowledge and skill transfer to a designated cluster/ministry staff;

  • Participate in the analysis, design, development and testing of new and existing projects;

  • Analyze the new development needs and design, develop and unit test all the project s ETL components i.e. mappings, sessions, and workflows;

  • Assess the performance of existing ETL components and develop performance enhancements; Develop ETL process overview and ETL design documents including Informatica batches, load flows document; Participate in the SIT testing and support the System Acceptance and User Acceptance Testing;

  • Develop, test and deploy full code package for projects in MS Visual Source Safe or Team Foundation Server;

  • Create and update build, deployment and other technical documentations to ensure a thorough record of solution delivery and a smooth transition to operations; and Participate in project design and code walkthroughs.

  • 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: architecture/technology standards and best practices conflict of interest and confidentiality guidelines security procedures and practices; Ontario Government I&IT Directive, operational policy on the I&IT project gateway process; and other applicable guidelines, standards and procedures.


The Solutions Designer must have the following 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;

  • Expert skill with MS Office software, including Word, Excel, PowerPoint, Access, and Visio;

  • Expert skill with PowerDesigner;

  • Knowledge and experience in working in accordance with policies and procedures of the Ontario Public Service;

  • Proven ability to lead business users 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; and proven experience facilitating the resolution of I&IT and Business issues.




Experience: The Solutions Designer should have 10+ years of experience in the following:


  • Demonstrated experience with data and statistical analysis

  • Demonstrated experience enhancing performance of data collection applications

  • Demonstrated experience in debugging queries, cubes, reports, dashboards, and framework manager

  • Demonstrated experience working on projects within a multi-client/partner environment, involving multiple highly inter-dependent applications and/or data sources

  • Demonstrate experience in managing deployment processes and hand-off, documentation and KT to operation and other teams

  • Demonstrate experience in performing gap fit analysis and impact analysis;

  • Demonstrate experience in the analysis and planning for the modernization of large, complex multiplatform, multi-tier information technology systems;

  • Demonstrate skills and experience with documenting deliverables outlined in Deliverables section;

  • Experience in dealing with system solutions related to funding calculations, financial information management, and web-based n-tier technology implementation;

  • Experience in documenting business processes, business requirements, and system requirements.;

  • Experience in the development of various deliverables of various roles including, but not limited to, applications architect, data architect, systems analyst, system designer, documentation specialist, etc. throughout SDLC;

  • Experience supporting business users working on projects or programs involving multiple highly inter-dependent applications and/or data sources;

  • Experience in developing the Application Code package using MS Visual Source Safe an Team Foundation Server

  • Experience with OPS Zachman architecture checkpoint review process and deliverables at both cluster and corporate levels;

  • Experience with requirement management, quality assurance, and change management tools.

  • Experience with TRAs, PIAs, and Security Systems within the OPS;

  • Experience working on projects within a multi-client/partner environment;

  • 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 Transfer

Transfer From Solution Development / Software Developer / Senior to Project Manager / Designated CSC Resource



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 / Software Developer / Senior



Technical Skills 40%


  • Demonstrate experience designing, developing and implementing Reports, Dashboard and other Business Intelligence solutions using Cognos 10 or higher and Microsoft Power BI

  • Experience in leading development and modelling of applications, specifically hierarchical data model applications

  • Working knowledge of the entire Data Dictionary, data mapping

  • Working knowledge of the Business Process Design Re-engineering for applications

  • 5+ years of demonstrated experience and skills using Oracle Data Integrator and/or Informatica ETL tools

  • Experience enhancing performance of ETL code and SQL Queries

  • Experience developing ETL routines using Informatica and/or SSIS in a data warehousing environment or large data migration

  • Experience Designing Data warehouse components and ETL Scripts

  • Experience working with Oracle Databases (version 10.x or higher), DB2 Database, and with complex kornshell scripts

  • Experience in designing RDBMS SQL, DML and DDL (DB2 and Oracle) and the architectural implications associated with each platform in regards to ETL

  • Working experience in debugging mappings, transformations, mapplets and source qualifier files and Unit testing the newly developed ETL components

  • Experience in developing the Application Code package using MS Visual Source Safe

  • Demonstrated experience performing system testing, unit testing, and user acceptance testing

  • Demonstrates development and solution design experience in an environment where Oracle, Informatica and Cognos are used together for data warehousing and business intelligence

  • NET framework (4.0+), ASP.NET development, MVC, Entity framework, business entities, WCF, WFF, MS Dynamics, LINQ, preferable experience in implementing projects tracking solutions with Workflow engine + accessibility

  • ASP.NET development with C#, Web forms, jscript for multi browser support, CSS with full WCAG AA compliance in developing web applications, preferable experience using screen reader (Jaws) for testing and compliance Sherriff tool

  • Experience delivering highly scalable, multi-tier, enterprise web applications utilizing the full Microsoft .NET Stack, including: ASP. NET, Web Forms, MVC, WCF, WWF, Microsoft Dynamics, C#, Entity Framework, LINQ, XML/XSLT, Dapper, BreezeJS

  • Demonstrated experience developing systems using client-side libraries (Bootstrap, Angular JS, JQuery, JavaScript), HTML5/CSS3

  • Demonstrated experience working with relational databases (Oracle, MS SQL Server, etc.)

  • Experience with data transfer technologies such as Microsoft MQ, SSIS, SSRS Proven experience with JAD facilitation, interpreting business needs to technical requirements, project meetings for reviews




Core Skills - 40%


  • Experience leading or working in development teams.

  • Proven experience using a variety of methodologies to carry-out the software development lifecycle (e.g., Agile, waterfall, etc.).

  • Demonstrated experience in the analysis and planning for the modernization of large, complex, multi-platform, multi-tier information technology systems.

  • Experience working on projects within a multi-client/partner environment Demonstrable experience with requirement management, quality assurance, and change management tools.

  • Experience creating technical specifications or development documentation.

  • Troubleshooting of production issues and creating fixes for any unplanned deployments

  • Defect investigation, resolution and assignment to team members using defect/issue management tools, e. g. Client ALM or Client Service Manager

  • Experience performing the design of data warehouse and related components

  • Experience with systems design and development, and related methods, techniques, practices and standards

  • Working Knowledge of technology, data, databases, applications, and networking techniques, tools and practices enable you to lead the design and development of infrastructure support projects

  • Working Knowledge of aggregate reporting

  • Proven ability to lead business users 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.

  • Experience with MS Office software, including Word, Excel, PowerPoint, Access, and Visio




Communication Skills - 20%


  • Demonstrated analytical, problem-solving, and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills;

  • Experience in dealing with multiple teams representing various areas in delivering the project; Demonstrated capacity to work collaboratively with client organizations;

  • A team player with a track record for meeting strict deadlines;

calendar_today2 days ago

Similar jobs

location_onToronto, Canada

work Resource Logistics, Inc.

Apply:
I expressly authorise the Terms and Conditions