Data Integration Analyst

3 weeks ago

Ottawa, Ontario, Canada Canadian Medical Protective Association Full time


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
  • Develops and maintains Oracle database packages providing distributed computing management of compute intensive ETL applications using Oracle Advanced Queuing (AQ) and Direct Path Load
  • 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
  • Integrates Python Excel reports with a Web Services application for shared access
  • Develops and maintains complex and dynamic Excel VBA macros with a third-party 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 auto-refreshing data via Excel file links to ensure data is current
Other Related Tasks
  • 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 end-user expectations, etc.
  • Provides timely and quality assistance to the Senior Data Architect II to fulfil the Actuarial team's responsibilities
  • Assists the Senior Systems Analyst with web application development
  • Provides knowledge sharing and user training on systems and reporting capabilities both within and outside of Actuarial Services
  • Troubleshoots and fixes reporting-related issues as they arise
  • Creates and maintains comprehensive and robust procedure documents, scope and requirements documents, user manuals, and other information
  • Maintains up-to-date knowledge on technology standards, industry trends, emerging technologies, and best practices
EDUCATION AND EXPERIENCE
  • Minimum 4-year 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 developing ETL applications
  • 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 cross-functional teams in a project-based environment is an asset
  • Experience with distributed computing applications 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 self-accountability
  • Ability to focus on details and perform functions with accuracy
  • Advanced computer skills with the ability to learn new applications quickly
  • 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
  • Job Type: regular full-time opportunity
  • Salary Range: $97,900 to $131,000 - this role is classified as level 09
  • Skills Assessment: selected candidates may be required to complete a skills assessment
  • Location: Fully Remote - working from a home-based office anywhere in the provinces of Ontario and Québec
  • Application Deadline: Monday, May 27, 2024 at 4:00PM EST
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.

  • Data Integration Analyst

    3 weeks ago

    Ottawa, Ontario, Canada Canadian Medical Protective Association Full time

    Poste chez Canadian Medical Protective Association • DATA INTEGRATION ANALYSTCONTRIBUTING TO THE CMPAActuarial 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...

  • Data and Reporting Analyst

    3 weeks ago

    Ottawa, Ontario, Canada Carleton University Full time

    Duties and Responsibilities: Reporting to the Manager, Strategy and Quality, the Data and Reporting Analyst serves as an administrative resource on all matters pertaining to data collection and reporting for the Sprott School of Business. The Data and Reporting Analyst is the subject expert on comparative analyses and reporting and assists the Manager,...

  • Geophysicist/data Analyst

    1 month ago

    Ottawa, Ontario, Canada Sander geophysics (SGL) Full time

    Geophysicist/Data AnalystDepartment Geophysics and CartographyReports to Geophysics and Cartography ManagerSupervisory Responsibilities NoneLocation Ottawa office and field project locations worldwideSander Geophysics is currently seeking early career geophysicists to join the growing team to work at the head office location in Ottawa, Ontario, Canada, and...

  • Senior Quality Analyst

    3 weeks ago

    Ottawa, Ontario, Canada Adecco Canada Full time

    Adecco is currently recruiting for a Quality Analyst for a 12-Month contract with a possibility of extension of 24 months with our Crown Corporation Client in Ottawa, ON. This position is remote for the duration of the contract. The successful candidate must hold a valid Reliability Security Clearance or be eligible for it.The QA Specialist will have the...

  • Agricultural Statistical Analyst

    2 weeks ago

    Ottawa, Ontario, Canada Ag Jobs Canada Full time

    Egg Farmers of Canada is presently seeking an Agricultural Statistical Analyst to join our Agricultural Policy and Costing team. Reporting to the Manager of Agricultural Policy & Costing, the primary responsibilities of the role include conducting accurate, comprehensive, and timely analysis of data pertaining to the Canadian egg industry. This position is...

  • Agricultural Statistical Analyst

    2 weeks ago

    Ottawa, Ontario, Canada Egg Farmers of Canada Full time

    Salary: Egg Farmers of Canada is presently seeking an Agricultural Statistical Analyst to join our Agricultural Policy and Costing team. Reporting to the Manager of Agricultural Policy & Costing, the primary responsibilities of the role include conducting accurate, comprehensive, and timely analysis of data pertaining to the Canadian egg industry. This...

  • Financial Analyst

    1 week ago

    Ottawa, Ontario, Canada Taggart Group of companies Full time

    Job Title: Financial Analyst - Asset ManagementReporting to: Director, Asset ManagementCompany: Taggart Realty ManagementLocation: 225 Metcalfe Street, Suite 708, Ottawa, OntarioPart of the Taggart Group of Companies, Taggart Realty Management specializes in acquiring, developing, and managing residential, office, and commercial properties. With a steady...

  • IT- Business Analyst- FULL TIME

    4 weeks ago

    Ottawa, Ontario, Canada Adecco Canada Full time

    Business System Analyst Adecco is currently recruiting for a Business System Analyst for a 3-year Hybrid contract opportunity. This role is with our Crown corporation client in downtown Ottawa, ON.The Business System Analyst will have the following responsibilities: Perform technical and functional requirement analysis; Support workflows and fully qualified...

  • Business System Analyst

    1 month ago

    Ottawa, Ontario, Canada Adecco Canada Full time

    Business System AnalystAdecco is currently recruiting for a Business System Analyst for a 3-year Hybrid contract opportunity. This role is with our Crown corporation client in downtown Ottawa, ON. The successful candidate must hold a valid Secret Security Clearance.The Business System Analyst will have the following responsibilities: Perform technical and...

  • Business System Analyst

    4 weeks ago

    Ottawa, Ontario, Canada Adecco Canada Full time

    Business System Analyst Adecco is currently recruiting for a Business System Analyst for a 3-year Hybrid contract opportunity. This role is with our Crown corporation client in downtown Ottawa, ON. The successful candidate must hold a valid Secret Security Clearance . The Business System Analyst will have the following responsibilities: Perform...

  • Analyst, FP&A

    3 weeks ago

    Ottawa, Ontario, Canada Ciena Full time

    Ciena is committed to our people-first philosophy. Our teams enjoy a culture focused on prioritizing a personalized and flexible work environment that empowers an individual's passions, growth, wellbeing and belonging. We're a technology company that leads with our humanity—driving our business priorities alongside meaningful social, community, and...

  • Payroll Analyst

    2 weeks ago

    Ottawa, Ontario, Canada Alterna Full time

    Scope of Position The Payroll Analyst is primarily responsible for assisting in the accurate processing of payroll and transmittal to the payroll provider within established deadlines. This also includes the maintenance of the staff self-service function and responding to staff inquiries in a timely and professional manner. The Payroll Analyst is also...

  • Enterprise Integration Developer Intern

    1 month ago

    Ottawa, Ontario, Canada Ciena Full time

    Ciena is committed to our people-first philosophy. Our teams enjoy a culture focused on prioritizing a personalized and flexible work environment that empowers an individual's passions, growth, wellbeing and belonging. We're a technology company that leads with our humanity—driving our business priorities alongside meaningful social, community, and...

  • Senior Strategic Analyst

    1 week ago

    Ottawa, Ontario, Canada National Research Council Canada Full time

    Priority will be given to the following designated employment equity groups: women, Indigenous peoples* (First Nations, Inuit and Métis), persons with disabilities and racialized persons*. The Employment Equity Act, which is under review, uses the terminology Aboriginal peoples and visible minorities. Candidates are asked to self-declare when applying to...

  • Senior Strategic Analyst

    2 weeks ago

    Ottawa, Ontario, Canada National Research Council Canada Full time

    Priority will be given to the following designated employment equity groups: women, Indigenous peoples* (First Nations, Inuit and Métis), persons with disabilities and racialized persons*. The Employment Equity Act, which is under review, uses the terminology Aboriginal peoples and visible minorities. Candidates are asked to self-declare when applying to...

  • Financial Analyst III

    5 days ago

    Ottawa, Ontario, Canada Thermo Fisher Scientific Full time

    Job DescriptionAt Thermo Fisher Scientific, our Finance teams are essential to our business and functional teams to make educated, sound decisions that drive our Mission and make us a stable and trusted industry leader. From Financial Planning & Analysis, Tax, Treasury, Financial Reporting, Audit, Investor Relations, Strategy & Corporate Development to...

  • 2024-015 - Business Analyst BOC

    4 days ago

    Ottawa, Ontario, Canada Adecco Canada Full time

    Adecco is currently recruiting for a Business Analyst for a 1-year contract with our Crown Corporation Client in Ottawa, ON. This contract has a possibility of extension for up to 2 years. This position is remote for the duration of the contract. The successful candidate must hold a valid Reliability Security Clearance or be eligible for it.The Business...

  • Business Analyst Level 3

    2 weeks ago

    Ottawa, Ontario, Canada Randstad Canada Full time

    Are you an experienced Business Analyst adept at working with business, functional and technical leads within a large organization? Can you facilitate working sessions and conduct interviews, to gather information for data clean-up and migration purposes, across a department?If so, our Ottawa-based public sector client has an 11-month contract opportunity,...

  • Financial Analyst

    2 weeks ago

    Ottawa, Ontario, Canada Abbott Laboratories Full time

    About AbbottAbbott is a global healthcare leader, creating breakthrough science to improve people's health. We're always looking towards the future, anticipating changes in medical science and technology. Working at Abbott At Abbott, you can do work that matters, grow, and learn, care for yourself and family, be your true self and live a full life. You will...

  • Data Specialist

    2 weeks ago

    Ottawa, Ontario, Canada Canadian Medical Association Full time

    Unit | Department: Advocacy Engagement & Governance l Membership Reports to: Advisor, Member Services and Support, Membership Type: Full-Time l Permanent Location Options: Ottawa, Ontario (Hybrid) or Toronto, Ontario (Hybrid) or Ontario, Canada (Remote) or Quebec, Canada (Remote) What makes you a great fit for this role? You are a data specialist prepared...