Data Integration Analyst

Alberta School Employee Benefit Plan; Edmonton; Hybrid; CAD 82,000 - 92,000; Full time

Job summary

Alberta School Employee Benefit Plan in Edmonton is seeking a Data Integration Analyst (Full-Time, Permanent) to analyze and support data integrations and automations, ensuring reliable data flows between source systems, reporting platforms and the enterprise data warehouse.

The role involves documenting requirements, coordinating with BI developers and stakeholders, defining acceptance criteria, monitoring production integrations, and driving process automation while maintaining data lineage

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, BI, Data Analytics, or related discipline.

Responsibilities

• 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 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 production integrations.
• Maintain working relationships with source system owners and vendors to obtain early notice of planned changes and analyze impacts to integrations.
• Coordinate testing and validation related to source system changes, including regression testing of affected assets.
• Analyze business processes to identify automation opportunities and support implementation of automation solutions.
• Document data lineage, metadata, and inventories for BIS-managed assets; maintain data dictionaries and change history.
• Identify and tag sensitive data elements to support privacy and access controls.

Skills

Analytical thinking

Communication

Data modeling

Problem solving

Education

Bachelor’s degree in Computer Science or related field

3–5 years of data integration experience

Tools

SQL

SSIS

Dimensional modelling

Job description

• 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.

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.

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.