ETL / Data Warehouse/ BI – Technical Test Lead

Northbridge Financial Corporation - Toronto, ON (30+ days ago)

Apply Now

“The Power of Together”

Join Northbridge, a growing dynamic company that has a long and rich Canadian history in providing innovative insurance solutions to customers nationwide.

Northbridge Financial Corporation is a leading commercial property and casualty insurance company that’s been helping protect Canadian businesses for more than 90 years. We’re 100% Canadian!

We offer a wide range of creative solutions to our customers through our Northbridge Insurance, TruShield Insurance and Federated Insurance brands where we strive to create a fair and friendly culture, upheld by the foundation of our five corporate values: respect, passion, connectedness, creativity, and excellence.

By continually striving to challenge the status quo, and by focusing on helping the customers we have the privilege of insuring achieve the possibilities of their business, we’ve been able to build our reputation as one of Canada’s largest commercial insurance providers.

To help us continue to build on this success, we’re committed to attracting, developing and retaining the best people.

Be part of a team that’s passionate about making a difference every day, fuelled by our entrepreneurial spirit and where everyone owns a part of our success. Our company has had an amazing journey so far, and our future is full of new possibilities!

Located in the heart of Toronto’s Financial District, our head office is easily accessible by TTC and GO Transit, and within walking distance to the Eaton Centre, Scotiabank Arena, Rogers Centre, and CN Tower. As a national property and casualty commercial insurance provider, we also have offices across Canada.

Position Summary

The Testing Business Intelligence Leader defines the Testing strategy for the Business Intelligence Corporate team and systems. The Leader will determine the tools and techniques for delivering the Business Intelligence Testing strategy and champions the Business Intelligence testing team with innovative solutions to support the business community.

What you will be doing:
Ensure accuracy and completeness of BI system changes and enhancements by establishing test strategies with emphasis on mitigating risk and delivering according to plan
Manage BI testing including Functional testing, Data Validation, Regression testing, System integration testing, Automated testing and User acceptance testing
Identify, champion and develop opportunities for automated and re-useable testing process
Interface with business analysts, business stakeholders, IT, Data Architects and others to understand the business requirements
Analyze requirement specifications, technical system design documents, data models to build clear and detailed test plans, estimates and resource plans
Develop trending reports, data quality metrics and strategy for continuous monitoring of data quality
Develop benchmarks for testing data and provide metrics reporting
Assist the user community with troubleshooting and problem resolution for issues, ensure impact of issues/defects are understood, evaluated and communicated
Identify and escalate risk/issues to QA management and Project Management as required
Ensure technical documentation is produced for ease of transferring skills and knowledge
Recognize and work with QA Management to define areas of improvement, define change and process to implement Best Practices for testing
Coach and mentor BI QA team members in future development and growth
Foster collaboration between teams and within team members
Perform peer reviews quality checks as needed and requested
Coordinate project team activities and assist members in achieving objectives as necessary
Other duties as assigned

What we are looking for:.

Post-Secondary education and/or equivalent job experience
Minimum 10 Years of Quality Assurance testing experience within P&C insurance industry
5+ years leading BI QA team
Minimum of 5 years experience in Data Warehouse
Hands-on experience with Microsoft SSIS, Microstrategy Reporting Tools, DB SQL Server and DB2, and Webfocus Report Tool
Strong communication and collaboration skills
Ability to coach and develop teams
Experienced with Onshore/Offshore delivery model and leading onshore and offshore team
Full understanding and compliance to SDLC and Agile methodologies
Expert knowledge of Data Warehouse, relational databases, SQL, designing advanced SQL statements and data models
Experience in Big Data, Data Lake
IFRS 9/IFRS 17 testing experience
Intermediate SAS experience
SAS IFRS tool experience
Expert knowledge and experience with Selenium, C#, Java, Jmeter, automation tools, test automation
Experience working in Cloud environments
Experience with Test Data Management, Test Data Creation and Data subset
Knowledge of QA applications, Team Foundation Server (TFS), and/or Hewlett Packard QTP
Knowledge of Infrastructure (servers, network, security) technologies
ISTQB Certification

What sets you apart:
Ability to develop, document and implement a BI strategy in line with the overall business requirements.
Strategic influencing skills.
Strong leadership skills that inspire team confidence and respect while motivating team members in a creative and effective manner.
Strong analytical and problem solving skills, including the ability to understand and critique business questions.
Well-developed project management skills including project planning, estimation and release management.
Excellent communications skills including the ability to prepare and present reports to a range of audiences.
Fosters a partnership attitude across the IT organization
Communicates openly and transparently
Strong interpersonal skills.

What We Have to Offer:
Northbridge Cares program – volunteer day and donation matching
Generous paid time off, including personal days. Flexible work hours as well as early departure opportunities
Flexible Group Benefits Plan – medical, dental, insurances
Defined Contribution Pension Plan + Optional Group RRSP
Northbridge Employee Share Purchase Plan
Education Assistance Program
Employee Assistance plan
Staff Insurance - discount on home, automobile and pet insurance
Plus, the opportunity to contribute to the success of Northbridge through sharing your knowledge and experience while learning from others!

Application Process:
Northbridge welcomes and encourages applications from people with disabilities. Accommodations are available upon request for candidates taking part in all aspects of the selection process. Interested, qualified candidates are encouraged to apply.

All offers of employment are conditional upon satisfactory background and reference checks, including a criminal record check, credit check, and employment and educational verifications.