Datawarehouse Application Support

This role supports application systems, data warehouse operations and business initiatives by troubleshooting issues, delivering project work and contributing to system design. The successful candidate will leverage Python, SSIS, SQL and reporting skills to help drive solutions, support testing activities and collaborate across teams to meet business and technical objectives. Client Details Canadian insurance company Description Responsibilities: Assist with troubleshooting application system related issues. Identify solutions to business system problems. Lead or participate in multiple projects by completing and updating project documentation; supporting project deliverables; determining daily priorities; ensuring efficient and on-time delivery of project tasks and milestones; following proper escalation paths; and managing customer and supplier relationships. Create and maintain requirements, issue logs, meeting minutes, meeting schedules, project summaries and updates. Diligently support and lead where needed, various activities between the teams to ensure the business and technical requirements and objectives are met. Participate and contribute to the overall system(s) design. Assist with the creation of test suites and support the team with various tasks and activities. Qualifications: Data Warehouse experience is mandatory. Minimum 1 year of working experience using Python. 2 years working experience using SSIS ETL tool. Proficient in querying Oracle and SQL Server databases. AI Framework and Libraries - good to have. Cloud technologies exposure would be an asset. Excellent oral and written communication skills. Strong documentation, PowerBI and reporting skills. Team player with strong interpersonal skills and ability to take a leadership role when necessary. Problem solving skills. Demonstrated experience with Agile development methodology. Good project management skills and/or substantial exposure to project-based work structures. JIRA experience - good to have. On-Call rotation schedule required for this role. Profile The successful candidate will bring hands-on experience in data warehousing, ETL development and business systems support, with at least one year of Python experience and two years working with SSIS. They will be proficient in querying Oracle and SQL Server databases and possess strong reporting, documentation and PowerBI skills. Exposure to AI frameworks, libraries and cloud technologies will be advantageous. The ideal individual will demonstrate strong problem-solving abilities, effective communication skills and experience working within Agile environments. They will be comfortable managing multiple priorities, contributing to system design, supporting testing activities and collaborating with diverse stakeholders. A proactive team player with project-based experience, leadership potential and strong interpersonal skills will excel in this role. Job Offer * Opportunity to work on data warehouse, ETL and business-critical application systems projects. * Exposure to end-to-end project delivery, including documentation, stakeholder management and solution development. * Ability to contribute to system design discussions and influence technical outcomes. * Broad technical experience across Python, Oracle, SQL Server, PowerBI and Agile delivery environments. * Ongoing learning through cross-functional collaboration, testing initiatives and diverse project responsibilities. MPI does not discriminate on the basis of race, religion, sex, sexual orientation, gender identity or expression, age, disability, marital status, or based on an individual's status in any group or class otherwise protected under applicable human rights legislation. MPI encourages applications from minorities, women, the disabled and all other qualified applicants

The role involves troubleshooting application systems and data warehouse operations while contributing to system design and project deliverables. The candidate will manage project documentation and collaborate across teams to meet business and technical objectives.

Candidates must have mandatory data warehouse experience, at least one year of Python, and two years of SSIS experience. Proficiency in Oracle, SQL Server, and PowerBI, along with experience in Agile environments, is required.

• SQLPreferred
• JiraPreferred
• Project managementPreferred
• PythonPreferred

Identified from the job description. Confirm important requirements above.

• Python
• SSIS
• SQL
• Oracle
• SQL Server
• PowerBI
• Data Warehousing
• ETL Development
• Agile Methodology
• JIRA
• Reporting
• System Design
• Project Management
• Troubleshooting
• Documentation
• Testing

• Data & Analytics
• Technology
• Software
• Customer Service & Support
• Finance & Accounting

Minimum experience

2+ years

Apply by

Aug 18, 2026

Posting language

English

Working hours

40 hours per week

Seniority

Not Applicable