Job Description: Database Administrator

Position Overview:

We are seeking a highly skilled and experienced Database Administrator (DBA) to join our dynamic IT team. The ideal candidate will have extensive knowledge and hands-on experience with Oracle Databases (12c and 19c), as well as proficiency in other database systems such as PostgreSQL or MongoDB. Knowledge of AWS is a plus. The DBA will be responsible for database application support, troubleshooting, patching, performance tuning, and query optimization. Additionally, expertise in Oracle Enterprise Manager is essential.

Key Responsibilities:

• Database Management:
  • Install, configure, and maintain Oracle Databases (12c and 19c).
  • Manage database instances, including creation, configuration, and monitoring.
  • Ensure high availability, disaster recovery, and data integrity.
• Database Application Support:
  • Provide support for database applications, ensuring optimal performance and reliability.
  • Collaborate with development teams to design and implement database solutions.
  • Troubleshoot and resolve database-related issues promptly.
• Performance Tuning:
  • Perform system and query tuning to optimize database performance.
  • Analyze and resolve performance bottlenecks.
  • Implement best practices for database performance and scalability.
• Patching and Upgrades:
  • Apply patches and perform upgrades to database systems.
  • Ensure compliance with security policies and standards.
  • Plan and execute database migrations and version upgrades.
• Monitoring and Maintenance:
  • Utilize Oracle Enterprise Manager for database monitoring and management.
  • Conduct regular health checks and performance assessments.
  • Automate routine maintenance tasks to improve efficiency.
• Cross-Platform Database Support:
  • Provide support for additional database systems such as PostgreSQL or MongoDB.
  • Ensure seamless integration and interoperability between different database platforms.
  • Maintain documentation and standard operating procedures for multi-database environments.
• AWS Knowledge (Preferred):
  • Leverage AWS services for database hosting and management.
  • Implement cloud-based database solutions and ensure their optimal performance.
  • Stay updated with the latest AWS offerings and best practices.

Qualifications:

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• 5 to 7 years of proven experience as a Database Administrator with a focus on Oracle Databases (12c and 19c).
• Proficiency in Oracle Enterprise Manager.
• Working knowledge of PostgreSQL or MongoDB.
• Familiarity with AWS services is a plus.
• Strong analytical and problem-solving skills.
• Excellent communication and teamwork abilities.
• Ability to work in a fast-paced, dynamic environment.

Preferred Skills:

• Certification in Oracle Database Administration.
• Experience with database security and compliance.
• Knowledge of scripting languages (e.g., Python, Shell scripting) for automation.
• Familiarity with DevOps practices and tools.

Perform assigned responsibilities, collaborate with team members, and adhere to company policies. Strong communication, problem-solving, and work ethic required. Adaptability, initiative, and willingness to learn are valued.

Perform assigned responsibilities, collaborate with team members, and adhere to company policies. Strong communication, problem-solving, and work ethic required. Adaptability, initiative, and willingness to learn are valued.

We have a fantastic opportunity for an Agile Delivery Specialist to join the IT team. Change delivery uses the most appropriate delivery model, including Agile Scrum, Kanban, and XP, with both formal and informal scaling approaches for large and/or complex change. Agile and DevOps are core to our operational strategy, with strong alignment to Systems Thinking and other modern, adaptive, and team-centric approaches to delivery and operations.

The Agile Delivery Specialist role supports the adoption and adherence to these approaches, developing and continuously improving Agile capability and maturity within the team. The primary purpose of the Agile Delivery Specialist is to ensure teams drive change delivery effectively, with a focus on quality, innovation, and value optimization aligned with Agile values and principles.

This is a facilitative servant leadership role. The Agile Delivery Specialist promotes self-organization within the team and drives increasing levels of software engineering maturity, such as DevOps. They work to clear the path for the team, remove blockers, facilitate discussions, enable seamless communication, and collaborate with the Technology Platform Lead and Product Owner to clarify the Product Backlog.

Duties & Responsibilities

• Guide the Team: Foster adherence to Agile values and principles, applying appropriate frameworks and techniques to create an environment of self-organization.
• Teach and Coach: Provide Agile theory and software engineering technique coaching for the team and organization.
• Support Product Owners: Assist Product Owners, particularly in refining and maintaining a product backlog.
• Enhance Communication: Facilitate internal and external communication, improving transparency, and sharing information on team activities.
• Collect and Communicate Metrics: Gather necessary metrics and propose new ones to support continuous improvement.
• Drive Quality Across Change Delivery: Optimize change across the technology platform, ensuring quality throughout the delivery lifecycle and minimizing defects.
• Perform Capability Gap Analysis: Conduct a gap analysis for overall technology platform capabilities and tools, developing a roadmap for improvement.
• Support Value Stream Mapping: Collaborate with Agile Delivery Lead on value stream mapping efforts.

Skills & Experience Required

• Agile Knowledge: Strong understanding of Agile values, principles, and a range of Agile frameworks.
• Industry Knowledge: Familiarity with the insurance business is an asset.
• Stakeholder Management: Effective communication skills and an ability to inspire change within individuals and teams.
• Technical Proficiency: Knowledge of Agile techniques and software development processes, such as Test Automation, Continuous Integration, Pairing, DevOps, Refactoring, ATDD/TDD/BDD, Extreme Programming (XP), and Value Stream Mapping.
• Self-Motivation: Demonstrated ability to learn and explore new ideas independently.

Qualifications

• Professional Certification (minimum PSM1 or equivalent).

Job Description: Test Architect / Lead Software Development Engineer in Test (SDET)

Location: Markham (3 days in office, flexible for 1 day in Toronto)

Start Date: Early January

Employment Type: Contract (12 Months)

Position Overview

We are seeking an experienced and visionary Test Architect / Lead SDET to join our dynamic team. This role is instrumental in driving the modernization of testing practices, embedding quality into the software development lifecycle, and fostering a culture of excellence. You will lead by example, mentoring developers and testers, and championing cutting-edge testing strategies that align with our mission to deliver reliable, scalable, and innovative digital applications.

Key Responsibilities

Modernizing Testing Practices

• Lead the transition from external test automation to engineering-embedded testing practices.
• Integrate testing into CI/CD pipelines to enable iterative, fast, and reliable releases.
• Advocate for rapid feedback and experimentation by shifting testing practices to smaller, incremental stages.

Engineering-Focused Testing

• Collaborate with developers to write scalable and maintainable unit tests.
• Coach developers on writing testable, high-quality code.
• Partner with testers to enhance alternative testing strategies and improve code testability.

Test Framework and Tool Selection

• Evaluate current tools like Selenium and assess modern alternatives such as Playwright or Cypress.
• Define and implement best practices for integration and UI testing while minimizing reliance on UI tests.
• Build robust testing frameworks using Java (SpringBoot) and TypeScript (Angular Framework).

Leadership and Coaching

• Influence and shape the testing strategies across digital engineering teams.
• Mentor developers and testers on automation, test-driven development (TDD), and modern testing methodologies.
• Establish a roadmap for sustainable, forward-thinking testing practices in a product-centric delivery model.

Collaboration and Stakeholder Engagement

• Collaborate with engineering leads to design scalable test architectures.
• Align integration testing strategies with teams working on backend systems like Guidewire.
• Serve as a thought leader, providing strategic guidance on testing practices to technical and business stakeholders.

Qualifications

Technical Expertise

• Strong expertise in test automation frameworks and tools, including Selenium, Playwright, Cypress, and Appium.
• Proficient in programming languages such as Java (SpringBoot) and TypeScript (Angular Framework).
• Deep understanding of CI/CD pipelines and embedding tests within development workflows.
• Hands-on experience writing scalable and reliable unit and integration tests.

Leadership and Vision

• Proven experience in designing and implementing modern test practices.
• Ability to coach cross-functional teams, including developers and testers, in adopting best practices.
• Strong capability to define test strategies, set roadmaps, and lead organizational change in testing methodologies.

Collaboration and Communication

• Exceptional communication skills with the ability to collaborate with cross-functional teams and influence stakeholders.
• Experience working with engineering leads and technical teams to align on testing goals.

Experience

• At least 8-10 years in test automation and test architecture, with a focus on digital applications.
• Experience in enterprise-level organizations; exposure to industries like telecom or insurance is a plus.

Preferred Skills

• Familiarity with performance and load testing tools (e.g., JMeter, LoadRunner).
• Experience with declarative CI/CD pipelines (e.g., Azure DevOps, GitLab CI).
• Knowledge of cloud platforms (e.g., AWS, Azure) and containerization tools (e.g., Docker, Kubernetes).

Why Join Us?

• Opportunity to work in a hybrid environment with flexibility across locations.
• Lead and shape the testing architecture of cutting-edge digital products.
• Collaborate with a passionate and skilled engineering team dedicated to innovation.
• Competitive compensation and professional growth opportunities.

Application Process

• Submit your resume and cover letter highlighting relevant experience and leadership achievements.
• Interview Rounds:
  1. Hiring Manager Interview.
  2. Technical Team Interview.

Let’s innovate and redefine testing practices together! Apply today to be part of our transformative journey.

Job Title: Guidewire ClaimCenter Developer

We are seeking a collaborative and skilled Technical Lead – Guidewire ClaimCenter. As a key part of the Software Engineering Group, you will work closely with globally distributed teams, including business representatives, analysts, architects, and engineers, to plan, design, develop, test, and implement solutions. Our team thrives in a culture that challenges the status quo, constantly seeking ways to simplify processes, technology, and workflows.

In this role, you will lead the design and implementation of Guidewire ClaimCenter solutions, driving our claims transformation agenda. You’ll play a vital role in enhancing claims processing efficiency, reducing costs, and improving customer satisfaction.

This position reports to the AVP of Software Engineering.

Key Responsibilities

• Develop architectural diagrams and design documents.
• Write, configure, package, and deploy software applications.
• Perform peer code reviews and ensure adherence to best practices.
• Collaborate with business stakeholders to translate requirements into technical solutions.
• Design and implement ClaimCenter configurations and integrations with external systems.
• Provide technical guidance and mentorship, fostering a culture of continuous improvement.
• Oversee technical aspects of ClaimCenter upgrades and patches.
• Troubleshoot and resolve complex technical issues promptly.
• Monitor system performance and recommend enhancements.

Required Qualifications

• Bachelor’s degree (or higher) in Computer Science, Computer Engineering, or a related field, or equivalent experience.
• 5+ years of experience in Guidewire ClaimCenter application development.
• Expertise in GOSU language, Guidewire tools, Guidewire Batch, and predefined plugins.
• Ability to read code in various languages and reverse-engineer products.
• Proficiency in Agile software development tools, including Git, Bitbucket, Jenkins, Jira, and Confluence.
• Domain knowledge in Property & Casualty Insurance.
• Guidewire Cloud Associate Certification required.
• 5+ years of Guidewire development experience.
• 5+ years of experience with RESTful API coding.
• 5+ years of experience coding in multiple programming languages such as C#, Java, and Python.
• 5+ years of experience with relational databases and SQL, with a preference for MS SQL Server & Transact SQL proficiency.
• Expertise in end-to-end design and development of business database applications.
• Experience in creating modern web applications and designing Web APIs with REST/JSON.
• Strong understanding of design thinking and customer-centric development.

This role offers the opportunity to make a significant impact on claims processing efficiency and customer satisfaction through innovative Guidewire ClaimCenter solutions.

Job Description: Finance Systems - Data Engineer Associate

Location: Markham, ON

Work Mode: Hybrid (3 days onsite)

Job Type: Contract

Eligibility: Canadian Citizen, PR Holder, or Valid Canadian Work Permit

Overview

We are seeking a skilled Finance Systems - Data Engineer Associate to design, develop, and optimize ETL processes for our finance systems. The ideal candidate will have strong expertise in PostgreSQL, ETL development (Informatica), and experience in the insurance industry, particularly with Guidewire systems. The role requires a collaborative mindset and an ability to ensure data accuracy and integrity across finance and insurance operations.

Top Required Skills:

1. Strong expertise in PostgreSQL and database design, particularly for finance systems.
2. Proven ETL development experience with Informatica PowerCenter and BDM.
3. Experience with Guidewire Policy, Billing, and Claims Centers.

Key Responsibilities

1. ETL Development & Optimization:
   • Design, develop, and maintain ETL processes to extract, transform, and load data into finance systems.
   • Optimize complex SQL queries and stored procedures in PostgreSQL.
   • Monitor daily/monthly ETL jobs and resolve failures.
2. Collaboration:
   • Work with finance and insurance teams to gather data requirements and ensure data accuracy.
   • Collaborate with teams using Guidewire applications to meet data requirements and maintain system integrity.
3. Financial Reporting & Analysis:
   • Build Qlik reports and implement financial calculations using PostgreSQL stored procedures or ETL tools.
   • Perform data analysis and troubleshooting for data-related issues.
   • Create financial reports and execute calculations in Corporate Reporting Engine (CRE) and Accounting Engine (AE).
4. Data Management & Quality Assurance:
   • Implement data quality checks and validation processes.
   • Monitor and improve the performance of ETL processes and database systems.
   • Maintain comprehensive documentation for technical specifications, ETL processes, and database schemas.
5. Guidewire Data Integration:
   • Extract and integrate data from Guidewire BillingCenter, PolicyCenter, and ClaimsCenter for financial reporting and analysis.
   • Utilize Guidewire data for tracking receivables, revenue recognition, and claims reserves.
6. Technology Leadership:
   • Stay updated with industry trends and best practices in ETL, data warehousing, and database management.
   • Leverage automation tools like Control-M and ASG Zena to streamline processes.

Requirements

1. Technical Skills:
   • Expertise in PostgreSQL development and database design.
   • Proficiency in ETL tools, particularly Informatica PowerCenter and Informatica BDM.
   • Knowledge of Oracle Fusion applications, including Accounts Payable, Cash Management, and Fixed Assets.
   • Experience with Guidewire PolicyCenter, BillingCenter, and ClaimsCenter.
   • Familiarity with automation tools (e.g., Control-M, ASG Zena) and Unix scripting.
   • Experience in data visualization tools like Qlik and Python reporting.
   • Familiarity with Snowflake and cloud-based data solutions.
2. Industry Experience:
   • Background in the insurance industry with knowledge of underwriting data terminology.
   • Experience supporting finance systems and understanding accounting principles (e.g., Balance Sheet, P&L).
3. Methodologies & Tools:
   • Agile methodology and JIRA experience.
   • Solid understanding of data warehousing concepts and best practices.
4. Soft Skills:
   • Excellent problem-solving skills and attention to detail.
   • Strong communication and collaboration abilities.
   • Capability to work independently and in team environments.

Preferred Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Certifications in Informatica (ICP, IDMC, CDCG, MDM) and SQL (Associate level).
• Guidewire professional certifications.
• Familiarity with Power BI for data visualization.

We encourage you to apply if you meet the requirements and want to contribute to a dynamic finance and insurance environment.

Job description

Job Title: IT QA - GW Automation Tester

Job Overview:

We are seeking a collaborative, inquisitive, and dedicated Automation Test Engineer to join our team. The ideal candidate will play a key role in crafting and improving automation frameworks, tools, and quality engineering processes. You will be responsible for contributing to technology, productivity, and operational efficiency improvements, as well as ensuring high-quality standards and IT controls are met.

Key Responsibilities:

• Design and improve automation frameworks, tools, and QE delivery processes.
• Lead initiatives to enhance technology, productivity, and operational efficiency.
• Review user stories, requirements, and technical design documents to provide timely feedback and recommendations from a Quality Assurance perspective.
• Create comprehensive test strategies, test plans, and estimates. Lead test execution and provide status updates to project teams.
• Build and maintain risk-based automation regression test suites and application component breakdown diagrams.
• Coordinate and ensure all quality engineering and documentation meet established QE standards and IT controls.
• Create and deliver test artifact communications, collaborating effectively with both technical and non-technical teams.
• Provide mentoring and training to junior team members.
• Ensure all deliverables meet quality requirements and timelines.

Skills and Experience:

Must have:

• Extensive experience with GuideWire PolicyCenter, BillingCenter, Documents, and Digital Applications.
• Current GuideWire Certification.
• 5+ years of hands-on experience in software automation testing, with 3+ years in API automation and manual testing.
• Strong expertise in Web Automation Testing using Selenium (Java/Python/C/C++) and framework development.
• Experience with API Automation Testing using XML/JSON, SOAP API, REST API, Java, and API framework development.
• Proficient with GIT/Bitbucket for source code management and CI/CD pipelines.
• Experience with JIRA integration and a solid understanding of SQL.
• Experience in the Canadian Personal and/or Commercial Insurance industry.
• Excellent verbal and written communication skills, with the ability to describe complex processes clearly.
• Strong problem-solving skills, capable of managing issues from start to resolution.
• Team player, contributing to a positive team culture.

Nice to have:

• Experience with Digital Test Automation, Cross Browser, Mobile, and Localization.
• Familiarity with Cucumber for automation.
• Previous development experience is an asset.

Qualifications:

• Bachelor's degree in Computer Science, Computer Engineering, or IT.
• 5+ years of experience in Software Development and/or Quality Assurance.
• Test Engineering Certification (e.g., ISTQB Certified) is required

Job Title: Senior Data Systems Analyst

Location: Markham, ON

Work Mode: Hybrid (2 days in Markham, 1 day in Downtown Toronto)

Employment Type: Contract

Eligibility: Canadian Citizen, Permanent Resident, or valid Canadian Work Permit

Job Summary:

We are seeking a skilled and collaborative Senior Data Systems Analyst to join our Information Technology – Enterprise Data Services Delivery team. In this role, you will be responsible for scaling the data and analytics capabilities, acting as a liaison between various business units and technical data teams. You will bring your expertise in requirements gathering, data analysis, documentation, and road mapping to contribute to the data transformation initiatives, helping the organization build and enhance its data infrastructure to support its growing business needs.

Key Responsibilities:

• Data Requirements and Documentation:
  • Collaborate with business and IT teams to define, document, and develop data requirements that align with the organization’s goals and industry standards.
  • Work with stakeholders to capture and document system requirements, define the scope and create specifications that guide system development and implementation.
• Data Analysis & Solutions Design:
  • Review, analyze, and evaluate user needs to develop solutions that align with business strategies.
  • Provide detailed technical input on how to design data systems that address business needs, ensuring they are scalable, efficient, and adaptable.
• Development & Testing Support:
  • Assist development teams by supporting testing and resolution of data and financial issues, managing Business-as-Usual (BAU) defects, and driving enhancements.
  • Participate in the development, unit testing, and maintenance of business-critical applications to ensure their effectiveness and performance.
• Cross-functional Collaboration:
  • Act as a liaison between IT and business users, ensuring clear communication and alignment on system requirements, design, and scope.
  • Engage with stakeholders to identify and address any technical challenges or business needs.
• Research and Development (R&D):
  • Participate in R&D to introduce effective software development methodologies and best practices aimed at controlling costs and delivering data solutions on time and within budget.
  • Contribute to driving innovation in data practices and processes.
• Data Governance & Quality:
  • Advocate and promote data governance practices, ensuring data quality and integrity throughout its lifecycle.
  • Support data cataloging, metadata management, and other data management practices to ensure data is properly governed and managed.
• Project Participation & Stakeholder Management:
  • Participate in special projects and ad hoc analyses as required by the organization.
  • Ensure stakeholder management is maintained through proactive communication, meeting organizational and project deadlines.

Required Skills & Qualifications:

• Educational Background:
  • Bachelor’s degree in Computer Engineering, Computer Science, or a related technical field.
• Experience:
  • Minimum 5 years of experience in Data Systems Analysis within an enterprise environment, with experience in building and maintaining large-scale data assets.
  • 8+ years of experience as a Business Analyst with a focus on data systems design, development, and implementation, particularly with mid-to-large scale enterprise data projects.
• Technical Proficiency:
  • Solid experience with data technologies and tools, such as Snowflake, Hadoop, PostgreSQL, Informatica and similar platforms.
  • Strong knowledge of SQL and experience writing complex queries for data analysis, integration, and troubleshooting.
• Documentation & Standards:
  • Proven experience in establishing documentation standards and frameworks for data quality, governance, metadata management, and data stewardship.
• Analytical & Problem-Solving Skills:
  • Strong critical thinking, analytical, and problem-solving abilities, with an aptitude for understanding complex business processes and translating them into technical solutions.
• Communication & Collaboration:
  • Excellent written and verbal communication skills, with the ability to effectively communicate with both technical teams and business stakeholders.
  • Strong collaboration skills, able to work across teams to define and implement data solutions.
• Industry Knowledge (Optional):
  • Experience with Guidewire Suites is a plus.
  • Knowledge of the insurance industry is an asset, but not mandatory.

Perform assigned responsibilities, collaborate with team members, and adhere to company policies. Strong communication, problem-solving, and work ethic required. Adaptability, initiative, and willingness to learn are valued.