BI-Techical Lead

  • 37657
  • Non-Life - Data Science
  • |
  • Ontario, Canada
  • |
  • Jun 30, 2020
Insurance
RESPONSIBILITIES
  • 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 management and Project Management as required.
  • Ensure technical documentation is produced for ease of transferring skills and knowledge.
  • Recognize and work with Management to define areas of improvement, define change and process to implement Best Practices for testing.
  • Coach and mentor BI 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.
QUALIFICATIONS
  • 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, and/or Hewlett Packard QTP.
  • Knowledge of Infrastructure technologies.
  • ISTQB Certification.
  • 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.