Data Integration Analyst

ASEBP; Edmonton; Hybrid; CAD 82,000 - 92,000; Full time

Benefits offered by this job

Hybrid workforce program

Job summary

ASEBP in Edmonton, AB, Canada is seeking a Data Integration Analyst to analyze, document, coordinate, monitor, and support data integrations and automations that enable operational and analytical reporting.

The role ensures the reliability, quality, and continuity of data flows between source systems, reporting platforms, and the enterprise data warehouse while assessing system changes and identifying opportunities for process automation and improvement.

Qualifications

• 3–5 years of progressively responsible experience in data integration, BI, data warehousing or related IT functions.
• Experience in SQL, SSIS, dimensional modelling (Kimball/star schema), business analysis, documentation, technical communication, data quality validation and troubleshooting.
• Certification in Microsoft Fabric, Microsoft Data Platform, project management or business analysis is an asset.

Responsibilities

• Analyze and document requirements and technical specifications for new or changed data integrations.
• Coordinate integration development activities with BI Developers and business stakeholders from requirements through deployment.
• Define acceptance criteria and data quality checks; perform data validation and user acceptance testing prior to production release.
• Monitor active integrations in production to confirm data completeness and accuracy.
• Investigate, troubleshoot, and coordinate resolution of failures and data quality issues affecting integrations.

Skills

SQL

SSIS

Dimensional modelling

Business analysis

Documentation

Technical communication

Data quality validation

Troubleshooting

Education

Degree in Computer Science, Information Systems, BI, Data Analytics, Information Management, or related

Tools

SSIS

Job description

If you are a job seeker with a disability and require a reasonable accommodation to apply for one of our jobs, you will find the contact information to request the appropriate accommodation by visiting the following our Accessibility Accomodation for Applicants page.

Data Integration Analyst

Apply now

• Posted on November 2, 2026

Locations

Showing 1 location

Edmonton, AB T6H2K7, CAN

• Hybrid
• Pay or shift range: $81,500 CAD to $91,500 CAD
  
  The listed pay range represents the hiring range for this position, applicable to fully qualified candidates. Final compensation offers are determined based on a variety of factors, including the candidate’s skills, experience, qualifications, and other job-related considerations. Offers also take into account internal equity to ensure fairness and consistency across similar roles within the organization.
• BI Services
• Full-Time
• Requisition #: DATAI001145

Description

Data Integration Analyst

Full-Time, Permanent

Position Summary

The Data Integration Analyst is responsible for analyzing, documenting, coordinating, monitoring, and supporting data integrations and automations that enable operational and analytical reporting. The role ensures the reliability, quality, and continuity of data flows between source systems, reporting platforms, and the enterprise data warehouse while assessing the impact of system changes and identifying opportunities for process automation and improvement.

Your Key Responsibilities

Data Integration Management & Support

• Analyze and document requirements and technical specifications, including source-to-target mappings, for new or changed data integrations.
• Coordinate integration development activities with BI Developers and business stakeholders from requirements through deployment.
• Define acceptance criteria/data quality checks and perform data validation and user acceptance testing prior to production release.
• Monitor active integrations in production systems to confirm successful execution, data completeness, and data accuracy.
• Investigate, troubleshoot, and coordinate resolution of failures, data quality issues, and incidents affecting newly deployed and established production integrations.

Source System Change Management & Impact Assessment

• Maintain working relationships with source system owners and vendors to obtain early notice of planned changes.
• Review source system releases, schema modifications, pull requests, and vendor changes, and analyze impacts to integrations, reporting solutions, data warehouse structures, and automated processes.
• Coordinate testing and validation related to source system changes, including regression testing of affected downstream assets.
• Communicate risks, impacts, and recommendations to stakeholders and technical resources.

Automation Analysis & Process Improvement

• Analyze business processes to identify automation opportunities that improve efficiency, reduce manual effort, and enhance data quality.
• Support implementation of automation solutions by clarifying requirements and validating outcomes with developers and stakeholders.
• Confirm automations are production-ready, with defined business ownership, exception handling, and failure notification.
• Document and maintain data lineage from source systems through integration processes into the enterprise data warehouse, incorporating integration specifications and mappings as the system of record.
• Maintain metadata repositories, data dictionaries, integration inventories, and change impact history for BIS-managed assets.
• Document business rules, transformation logic, and data dependencies.
• Identify and tag sensitive data elements (e.g., personal and health information) in metadata to support privacy and access controls.
• Support data retention and administration practices related to BIS-managed data assets.
• Keep documentation and inventories current through updates following system, integration, or automation changes and periodic accuracy reviews.

Your Education and Experience

• A degree in Computer Science, Information Systems, Business Intelligence, Data Analytics, Information Management, or a related discipline.
• 3–5 years of progressively responsible experience in data integration, business intelligence, business analysis, data warehousing, data analysis, or related information technology functions.
• Experience in SQL, SSIS, dimensional modelling (Kimball/star schema), business analysis, documentation, technical communication, data quality validation, and troubleshooting.
• Certification in Microsoft Fabric, Microsoft Data Platform, project management or business analysis is an asset.

Your Abilities

• Ability to independently analyze complex issues, identify significant risks, and assess cross-functional impacts to support informed decision-making.
• Analyze process and data flow requirements to develop recommendations and support the implementation of approved solutions.
• Strong investigative, analytical, and problem-solving skills, including the ability to trace data lineage, evaluate business rules, determine root causes, and recommend effective solutions.
• Demonstrated ability to provide subject matter expertise in data flows, system integrations, metadata, and data dependencies.
• Exceptional collaboration and communication skills with the ability to translate complex information into actionable recommendations.

This position is eligible to participate in the hybrid workforce program.

If you have the required qualifications and would like to become a member of our team, please submit your resume and cover letter. This posting will remain open until filled.

No phone calls please. We thank all interested individuals, but only those candidates being considered for an interview will be contacted. ASEBP is an equal opportunity employer.

All offers of employment for this position are conditional upon satisfactory background and reference checks, which may include a criminal record check, and/or education and employment verification.