RQ08166 - Specialized IT Consultant - Intermediate

About this role

Responsibilities:

• Works in partnership with clients, advising them on information technology in order to meet their business objectives or overcome problems, work to improve structure and efficiency of an organizations I&IT systems.

• The I&IT Consultant may be used to provide strategic guidance to organizations with regard to Information Management & IT technology, IT infrastructures and the enablement of major business processes through enhancements to IT.

• Provides subject matter expertise in their field and highly expert technical assistance.

General Skills:

• Acts as the technical advisor/expert on all aspects of a specific deliverable

• Provide the quality assurance/quality control of specific deliverables

• Anticipates and resolves problems to ensure that the deliverables are completed within budget, to the highest quality, meeting or exceeding expectations

• Develops processes and procedures for implementing deliverables

• Prepares reports and presentations including options, recommendations, implementation plans, etc.

• Works with clients to define the scope of a project and to determine requirements

• Defines software, hardware and network requirements

• Analyzes I&IT requirements giving independent and objective advice on the use of I&IT

• Designs, tests, installs and monitors new systems and develops solutions and implementation of new systems

• Familiar with change-management principles and methodology

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

Key deliverables to be performed by the consultants include, but are not limited to, the following:

• Participating in the analysis, design, development and testing on assigned projects;

• Participating in project design and code walkthroughs;

• Perform knowledge transfer to designated Ministry staff, providing expertise and training to business users;

• Establishing relationships with client management and client subject matter experts and staff of the ministries to build knowledge of business directions, issues and operations;

• Participating in the creation of detailed plans and accurate estimates towards development, testing, and implementation of the project or program;

• Participating in and/or leading Joint Application Design sessions with the business and IT teams;

• Contributing to successful project completion by identifying risks and developing/ recommending mitigation strategies;

• Liaising with IT specialists and unit leads and working closely with support team members and relevant stakeholders;

• Facilitating defect, issue and risk resolution by following up with the business to confirm design decisions as required;

• Participating in discussions with the business analyst regarding any changes required to business and/or system requirements, as well as requirement gathering sessions;

• Working closely with the subject matter experts, managers, and staff of the ministries on issues and business needs;

• Creating and/or updating data processing overview, technical design, source to target mapping, operation manual and other technical documentation;

• Providing input into and/or completing required architectural/development artifacts; Consulting with clients, analyzing their business needs and assessing their problems/opportunities, promoting I&IT services, solutions and approaches and ensuring the cluster adds value in supporting business needs

• Systems and Quality Assurance Testing

• Analyzing requirements;

• Creating test strategy test plan, test case documentation and test scripts;

• Documenting expected testing results;

• Creating and modifying complex data-sets for testing purposes;

• Executing functional, regression and performance testing based on the test cases and scripts developed;

• Reporting on the status of test execution and testing results, documenting defects;

• Preparing for, supporting and participating in System Integration (SIT) testing, System Acceptance (SAT) testing and User Acceptance (UAT) testing;

• Implement the automation of new and existing testing scripts using Quick Test Pro v10.0; Creating and executing detailed test cases to support DB2 to Oracle migration of ETL code and data

• Lead and mentor junior QA analysts on the test framework and test execution

• Business Intelligence/Data Analysis and Profiling

• Analyzing business needs and participate in design of the overall project; Leading data analysis and profiling tasks

• Analyzing data in source and target systems to identify data cleanliness issues (e.g. missing values, duplicate meanings, and invalid data)

• Developing complex SQL queries to extract, analyze and validate key business data from a wide-range of data repositories (relational and multi-dimensional data stores, flat files, structure and unstructured)

• Developing automation extraction, validation, cleansing and load scripts

• Developing and supporting the use of Business Intelligence tools and best practices within the branch;

• Providing planning advice to the project team on the use of data, and building capacity within the Ministry on performing advanced analytics and data analysis; Providing direction on the statistical relevance of data to the project team;

• Supporting the analysis of existing business processes, design and recommending process improvements to effectively harness the benefits of using the application(s);

Skills and Experience:
Based on the scope, the consultant must have a minimum of 8+ years of the following skills and experience:

• Analytical problem solving and decision making capabilities;

• Working collaboratively with client organizations and with multiple teams representing various areas in delivering the project;

• Working with multiple teams representing various areas in delivering the project;

• Ability to communicate clearly in both written and verbal formats, to both technical and nontechnical audiences

• Demonstrated ability…