Data Integration Analyst

5 months ago

Ottawa, Canada Canadian Medical Protective Association Full time

**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 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 _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 end-user 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 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 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

**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
- 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
- Locat

  • Data Analyst

    5 months ago

    Ottawa, Canada CAA North & East Ontario Full time

    **Job Title: Data Analyst** **Location: HYBRID: Work-From-Home / 1031 Bank St, Ottawa, ON** **Job Summary**: The Data Analyst plays a pivotal role in facilitating data-driven decision-making across the organization by collecting, analyzing, and interpreting complex datasets. They possess a keen analytical mindset, a knack for problem-solving, and a passion...

  • Data Analyst

    5 months ago

    Ottawa, Canada CAA North & East Ontario Full time

    **CAA North & East Ontario's success depends on great people. If you are ready for the challenge, find your job here.**: CAA North & East Ontario offers a wide range of career opportunities in our Head Office / Administration Center (Finance, IT, Marketing etc); our award winning Call Centers; Emergency Roadside Assistance and our full service CAA Stores. We...

  • Data Analyst

    4 weeks ago

    Ottawa, Ontario, Canada SEAMS DATA Full time

    At SEAMS DATA, we are seeking a skilled Database Specialist to join our team. As a key member of our data team, you will be responsible for designing and developing databases, operating database management systems to analyze data, and developing and implementing data administration policy, standards, and models.The ideal candidate will have a strong...

  • Systems Analyst

    5 months ago

    Ottawa, Canada NTT DATA Full time

    We are currently seeking a Systems Analyst to join our team in Canada. Location: Remote Language: Bilingual (English/French) Security: Reliability **How You'll Help Us**: We are looking for a Systems Analyst with 5 years experience. You will work collaboratively with stakeholders to identify improvements and design systems to implement those and...

  • Data Analyst

    6 months ago

    Ottawa, Canada Canadian Wildlife Federation Full time

    **_Your Connection to Wildlife_**: - As one of Canada’s largest not for profit leaders in wildlife conservation, research, and advocacy, we are seeking to fill the following position _ **Data Analyst** **Who we are**: The Canadian Wildlife Federation (CWF) is a national not-for-profit charitable organization dedicated to ensuring an appreciation of our...

  • Energy & Sustainability Data Analyst Ii

    5 months ago

    Ottawa, Canada BGIS Full time

    **SUMMARY** The Energy & Sustainability Data Analyst II is responsible for compiling and managing client data on GHG reduction initiatives and other defined Sustainability objectives as required. The Analyst is responsible for data reporting, insight development, recommendations to improve data quality and implementation of these as required. Communicating...

  • Statistical Data Analyst

    5 months ago

    Ottawa, Canada Canadian Medical Protective Association Full time

    **STATISTICAL **DATA ANALYST**. SAFE MEDICAL CARE RESERACH** **CONTRIBUTING TO THE CMPA** The Safe Medical Care Research (SMC-R) department performs acquisition, abstraction, and capture of clinically oriented medical legal data. The department analyzes and interprets the data to generate knowledge that supports the activities of Safe Medical Care. The...

  • Database Analysts and Data Administrators

    5 months ago

    Ottawa, Canada Studyincanada Full time

    Database Analysts and Data AdministratorsDatabase analysts design, develop, and administer data management solutions using database management software. Data administrators develop and implement data administration policy, standards, and models.Duties May IncludeCollect and document user requirementsDesign and develop database architecture for information...

  • Business Analyst

    6 months ago

    Ottawa, Canada NTT DATA Full time

    We are currently seeking a **Business Analyst (Bilingual) **to join our team **REMOTE** in the** Canada (EST work hours).** - Lead and conduct business analysis to assess client's business problems/opportunities and documents the business requirements in such a way that technology solutions can be determined. - Assist with the development of strategies and...

  • Data Analyst

    5 months ago

    Ottawa, Canada Qlik Full time

    **What makes us Qlik?** Qlik delivers the best in data, analytics, and AI technology, to help enterprises around the world drive value from their data. Our leading, AI-powered platform enables users to uncover insights that lead to better business decisions, faster. A Gartner® Magic Quadrant Leader for 13 years in a row, Qlik is a values-driven...

  • Senior Data Analyst

    4 weeks ago

    Ottawa, Ontario, Canada Assent Full time

    Job Title: Senior Data AnalystJob Summary:We are seeking a highly skilled Senior Data Analyst to join our team at Assent. As a Senior Data Analyst, you will play a pivotal role in advancing data capabilities to drive growth in our B2B SaaS business. You will lead efforts to streamline data processes, develop robust models and dashboards, and deliver...

  • Business Process Improvement Analyst

    7 days ago

    Ottawa, Ontario, Canada NTT DATA Full time

    About the RoleWe are seeking an experienced Senior Business Analyst to join our team in Canada. The successful candidate will have a strong background in business analysis, process improvement, and project management.Key ResponsibilitiesDevelop and maintain operational processes for information creation, storage, access, management, sharing, and...

  • Business Data Analyst

    5 months ago

    Ottawa, Canada CAA North & East Ontario Full time

    **Job Title: Business Data Analyst** **Location: HYBRID: Work-From-Home / 1031 Bank St, Ottawa, ON** **Job Summary**: Responsibilities include gathering and processing data from various sources while ensuring its accuracy and integrity. Experience in data visualization tools like PowerBI is essential. From scheduled reports to ad hoc presentations,...

  • Data Analyst

    1 month ago

    Ottawa, Ontario, Canada Geofirma Engineering Ltd Full time

    Job Title: Data AnalystWe are seeking a highly skilled Data Analyst to join our team at Geofirma Engineering Ltd. As a Data Analyst, you will be responsible for conducting studies of groundwater flow and contamination, developing models and applied software for the analysis and interpretation of data, and working with a team of experts to provide innovative...

  • Data Insights Analyst

    1 month ago

    Ottawa, Ontario, Canada ECF Data, LLC Full time

    Data Analysis SpecialistWe are seeking a highly skilled Data Analysis Specialist to join our team at ECF Data, LLC. As a key member of our data management team, you will be responsible for collecting, analyzing, and interpreting complex data sets to inform business decisions.Key Responsibilities:Develop and implement data collection systems, databases, and...

  • Data Analyst

    3 weeks ago

    Ottawa, Canada Canadian Cancer Society Full time

    **Job Title**: Data Analyst **Work Model**: Hybrid Work Model **Salary Band**: 4 ($52,000 - $75,000 CAD) **WHY JOIN THE CANADIAN CANCER SOCIETY (CCS)?** The Canadian Cancer Society works tirelessly to save and improve lives. We raise funds to fuel the brightest minds in cancer research. We provide a compassionate support system for all those affected by...

  • Business Intelligence Analyst Lead

    7 days ago

    Ottawa, Ontario, Canada ECF Data, LLC Full time

    About ECF Data, LLCWe are a dynamic and innovative company seeking a skilled Business Intelligence Analyst Lead to join our team. The ideal candidate will have expertise in data collection and analysis, with the ability to develop and implement databases, data collection systems, and data analytics strategies.

  • Business Data Analyst

    6 months ago

    Ottawa, Canada CAA North & East Ontario Full time

    **CAA North & East Ontario's success depends on great people. If you are ready for the challenge, find your job here.**: CAA North & East Ontario offers a wide range of career opportunities in our Head Office / Administration Center (Finance, IT, Marketing etc); our award winning Call Centers; Emergency Roadside Assistance and our full service CAA Stores. We...

  • Data Management Specialist

    1 month ago

    Ottawa, Ontario, Canada Data Sentinel Full time

    About YouWe are seeking a highly skilled and experienced Data Management Specialist to join our team at Data Sentinel. As a key member of our delivery team, you will be responsible for working with our clients on deployments and solutions with our technology.ResponsibilitiesResponsible for the successful installation, configuration, and deployment of Data...

  • Data Quality Analyst

    1 month ago

    Ottawa, Ontario, Canada CMHC Full time

    About the RoleCMHC is seeking a highly skilled Data Quality Analyst to join the Enterprise Data Office. In this role, you will be responsible for supporting data quality initiatives by executing routine tasks, assisting with data profiling, and contributing to the development and maintenance of data quality rules and monitoring.Key ResponsibilitiesSupport...