Data Integration Specialist

1 month ago


North York, Canada Ministry of Health Full time

The Corporate I+IT Solutions & Integration Management division is looking for a Data Integration Specialist with a track record delivering system and data interfacing strategies, standards and technology deployments. We are looking for someone who is business-focused and who has experience working with stakeholders in complex on-premise and on-cloud environments to define and realize business value through IT system and data integration.

**About Us**
The Health Services I&IT Cluster provides information management and information technology solutions that enable and support the business requirements of the Ministry of Health and the Ministry of Long-Term Care and its agents. The cluster supports the Ontario government's I&IT Strategy and plays a leadership role in major business transformation initiatives and infrastructure projects that are currently underway. The cluster is also working to promote the evolution towards a common IT infrastructure for government.

**Why work for the Ontario Public Service?**
The Ontario Public Service (OPS) is committed to being an employer of first choice, creating a positive and inclusive work environment. We welcome new ideas and new people, encourage learning and development, and reward achievement. We offer challenging work and competitive pay and benefits.

**OPS Commitment to Diversity, Inclusion, Accessibility, and Anti-Racism**: We are committed to build a workforce that reflects the communities we serve and to promote a diverse, anti-racist, inclusive, accessible, merit-based, respectful and equitable workplace.

Visit the
**OPS Anti-Racism Policy** and the
**OPS Diversity and Inclusion Blueprint** pages to learn more about the OPS commitment to advance racial equity, accessibility, diversity, and inclusion in the public service.

We offer employment accommodation across the recruitment process and all aspects of employment consistent with the requirements of Ontario's
**Human Rights Code**. Refer to the "How to apply" section if you require a disability-related accommodation.

**What can I expect to do in this role?**: In this role, you will:

- provide expertise and strategic advice in the development of interface and ETL designs, data models, interoperability protocols and integration technology plans, with a focus on Business Intelligence and Business Analytics (BIBA) solutions;
- develop system use case/process models to enable BIBA solutions interoperability, data integrity and sound system integration testing;
- develop proposals for the data management component of ministry information management plans, providing guidelines and information architecture, while supporting operational requirements, data quality, business strategies and the development of data standards; and
- Hands-on development and delivery of data engineering/ETL solutions pertaining to BIBA solutions.

**How do I qualify?**:
**Technical Knowledge and Expertise**:

- You have experience working with business analysis methods, techniques and related tools to provide business analysis for clients in the Business Intelligence & Business Analytics domain.
- You have knowledge of data engineering and information management methodologies, data quality management, and related tools and techniques.
- You have experience in data warehousing concepts and practices.
- You have knowledge of data modeling techniques and tools (such as PowerDesigner) and solid understanding of various database design concepts (conceptual/logical/physical design, data types, data integrity, data dictionaries etc.).
- You have experience working with relational databases (such as Oracle) and programming/scripting languages (such as SQL, PL/SQL, Python, Linux shell) and APIs.
- You have experience processing (reading, transforming, storing, and retrieving) data in various formats (e.g. csv, xlsx, json, xml).

**Analytical and Problem-Solving Skills**:

- You can review and analyze data integration and standards issues/concerns/initiatives
- You can research and analyze data requirements such as integrity issues and develop recommendations
- You can analyze and develop proposals for data management component
- You can evaluate data architecture
- You can maximize capabilities of available technology integration and advise on acquisition of software

**Project Management Skills**:

- You have knowledge of project management and agile methodologies, procurement policies and practices.
- You can develop business strategies, business cases, cost-benefit analysis, and feasibility studies for business driven I&IT initiatives.

**Communication Skills**:

- You can prepare technical reports, briefing notes, presentations, issue reports on database management policies, and the acquisition of additional resources.

**Additional Information**:
**Address**:

- 2 Permanent, 5700 Yonge St, North York, Toronto Region

**Compensation Group**:

- Ontario Public Service Employees Union- Understanding the job ad - definitions**Schedule**:



  • North York, Canada Apotex Inc. Full time

    **About Apotex Inc.** Apotex Inc. is a Canadian-based global health company that produces high-quality, affordable medicines for patients around the world. Apotex employs almost 7,200 people worldwide in manufacturing, R&D, and commercial operations. Apotex medicines are accessible to patients in more than 75 countries globally. Through vertical...


  • North York, Canada Apotex Full time

    About Apotex Inc. Apotex Inc. is a Canadian-based global health company that produces high-quality, affordable medicines for patients around the world. Apotex employs almost 7,200 people worldwide in manufacturing, R&D, and commercial operations. Apotex medicines are accessible to patients in more than 75 countries globally. Through vertical...

  • Specialist Unify Data

    7 hours ago


    North York, Canada Enbridge Full time

    Posting End Date: May 29, 2023 Employee Type: Temporary (Fixed Term)-Full time Union/Non: This is a non-union position This is a temporary fixed term 18-month assignment. What you will do: - Lead planning and communication of the data work during each Unify phase.- Lead onboarding of the System Integration during the Mobilization phase- As a Specialist...


  • North York, Canada ARZ Fine Foods Full time

    Job Summary: ARZ Fine Foods is the Essence of Mediterranean Gourmet; we are purveyors of exotic Middle Eastern and Mediterranean cuisine. Come join us in our artistry while we keep pace with the rapid growth of Toronto as a World Class city by providing authentic Middle Eastern and Mediterranean produce, groceries, deli, fresh and frozen prepared foods and...


  • North York, Canada ARZ Fine Foods Full time

    Job Summary: ARZ Fine Foods is the Essence of Mediterranean Gourmet; we are purveyors of exotic Middle Eastern and Mediterranean cuisine. Come join us in our artistry while we keep pace with the rapid growth of Toronto as a World Class city by providing authentic Middle Eastern and Mediterranean produce, groceries, deli, fresh and frozen prepared foods and...


  • North York, Canada THE EMPIRE LIFE INS. CO Full time

    **Sales Enablement & Data Research Specialist**: **Location: Hybrid - Kingston or Greater Toronto Area** Empire life is looking to hire a Sales Enablement & Data Research Specialist to join our Retail Distribution team! **Why pursue this opportunity** - **The role - **this is a new position and your chance to join a growing team, while being provided the...

  • IT Specialist, ERP

    1 month ago


    North York, Canada ABC Technologies Full time

    **Job Summary**: The ERP (Enterprise Resource Planning) Specialist, is responsible for the day-to-day managing, optimizing, and supporting the ERP system used across the organization. This role will ensure the effective utilization, optimization, and support of the ERP system within the company. By managing system implementation, configuration, data...


  • North York, Canada StoreForce Solutions Full time

    **ABOUT STOREFORCE** StoreForce is deeply passionate about Specialty Retail - it’s in our roots and part of every single line of code we write. We’re known to say we’re Retailers first, and a technology vendor second. Every day we strive to help Specialty Retailers set a new standard for operational excellence. The StoreForce Team is dynamic, made of...


  • North Bay, Canada Ontario Northland Full time

    **POSITION**: Asset Integrity and Productivity Specialist **REPORTS TO**: Manager of Asset Management **DEPARTMENT**: Finance **LOCATION**: North Bay **REFERENCE**: 800-66-25 **SALARY**: $80,730 - $94,990 **WHO WE ARE**: Ontario Northland Transportation Commission (ONTC) is an Agency of the Province of Ontario that provides efficient and vital...


  • North York, Canada Canadian Down & Feather Company Inc. Full time

    **Performance Marketing Specialist** Canadian Down & Feather Company is looking for a Performance Marketing Specialist to develop, execute, and optimize all programmatic media campaigns. Canadian Down & Feather Company is a Canadian manufacturer of down, feather, and down alternative bedding products. We are a digital-first company that endeavors to...

  • Data Analyst Iii

    1 month ago


    North York, Canada Enbridge Contingent Talent Community Full time

    1 Year Contract - Pay Rate: $50 - $65.71/hr - Onsite: 500 Consumers Rd, North York, ON, M2J 1P8 At Enbridge, our goal is to be the first-choice energy delivery company in North America and beyond—for customers, communities, investors, regulators and policymakers, and employees. To meet that goal, Enbridge is partnering with Raise—a leading recruitment...

  • IT Specialist

    1 month ago


    North York, Canada Reflex Integrated INC Full time

    **IT Specialist -Surveys and Onboarding** Reflex Integrated Inc. is a leading Canadian based IT service provider. We provide end to end IT solutions to support existing and growing business needs for clients across North America. We are a dynamic and rapidly growing company that is looking for a skilled IT Specialist -Surveys and Onboarding to join our...


  • Ahuntsic North, Canada Calian Group Full time

    Position Summary: Calian is currently looking for multiple Integrated Logistics Support Specialists to support the Asset Visibility Initiative required by the Canadian Special Operations Forces Command (CANSOFCOM).Responsibilities: Provide technical assistance and subject matter expertise on local national material and management within DND, including...

  • Logistic Specialist

    1 month ago


    North York, Canada Topair Industry Co., Ltd Full time

    Job title: Logistic Specialist / Supply control coordinator (NOC 13201) - Terms of employment: Permanent & Full time Position - Location: #4M, 4773 Yonge St, North York, ON, M2N 0G2 - Start date: As soon as possible **Job Overview**: **Key Duties and Responsibilities**: - Responsible for monitoring and tracking shipments - Responsible for the review,...


  • North York, Canada Randstad Canada Remote Work Freelance Full time

    This is a contract position for a Data Analytical Specialist/Scientist - Junior for our public sector client.Work location: 315 Front St., TorontoDuration: Nine Months7.25 hours/dayThis is a Hybrid role that requires the candidate to be onsite 3 days of the week (This is a mandatory requirement of the role and is non-negotiable outside of exceptional...


  • North York, Canada Randstad Canada Remote Work Freelance Full time

    This is a contract position for a Data Analytical Specialist/Scientist - Junior for our public sector client.Work location: 315 Front St., TorontoDuration: Nine Months7.25 hours/dayThis is a Hybrid role that requires the candidate to be onsite 3 days of the week (This is a mandatory requirement of the role and is non-negotiable outside of exceptional...

  • Data Analyst

    1 month ago


    North York, Canada Raise Full time

    **Job Duties**: - Support planning and communication of the data work during each Unify phase - Support onboarding of the System Integrator during the Mobilization phase - May be required to communicate technical topics to a non-technical audience - Accountable to ensure execution of data readiness scope and deliverables to meet program timelines - Leverage...

  • Accounting Specialist

    3 weeks ago


    North York, Canada Pantos Logistics Canada Inc. Full time

    Pantos Logistics Canada is currently hiring 4 Accounting Specialists: **Key Details**: - **Location**: 5255 Yonge St., North York, ON, M2N 5P8 - **Working hours**: 08:30-05:30 (8 hours) - **Salary Range**: $45k-$55k (Based on education and experience) - **Language**: English and Korean (Bilingual) Preferred - **Employee Benefits**: Health& Dental Insurance/...

  • Accounting Specialist

    2 weeks ago


    North York, Canada Pantos Logistics Canada Inc. Full time

    Pantos Logistics Canada is currently hiring 4 Accounting Specialists: **Key Details**: - **Location**: 5255 Yonge St., North York, ON, M2N 5P8 - **Working hours**: 08:30-05:30 (8 hours) - **Salary Range**: $45k-$55k (Based on education and experience) - **Language**: English and Korean (Bilingual) Preferred - **Employee Benefits**: Health& Dental Insurance/...


  • North York, Canada Pantos Logistics Canada Inc. Full time

    Pantos Logistics Canada is currently hiring 4 Accounting Specialists: **Key Details**: - **Location**: 5255 Yonge St., North York, ON, M2N 5P8 - **Working hours**: 08:30-05:30 (8 hours) - **Salary Range**: $45k-$55k (Based on education and experience) - **Language**: English and Korean (Bilingual) Preferred - **Employee Benefits**: Health& Dental Insurance/...