Sql data analyst Jobs in Ottawa, ON

Join Exposant 3 (E3): The Power of People at the Heart of Technology!

Exposant 3 is a consulting firm in business management and information technology, dedicated to supporting companies and organizations in their digital and organizational transformation.

👉 Your Career at Exposant 3

We firmly believe in healthy and humane management, where trust, competence, and the joy of succeeding together are at the core of our values.

We offer you more than just a job: join an innovative team where artificial intelligence, process automation, and technological modernization are part of everyday life. At Exposant 3, we put people at the heart of everything we do.

🚀 Our Vision?

To enable you to deploy "the power of the human Exposant 3":

• The power of the individual: An environment where your commitment is valued.
• The power of the team: Strong collaboration where mutual support and successes are shared.
• The power of the company: A common vision for ambitious and collective goals.

If you are looking to grow in a dynamic environment and contribute to large-scale projects while growing within a humane, innovative, and rapidly expanding company, then Exposant 3 is for you!

We are looking for our future Systems Analyst Lvl3 to join our teams.

🎯 Your Missions / Tasks :

• Create and modify code and software for the RCMP MPS application.
• Create and modify screens and reports within the RCMP MPS environment.
• Gather and analyze data to conduct studies establishing the technical and economic feasibility of proposed computer systems enhancements for MPS, and develop functional and system design specifications related to MPS.
• Design methods and procedures for small computer systems and sub-systems of larger systems, specifically within or integrating with MPS.
• Develop, test, and implement small computer systems and sub-systems of larger systems, specifically within or integrating with MPS.
• Produce forms, manuals, programs, data files, and procedures for MPS systems and/or applications.
• Create process flow manuals for online screens (English and French screens).
• Document the COBOL CICS programs (PAYTCICS, PENTCICS, TADSCICS, and PAYOCICS).
• Create process flow manuals for payroll batch programs.
• Conduct quality assurance (QA) and integration testing.
• Adhere to and contribute to the Service Level Agreement with the business.
• Document their payroll system expertise and knowledge artifacts for the team.

📝 Your Profile / Requirements :

1. Minimum of six (6) years of experience within the last ten (10) years, leading system analysis for large-scale payroll systems performing the tasks listed below:
   1. Deep expertise in payroll policies, pay structures, retroactive pay, leave payouts, and system audits.
   2. Leading workshops, validating business rules, modeling logic and workflows.
   3. Creates functional architecture, test case scenarios, and leading traceability mapping.
   4. Coordinates with multiple stakeholders, including developers and Quality Assurance personnel (QA).
   5. Defines test strategies, supporting User Acceptance Testing (UAT), and signing off on business functionality.
   6. Evaluates complex business issues, assessing regulatory updates, and leading root cause analysis.
   7. Maintaining system documentation, decision logs, and business rules, and libraries.
2. Minimum of five (5) years of experience within the ten (10) years, contributing to the development of functional specifications for computer systems development, design, and implementation
3. Minimum of five (5) years of experience, gained within the last ten (10) years, contributing to and/or leading the development of functional specifications for computer systems development, design, and implementation.
4. One of the following qualifications :

A Bachelor’s degree in Business, Information Technology (IT), or a related field,

OR

A Post-Secondary certification in Business Analysis or Systems Analysis, and a minimum of ten (10) years of experience as a System Analyst,

OR

Holds a relevant professional certification such as ITL, CBAP (Certified Business Analyst Professional), or PMP, and a minimum of ten (10) years of experience as a Systems Analyst.