Description
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 patterns, 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
- 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
This position is listed as “Onsite”; the resource is expected to work 7.25 hours per calendar day between the standard working hours of 8:00-5:00 PM (excluding lunch breaks) every Monday to Friday inclusive at the identified OPS office location.
Experience Requirements
Development Skills 40%
- 5 +years of experience in data analysis developing business intelligence and reporting in a medium to large size corporate environment demonstrating detailed knowledge of BI functions such as analytics, data modeling \& data mining, reporting, report conversion and data cleansing.
- Experience in Azure Databricks, Delta Lake, Azure Storage, ADF, Azure Analysis Service
- Design and develop BI dashboards and reports based on business requirements
- Implement, maintain, and support BI solutions in Microsoft and other BI platforms
- Complete committed backlog and sprints within the agreed upon timeframe
- Curate data from multiple data sources for an efficient presentation in an enterprise environment
- Recommend improvements to streamline processes regarding data flow and data quality to improve data accuracy, usability, and value
- Remain abreast of technology developments within fields relevant to current and future BI and Reporting initiatives
- Document “As Built’ reports and all data transformations deployed to production
- Take ownership of end-to-end development of each dashboard and report being developed
Technology Skills 35%
- Experience with cloud platform like Azure and working knowledge for cloud migration
- Experience with Microsoft Azure data analytics tools, such as, Azure Data Factories, Azure Databricks, Azure Synapse
- Expertise in advanced prediction and prescriptive analytics including machine learning algorithms, designing experiments, fraud detection
- Internally motivated and adaptable, able to work proficiently both independently and in a team environment.
- Managing PowerBI workspaces, report access, report deployment, developing best practices in an enterprise environment
- Strong knowledge and experience in analyzing as well as designing data models that meet the reporting needs
- Advance knowledge of writing complex SQL queries.
Soft Skills- 20%
- Strong communication skills; both written and verbal
- Ability to develop and present new ideas and conceptualize new approaches and solutions
- Excellent interpersonal relations and demonstrated ability to work with others effectively in teams
- Demonstrated ability to work with functional and technical teams Demonstrated ability to participate in a large teams and work closely with other individual team members
- Proven analytical skills and systematic problem solving
- Strong ability to work under pressure, work with aggressive time lines, and be adaptive to change
- Displays problem solving and analytical skills, using them to resolve technical problems
Public Sector Experience- 5%
- Experience with Siebel modules such as Public Sector CRM, Contracts, Lead, Management, Partner, Public Sector Partner Portal, Campaign Management, Marketing, Resource Manager, and Public Sector eService would be an asset
- Experience with Transfer Payments would be an asset.
Supplier Comments
Closing Date/Time: 2026-05-20, 12:00 p.m. EST
Max submission: 2 (two)
5 days onsite
Must Have:
- 5 +years of experience in data analysis developing business intelligence and reporting in a medium to large size corporate environment demonstrating detailed knowledge of BI functions such as analytics, data modeling \& data mining, reporting, report conversion and data cleansing.
- Experience in Azure Databricks, Delta Lake, Azure Storage, ADF, Azure Analysis Service
- Design and develop BI dashboards and reports based on business requirements
- Implement, maintain, and support BI solutions in Microsoft and other BI platforms
- Experience with cloud platform like Azure and working knowledge for cloud migration
- Experience with Microsoft Azure data analytics tools, such as, Azure Data Factories, Azure Databricks, Azure Synapse
- Advance knowledge of writing complex SQL queries.
- Strong communication skills; both written and verbal
Nice to have:
- Experience with Siebel modules such as Public Sector CRM, Contracts, Lead, Management, Partner, Public Sector Partner Portal, Campaign Management, Marketing, Resource Manager, and Public Sector eService would be an asset
- Experience with Transfer Payments would be an asset.