Data Integration Analyst job in Ottawa
Ottawa, Ontario Canadian Medical Protective Association
Job Ref: | ytgQQ7AlyLvT |
Employer: | Canadian Medical Protective Association |
Sector: |
Professional/Financial Services
Risk Management |
Qualifications: | Unclassified |
Software: |
Excel
Oracle Python R SAS SQL VBA |
Job Type: | Full Time |
Salary and Benefits: | $97,900 - $131,000 per year |
Remote: | No |
Location | |
Country: | Canada |
State/Province/County: | Ontario |
City: | Ottawa |
Post Code: | Not specified |
Map: | |
Description | |
Description Position at Canadian Medical Protective Association • DATA INTEGRATION ANALYST CONTRIBUTING TO THE CMPA Actuarial Services supports the CMPA's mission and goals through proper valuation of the Association's liabilities. This is accomplished through detailed actuarial work following the Standards of Practice set by Canadian Institute of Actuaries. The Actuarial Team is mainly responsible for CMPA's liability valuation and protection fee projection. The team develops proprietary applications and data structures, builds actuarial models and processes, supports financial auditing and provides insight for the Association's funds and liability management. 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
Python Report Development
Other Related Tasks
EDUCATION AND EXPERIENCE
SKILLS AND ABILITIES
POSTING DETAILS
The CMPA is an equal opportunity employer and is committed to being responsive to those living with disabilities and strives to prevent and remove barriers to accessibility. The CMPA will provide support and accommodation in its recruitment processes to applicants living with disabilities. If you are invited to participate in an interview and/or skills assessment and have accommodation needs, please let us know. Equity, diversity, and inclusion (EDI) is a key priority, and we actively strive to build a culture of inclusion where employees can be their authentic selves and are valued for their diverse experiences and perspectives. We welcome and encourage candidates from diverse backgrounds and a variety of lived experiences to apply. |
ref: (ytgQQ7AlyLvT) 12 days ago
Back to search results
Featured Jobs
- Group Capital Management Actuary - Bermuda (Star8786) 05/02/2024
- International Life Actuarial Consulting - Bermuda(Star8437) 04/30/2024
- Senior International Life Actuary- Bermuda (Star8754) 04/16/2024
- Pricing Actuary , Excess Casualty New York, NY 01/16/2024
- Lead Pricing Actuary, Specialty Lines New York 01/09/2024
- Non-traditional Actuary – Non Life Insurance - Remote (Star8753) 04/16/2024
- Commercial Reserving Lead (Star8731) London 04/16/2024
- Core Pricing Lead UK (Star8568) 03/01/2024