Data Integration Analyst - Ottawa, Canada - Canadian Medical Protective Association

Canadian Medical Protective Association

Verified Company

Ottawa, Canada

1 week ago

Posted by:

Sophia Lee

beBee Recruiter

Description

DATA INTEGRATION ANALYST

CONTRIBUTING TO THE CMPA

POSITION OVERVIEW

Reporting to the Senior Data Architect II, the Data Integration Analyst is responsible for developing and implementing ETL processing, reporting, integrations, and visualizations at all stages of Actuarial Services' workflows and dataflows for source data used in actuarial modelling, model data used in forecasting, and forecast data used in valuation of liabilities and fee setting.

The Actuarial Services Systems Team oversees the infrastructure supporting valuation and fee setting.

As a key member of the team, the incumbent supports the maintenance of a data mart providing historical, current, and predictive views of legal case and membership operations.

Additionally, the Analyst provides support to the actuarial staff with report development and distribution, complex custom ad-hoc information requests, data modelling infrastructure, and supports analytic needs as required.

The Data Integration Analyst is part of a small (three-member) Actuarial Services Systems Team and has a high degree of individual autonomy and responsibility, nonetheless, working collaboratively and coordinating all activities with the rest of the team.

POSITION ACTIVITIES

PL/SQL ETL Development_
Develops and maintains Oracle database packages integrating ETL processing into Excel, SAS, R, and Python
Python Report Development_
Develops and maintains numerous, complex, and highly varied Excel reports using Python, python‐oracledb and XlsxWriter
Develops and maintains complex and dynamic Excel VBA macros with a thirdparty API to access model and forecast data
Develops and maintains complex Excel reports accessing integrated database queries to keep refreshed with current data
Develops and maintains complex Word integrations autorefreshing data via Excel file links to ensure data is current
Other Related _T_asks_
Works closely with the Actuarial Services Systems Team on various tasks, such as quality assurance, building regression tests, designing and implementing testing plans, ensuring products satisfy requirements and meet enduser expectations, etc.
Provides timely and quality assistance to the Senior Data Architect II to fulfil the Actuarial team's responsibilities
Provides knowledge sharing and user training on systems and reporting capabilities both within and outside of Actuarial Services
Troubleshoots and fixes reportingrelated issues as they arise
Creates and maintains comprehensive and robust procedure documents, scope and requirements documents, user manuals, and other information
Maintains uptodate knowledge on technology standards, industry trends, emerging technologies, and best practices

EDUCATION AND EXPERIENCE

Minimum 4year bachelor's degree with a specialization in Computer Science or an equivalent field of study
Minimum of 7 years of relevant work experience, including a minimum of 3 years of experience developing reports and ETL programming utilizing PL/SQL, SQL, Python.

NET (C# or VB) or similar toolsets

Demonstrated experience with Structured Query Language (SQL) required
Demonstrated experience with PL/SQL (Oracle) required
Experience developing with Python including python‐oracledb and XlsxWriter libraries
Experience developing and delivering successful Business Intelligence solutions
Experience working with databases, coding, internal systems, and programming
Experience writing documentation and guides
Certified Associate in Python Programming is an asset
Oracle Database PL/SQL Developer Certified Professional Certification is an asset
Microsoft Office Specialist: Expert certification is an asset
Sound understanding of data architecture is an asset
Understanding of data relational database architectures is an asset
Understanding of data warehousing methodologies is an asset
Understanding of business processes (Finance, Customer Relationship Management (CRM), Risk Management, and Corporate Performance Measurement) is an asset
Understanding of actuarial data modelling is an asset
Experience working in crossfunctional teams in a projectbased environment is an asset

SKILLS AND ABILITIES

Ability to work independently and within a team environment and can prioritize workload
Ability to adapt well to change, meet tight deadlines, and perform well under pressure
Strong analytic and critical thinking skills
Keen sense of ownership and selfaccountability
Ability to focus on details and perform functions with accuracy
Strong Excel skills including data automation using SQL queries and/or macros
Strong verbal and written communication skills (in English)
Ability to handle confidential information with discretion and diplomacy
Ability to use sound judgement and act in a professional manner

POSTING DETAILS