Senior ERP Technical Analyst – Cognos & ETL

Donna Cona Inc.; Ottawa; Hybrid; CAD 100,000 - 125,000; Full time

Job summary

A leading tech consulting firm is seeking a Senior ERP Technical Analyst for a remote role in Ottawa. The ideal candidate must have over 10 years of experience in a large organization, focusing on IBM Cognos solutions and ERP business requirements. Responsibilities include designing and maintaining Cognos infrastructure, optimizing SQL code, and developing documentation. This role also requires a valid security clearance at the level of Reliability.

Qualifications

• Must have a valid security clearance at the level of Reliability.
• Minimum of ten years’ experience in developing and documenting ERP business requirements specifications.
• Experience translating functional and business requirements into technical requirements.
• Experience developing and managing technical aspects of application software.
• Experience conducting unit and system tests.

Responsibilities

• Design and maintain IBM Cognos infrastructure solutions.
• Create documentation for IBM Cognos infrastructure.
• Develop unit test cases for IBM Cognos infrastructure.
• Analyze ERP data for compatibility with IBM Cognos.
• Optimize SQL code for IBM Cognos infrastructure.

Skills

IBM Cognos infrastructure solutions design

Data analysis and reporting solutions

SQL scripting

Technical documentation

ETL process development

Tools

IBM Cognos BI Tools Suite

Job description

Reference #: 8048
Location: Ottawa – remote
Type: Sub-contract

Donna Cona Inc. is currently seeking a Senior ERP Technical Analyst – Cognos & ETL, for one of our key government clients.

Candidate MUST have the following:

• A valid security clearance at the level of Reliability;
• A minimum of ten (10) years’ experience within the last 15 years in developing and documenting ERP business, and/or system requirements specifications;
• Over ten (10) years of experience, within a large organization of over 1,000 employees, performing the following: Developing or assisting with business and functional requirements, project scope, estimates of effort and duration;
• Over ten (10) years of experience, within a large organization of over 1,000 employees, performing the following: Translating functional and business requirements into technical requirements;
• Over ten (10) years of experience, within a large organization of over 1,000 employees, performing the following: Developing and managing technical aspects of application software, user interfaces, and third-party components;
• Over ten (10) years of experience, within a large organization of over 1,000 employees, performing the following: Conducting, assisting with, and managing unit and system tests; and
• Over ten (10) years of experience, within a large organization of over 1,000 employees, performing the following: Establishing technical standards for the technical framework.

Candidate should have the following demonstrated experience:

• Designing, developing, and maintaining IBM Cognos infrastructure solutions, including data conversion process models, ETL specifications, and ETL code;
• Creating and publishing documentation for IBM Cognos infrastructure, including design, maintenance, production deployment instructions, and other related process documentation;
• Defining, documenting, and developing unit test cases for IBM Cognos infrastructure and participating in User Acceptance Testing;
• Eliciting requirements using interviews and workshops, and translating these requirements into use cases and workflows specific to IBM Cognos;
• Defining and building the BI metadata layer within IBM Cognos based on business requirements;
• Reviewing and analyzing ERP data from multiple internal and external sources to ensure compatibility with IBM Cognos;
• Writing SQL scripts to create data extracts for IBM Cognos;
• Developing enterprise-wide data analysis and reporting solutions using IBM Cognos Business Intelligence (BI) Tools Suite;
• Implementing technology best practices, guidelines, and repeatable processes for IBM Cognos infrastructure;
• Providing technical assistance and cross-training to team members and assisting users with IBM Cognos data solutions;
• Analyzing large data sets and optimizing SQL code for IBM Cognos infrastructure;
• Troubleshooting and resolving production issues related to IBM Cognos under tight deadlines;
• Supporting system operations including monitoring, troubleshooting, logging issues, and performing recovery procedures for IBM Cognos; and
• Implementing technology best practices, guidelines, and repeatable processes for IBM Cognos infrastructure.

Donna Cona is committed to a diverse, equitable and inclusive workplace. We are an equal opportunity employer. We don’t discriminate on the basis of gender, gender identity, sexual orientation, race, national origin, disability,age or any other protected status. We are committed to maintaining a barrier free recruitment process by providing equal employment opportunities through recruiting and retention of individuals.

• To apply for this position please complete the form below.
• Name First Last
• Email *
• Daytime Phone *
• City *
• Province/State *
• Attach Cover Letter and Resume * Max. file size: 20 MB. Please note that these must be in one document, and can be in .docx, .doc, .pdf or .rtf formats