Jobs
>
Ottawa

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

    Canadian Medical Protective Association
    Canadian Medical Protective Association Ottawa, Canada

    2 weeks ago

    Default job background
    Full time
    Description


    Poste chez 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.
  • Parcs Canada

    Analyste en Intégration de Système

    2 weeks ago

    Parcs Canada Gatineau, Canada

    Parcs Canada - Direction des Politiques stratégiques et planification - Bureau du dirigeant principal de l'information · Gatineau (Québec) · 75 042 $ à $ (Salaire en cours de révision) · Découvrez le Canada en vous joignant à Parcs Canada Page Web de Parcs Canada · **Date limite ...

  • Canadian Medical Protective Association

    Data Integration Analyst

    3 weeks ago

    Canadian Medical Protective Association Ottawa, Canada

    **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 o ...

  • Parcs Canada

    Analyste en Intégration de Système

    4 days ago

    Parcs Canada Gatineau, Canada

    Parcs Canada - Direction des Politiques stratégiques et planification - Bureau du dirigeant principal de l'information · Gatineau (Québec) · Terme de 2 ans, Affectation Intérimaire, Affectation à niveau, Échange Canada · 82 625 $ à $ · Pour obtenir plus de renseignements sur l'or ...

  • Parks Canada

    System Integration Analyst

    2 weeks ago

    Parks Canada Gatineau, Canada

    Parks Canada - Strategic Policy and Planning Directorate - Office of the Chief Information Officer · Gatineau (Québec) · $75,042 to $91,868 (Salary under review) · Experience Canada by joining Parks Canada Parks Canada Website · **Closing date: 11 April :59, Pacific Time** · **Im ...

  • Canadian Air Transport Security Authority

    Analyst, Learning Systems and Data Integrity

    2 weeks ago

    Canadian Air Transport Security Authority Ottawa, Canada

    The Canadian Air Transport Security Authority (CATSA) has 1 (one) exciting fixed-term opportunity within the Operations branch at the CATSA HQ. · This position represents an opportunity for career-driven individuals seeking a position within an organization that inspires growth a ...

  • Canadian Air Transport Security Authority

    Analyst, Learning Systems and Data Integrity

    3 weeks ago

    Canadian Air Transport Security Authority Ottawa, Canada

    The Canadian Air Transport Security Authority (CATSA) has 1 (one) exciting fixed-term opportunity within the Operations branch at the CATSA HQ. · This position represents an opportunity for career-driven individuals seeking a position within an organization that inspires growth a ...

  • Parks Canada

    System Integration Analyst

    4 days ago

    Parks Canada Gatineau, Canada

    Parks Canada - Strategic Policy and Planning Directorate - Office of the Chief Information Officer · Gatineau (Québec) · Term of 2 years, Acting, Assignment, Interchange · $82,625 to $101,150 · For further information on the organization, please visit Parks Canada · **Closing dat ...

  • Mississippi River Health Alliance

    Integrated Financial Analyst

    1 week ago

    Mississippi River Health Alliance Almonte, Canada Full time

    The Finance Department has an opening for a **Full-Time Integrated Financial Analyst**. Reporting to the Integrated Controller, the incumbent is responsible for providing monthly financial reporting for the Mississippi River Health Alliance (MRHA) - Carleton Place & District Memo ...

  • Canadian Medical Protective Association

    Data Integration Analyst

    2 weeks ago

    Canadian Medical Protective Association Ottawa, Canada 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 wo ...

  • Employment and Social Development Canada

    System Integration Analyst

    3 days ago

    Employment and Social Development Canada Gatineau, Canada

    Reference number: CAP24J · Selection process number: 2024-CAP-SPP-EA · Parks Canada- Strategic Policy and Planning Directorate - Office of the Chief Information Officer · Gatineau(Québec) · CS-02, IT-02- As a separate agency, Parks Canada has its own classification system and C ...

  • Treasury Board of Canada Secretariat

    System Integration Analyst

    2 days ago

    Treasury Board of Canada Secretariat Gatineau, Canada

    System Integration Analyst · Reference number: CAP24J · Selection process number: 2024-CAP-SPP-EA Parks Canada - Strategic Policy and Planning Directorate - Office of the Chief Information Officer · Gatineau (Québec) · CS-02, IT-02 - As a separate agency, Parks Canada has its ...

  • CGI Njoyn

    Senior Analyst, Data Integration, Methods and Tools

    2 days ago

    CGI Njoyn Ottawa, ON, Canada

    Job order - J 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 Tools · Who we are · We are an organization co ...

  • Bank of Canada

    Analyste de L'automatisation en Environnement

    3 weeks ago

    Bank of Canada Ottawa, Canada

    **Analyste de l'automatisation en environnement assurance qualité** · **Tenez un rôle central** · La Banque du Canada s'est donnée comme vision d'être une banque centrale influente - dynamique, engagée et digne de confiance - mobilisée pour un Canada meilleur. Aucun autre employe ...

  • NAV Canada

    Analyste D'affaires Principal(E)

    1 week ago

    NAV Canada Ottawa, Canada

    Titre de l'offre d'emploi · Analyste d'affaires principal(e) · Catégorie d'emploi · Analyse du système · Exigence linguistique · English / Anglais · Type d'horaire de travail flexible · Date de fin de recrutement · Niveau · CS-4 · Échelle salariale · $114,846 - $141,381 · Sommair ...

  • Canada Post - Postes Canada

    Analyste, Systèmes

    1 week ago

    Canada Post - Postes Canada Ottawa, Canada

    Numéro de la demande d'emploi : 163814 · Fonction administrative : Ingénierie · Ville principale : Ottawa · Province : Ontario · Type d'emploi : Temps plein · Statut d'emploi : Permanent · Exigences linguistiques : Anglais essentiel · Classification et niveau d'employé : UPCET02 ...

  • Bank of Canada

    Analyste Des Contrôles de Sécurité

    2 weeks ago

    Bank of Canada Ottawa, Canada

    **Analyste des contrôles de sécurité** · **Tenez un rôle central** · La Banque du Canada s'est donnée comme vision d'être une banque centrale influente - dynamique, engagée et digne de confiance - mobilisée pour un Canada meilleur. Aucun autre employeur ne vous offrira l'occasion ...

  • healthcarecan

    Business Systems Analyst

    2 weeks ago

    healthcarecan Ottawa, Canada

    **Business Systems Analyst**: · **Job Purpose**: · CHA Learning, the professional development division of HealthCareCAN, is looking for a dynamic Business Systems Analyst to join our passionate and high-performing learning team and support our business intelligence needs and the ...

  • Bank of Canada

    Analyste Chargé de La Mise à L'essai Des

    1 week ago

    Bank of Canada Ottawa, Canada

    **Analyste chargé de la mise à l'essai des systèmes en environnement assurance qualité** · **Tenez un rôle central** · La Banque du Canada s'est donnée comme vision d'être une banque centrale influente - dynamique, engagée et digne de confiance - mobilisée pour un Canada meilleur ...

  • Canadian Security Intelligence Service

    Analyste Principal Du Renseignement

    2 weeks ago

    Canadian Security Intelligence Service Ottawa, Canada

    **Important**: · Il est important de ne pas discuter de votre demande d'emploi (y compris dans les médias sociaux), sauf à votre conjoint ou aux membres de votre famille proche. De plus, veuillez leur rappeler la nécessité de demeurer discret à l'égard de votre démarche d'emploi. ...

  • BluWave-ai

    Business Analyst, Program Partnerships

    1 week ago

    BluWave-ai Ottawa, Canada

    BluWave-ai is seeking a Business Analyst to join our team and play a critical role in the success of our intelligent EV charging projects. The Business Analyst will be responsible for coordinating and seeking out business partnerships with customer loyalty programs to incentivize ...