Data Integration Analyst

3 weeks ago

Ottawa, Canada Canadian Medical Protective Association Full time
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
  • 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 Integration Analyst

    3 weeks ago

    Ottawa, Ontario, Canada Canadian Medical Protective Association Full time

    Position at 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 Integration Analyst

    3 weeks ago

    Ottawa, Canada Canadian Medical Protective Association Full time

    Description 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....

  • Data Analyst

    1 month ago

    Ottawa, Canada Compugen Inc Full time

    **Job Title** - Data Analyst **Vacancy No** - VN6014 **Work Location** - Ottawa, ON **Job Details** - The Data Analyst, reporting to the Specialist, Data Analysis, supports the Microsoft Structure Query Language (SQL) Server database and collects, transforms, and analyses data into convenient data sources. The Data Analyst develops user friendly reports...

  • Climate Data Analyst

    1 month ago

    Ottawa, Canada EDC Full time

    **Climate Data Analyst** - 0004A0 **Posting Date**: Apr 24, 2023, 10:06:56 AM **Primary Location**: Ontario-Ottawa **Job Type**: Permanent **Schedule**: Full-time Export Development Canada (EDC) is a financial Crown corporation dedicated to helping Canadian businesses make an impact at home and abroad. EDC offers financial products and knowledge to help...

  • Data Analyst

    7 days ago

    Ottawa, Canada Hydro Ottawa Full time

    By generating and distributing power, each person at Hydro Ottawa is part of empowering the lives of people in the communities we serve. Our work means all the activities that make up our lives - at home, at work, at play - are there when we need them. That purpose unites us and fuels our work. And if joining us in this essential work energizes you too, we...

  • Data Analyst

    4 weeks ago

    Ottawa, Canada Nanometrics Inc Full time

    **Working Title**: Data Analyst**Reports to**: Science and Development Team Lead, Data Services**Based in**: Ottawa, ON**Term**: Full-time**About Us** - Despite everything we know, the earth still has its mysteries. Beneath the surface, it is ever-changing and there is still much to understand. At Nanometrics, we develop industry leading instrumentation and...

  • Bhjob15656 18556 - Data Analyst

    1 month ago

    Ottawa, Canada Myticas Consulting Full time

    **DATA ANALYST** **Term**: 12 Months + 12 Months **Location**: You will perform work on-site (OTTAWA) as required to meet the objectives of the project. **Project Description**: The college is implementing a new vendor cloud-based Student Information System (SIS) platform with many complex integrations to other internal systems. As part of the SIS project,...

  • Senior Analyst, Data Integration, Methods and Tools

    23 hours ago

    Ottawa, Canada CGI Njoyn Full time

    Job order - J0524-1199 - Permanent Full time Title Senior Analyst, Data Integration, Methods and Tools Category Data Analysis City Ottawa, Toronto, Ontario, Canada Job Description Senior Analyst, Data Integration, Methods and ToolsWho we areWe are an organization comprised of industry thought leaders who are passionate...

  • Senior Analyst, Data Integration, Methods and Tools

    20 hours ago

    Ottawa, Canada CGI Njoyn Full time

    Job order - J0524-1199 - Permanent Full time Title Senior Analyst, Data Integration, Methods and Tools Category Data Analysis City Ottawa, Toronto, Ontario, Canada Job Description Senior Analyst, Data Integration, Methods and ToolsWho we areWe are an organization comprised of industry thought leaders who are passionate...

  • Senior Analyst, Data Integration, Methods and Tools

    21 hours ago

    Ottawa, Canada CGI Njoyn Full time

    Job order - J0524-1199 - Permanent Full time Title Senior Analyst, Data Integration, Methods and Tools Category Data Analysis City Ottawa, Toronto, Ontario, Canada Job Description Senior Analyst, Data Integration, Methods and ToolsWho we areWe are an organization comprised of industry thought leaders who are passionate...

  • Data Analyst

    1 month ago

    Ottawa, Canada Talasoft Full time

     We are seeking a skilled Data Analyst to join our team and contribute to our mission of leveraging data to drive informed decisions and achieve business objectives. If you have a passion for working with data and uncovering valuable insights, we encourage you to apply and be a part of our exciting journey. Responsibilities may encompass, but are not...

  • Data Analyst

    1 month ago

    Ottawa, Canada Talasoft Full time

     We are seeking a skilled Data Analyst to join our team and contribute to our mission of leveraging data to drive informed decisions and achieve business objectives. If you have a passion for working with data and uncovering valuable insights, we encourage you to apply and be a part of our exciting journey. Responsibilities may encompass, but are not...

  • Data Analyst

    1 month ago

    Ottawa, Canada Talasoft Full time

     We are seeking a skilled Data Analyst to join our team and contribute to our mission of leveraging data to drive informed decisions and achieve business objectives. If you have a passion for working with data and uncovering valuable insights, we encourage you to apply and be a part of our exciting journey. Responsibilities may encompass, but are not...

  • Data Analyst

    1 month ago

    Ottawa, Canada World Vision Canada Full time

    Are you looking for more than a job? At World Vision Canada we offer challenging careers that change the lives of children all over the world and it will change yours too. Come and be part of a team of 400 Canadians with a vision for the world: Life in all its fullness for every child. You will experience Christian faith in action helping to make real and...

  • Data Analyst

    4 weeks ago

    Ottawa, Canada TechInsights Full time

    **OUR STORY** **THE OPPORTUNITY** TechInsights is looking for a Data Analyst to work closely with the Architecture and Engineering teams. In this role you will, design and implement structured and unstructured data systems, ETL flows, and Business Intelligence (BI) based dashboards for both internal reporting and end-customer deliverables. As the Data...

  • Data Analyst

    1 month ago

    Ottawa, Canada MSi Corp (Bell Canada) Full time

    **Key Responsibilities**: - Work with business analysts to understand the business requirements - Translate business requirements into technical ETL solutions - Support the current production versions and help investigate issues and identify root causes and get it fixed as soon as possible **Key Competencies and Experience**: - Bachelor's degree in...

  • Data Analyst

    1 week ago

    Ottawa, Canada Hydro Ottawa Full time

    Please Note: If you are a current Hydro Ottawa employee with access to Workday, apply to this job via the Workday application.By generating and distributing power, each person at Hydro Ottawa is part of empowering the lives of people in the communities we serve. Our work means all the activities that make up our lives – at home, at work, at play – are...

  • Data Analyst

    7 days ago

    Ottawa, Canada Hydro Ottawa Full time

    Please Note: If you are a current Hydro Ottawa employee with access to Workday, apply to this job via the Workday application.By generating and distributing power, each person at Hydro Ottawa is part of empowering the lives of people in the communities we serve. Our work means all the activities that make up our lives - at home, at work, at play - are there...

  • Intermediate Data and Security Analyst

    1 month ago

    Ottawa, Canada Englobe Full time

    Your Employer Dare to join Englobe At nearly 3,000 people, Englobe is one of Canada's premier firms specializing in professional engineering services, environmental sciences, and soil and biomass treatment. With offices located across Canada, the United Kingdom and France, we are conveniently located to support large- and small-scale projects, through...