Current jobs related to Data Integration Analyst - Ottawa, Ontario - Canadian Medical Protective Association
-
Senior Data Integration Developer
2 weeks ago
Ottawa, Ontario, Canada Nexus Systems Group Inc. Full timeAbout the RoleWe are seeking a highly skilled Senior Data Integration Developer to join our team at Nexus Systems Group Inc. as a key member of our Data Integration team.Key Responsibilities:Design, develop, and implement complex data transformations using various data programming languages such as Python and Pyspark.Collaborate with cross-functional teams...
-
Senior Data Integration Developer
2 weeks ago
Ottawa, Ontario, Canada Nexus Systems Group Inc. Full timeAbout the RoleWe are seeking a highly skilled Senior Data Integration Developer to join our team at Nexus Systems Group Inc. as a key member of our Data Integration team.Key Responsibilities:Design, develop, and implement complex data transformations using various data programming languages such as Python and Pyspark.Collaborate with cross-functional teams...
-
Enterprise Data Deployment Specialist
2 weeks ago
Ottawa, Ontario, Canada Data Sentinel Full timeAbout the RoleWe are seeking a highly skilled Data Management Solutions Architect to join our team at Data Sentinel. As a key member of our delivery team, you will be responsible for working with our clients to deploy and implement our sensitive information intelligence platform.Key ResponsibilitiesInstall, configure, and deploy Data Sentinel for each of our...
-
Enterprise Data Deployment Specialist
2 weeks ago
Ottawa, Ontario, Canada Data Sentinel Full timeAbout the RoleWe are seeking a highly skilled Data Management Solutions Architect to join our team at Data Sentinel. As a key member of our delivery team, you will be responsible for working with our clients to deploy and implement our sensitive information intelligence platform.Key ResponsibilitiesInstall, configure, and deploy Data Sentinel for each of our...
-
Data Management Solutions Architect
2 weeks ago
Ottawa, Ontario, Canada Data Sentinel Full timeAbout the RoleWe are seeking a highly skilled Data Management Solutions Architect to join our team at Data Sentinel. As a key member of our delivery team, you will be responsible for working with our clients to deploy and implement our sensitive information intelligence platform.Key ResponsibilitiesDeployment and Configuration: Responsible for the successful...
-
Data Management Solutions Architect
2 weeks ago
Ottawa, Ontario, Canada Data Sentinel Full timeAbout the RoleWe are seeking a highly skilled Data Management Solutions Architect to join our team at Data Sentinel. As a key member of our delivery team, you will be responsible for working with our clients to deploy and implement our sensitive information intelligence platform.Key ResponsibilitiesDeployment and Configuration: Responsible for the successful...
-
Data Integration Expert
2 weeks ago
Ottawa, Ontario, Canada Emtec Full timeJob SummaryEmtec is seeking a highly skilled Integration Specialist to join our team. As an Integration Specialist, you will be responsible for implementing BMC-ITSM projects and ensuring seamless data integration across various systems.Key ResponsibilitiesDevelop data integration objects and data processing flows using current tools and software.Act as the...
-
Data Integration Expert
2 weeks ago
Ottawa, Ontario, Canada Emtec Full timeJob SummaryEmtec is seeking a highly skilled Integration Specialist to join our team. As an Integration Specialist, you will be responsible for implementing BMC-ITSM projects and ensuring seamless data integration across various systems.Key ResponsibilitiesDevelop data integration objects and data processing flows using current tools and software.Act as the...
-
Cloud-Based Data Governance Expert
2 weeks ago
Ottawa, Ontario, Canada Data Sentinel Full timeAbout the RoleWe are seeking a highly skilled Data Management Solutions Architect to join our team at Data Sentinel. As a key member of our delivery team, you will be responsible for working with our clients to deploy and implement our sensitive information intelligence platform.Key ResponsibilitiesDeployment and Configuration: Responsible for the successful...
-
Cloud-Based Data Governance Expert
2 weeks ago
Ottawa, Ontario, Canada Data Sentinel Full timeAbout the RoleWe are seeking a highly skilled Data Management Solutions Architect to join our team at Data Sentinel. As a key member of our delivery team, you will be responsible for working with our clients to deploy and implement our sensitive information intelligence platform.Key ResponsibilitiesDeployment and Configuration: Responsible for the successful...
-
Data Systems Analyst
1 month ago
Ottawa, Ontario, Canada Telesat Full timeTelesat stands as a prominent global satellite operator, delivering dependable and secure satellite-based communication solutions across the globe. We are seeking a System Analyst to enhance our operations.Key Responsibilities:Engage in the planning and execution of data-centric initiativesGather and evaluate business and system requirementsContribute to the...
-
Business Data Analyst
1 week ago
Ottawa, Ontario, Canada the Ladders Full timeAbout The LaddersThe Ladders is a leading job search platform that connects top talent with top companies. As a Business Data Analyst, you will be part of a team that drives business growth and innovation.Job SummaryWe are seeking a highly motivated and detail-oriented Business Data Analyst to join our team. As a Business Data Analyst, you will be...
-
Business Data Analyst
1 week ago
Ottawa, Ontario, Canada the Ladders Full timeAbout The LaddersThe Ladders is a leading job search platform that connects top talent with top companies. As a Business Data Analyst, you will be part of a team that drives business growth and innovation.Job SummaryWe are seeking a highly motivated and detail-oriented Business Data Analyst to join our team. As a Business Data Analyst, you will be...
-
Data Systems Analyst
1 month ago
Ottawa, Ontario, Canada Telesat Full timeTelesat stands as a prominent global satellite operator, delivering dependable and secure satellite-based communication solutions across the globe. We are in search of a System Analyst to enhance our operations.Key Responsibilities:Engage in the planning and execution of data-centric initiativesGather and assess business and system requirementsContribute to...
-
Data Systems Analyst
1 month ago
Ottawa, Ontario, Canada Telesat Full timeTelesat stands as a prominent global satellite operator, delivering dependable and secure satellite-based communication solutions across the globe. We are in search of a System Analyst to enhance our operations.Key Responsibilities:Engage in the planning and execution of data-centric initiativesGather and evaluate business and system specificationsContribute...
-
Senior Healthcare Data Analyst
4 weeks ago
Ottawa, Ontario, Canada Canadian Institute for Health Information Full timeAbout the Role As a Senior Data Analyst, you will play a crucial role in leveraging healthcare data to drive insights and inform strategic decision-making within the Canadian Institute for Health Information (CIHI). You will contribute to a variety of projects focused on analyzing primary healthcare data, uncovering trends, and identifying areas for...
-
Data Systems Analyst
1 month ago
Ottawa, Ontario, Canada Telesat Full timeTelesat is a leading global satellite operator, renowned for delivering dependable and secure communication solutions for over five decades. With a commitment to engineering excellence and exceptional customer service, Telesat operates from its headquarters in Ottawa, Canada, and maintains a presence worldwide.Telesat Lightspeed represents a groundbreaking...
-
Data Science Professional
2 weeks ago
Ottawa, Ontario, Canada ECF Data, LLC Full timeAbout the RoleWe are seeking a highly skilled and experienced Data Collection/Analytical Specialist to join our team at ECF Data, LLC. As a key member of our organization, you will be responsible for gathering, cleaning, and analyzing data to provide actionable insights that drive business growth.Key ResponsibilitiesInterpret complex data sets, analyze...
-
Data Science Professional
2 weeks ago
Ottawa, Ontario, Canada ECF Data, LLC Full timeAbout the RoleWe are seeking a highly skilled and experienced Data Collection/Analytical Specialist to join our team at ECF Data, LLC. As a key member of our organization, you will be responsible for gathering, cleaning, and analyzing data to provide actionable insights that drive business growth.Key ResponsibilitiesInterpret complex data sets, analyze...
-
Digital Earth Data Analyst
2 weeks ago
Ottawa, Ontario, Canada University of Ottawa Full timeJob SummaryThe University of Ottawa is seeking a highly skilled Geospatial Data Specialist to join our team. As a key member of our faculty, you will be responsible for teaching and researching in the field of geospatial data analysis.Key ResponsibilitiesTeach and develop courses in geospatial data analysis, including vector, raster, and satellite...
Data Integration Analyst
4 months ago
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
- 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
- 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
- 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
- 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
- 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
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.
