Data Integration Analyst

Classification: Grid 24, BCGEU Membership

Office Location: Fort St John or Kelowna or Victoria

Salary: $76,313.27 - $86,898.73 – Permanent Full-Time, based on a 35-hour work week. An additional 10.75% Job Family Market Multiplier will be added to the posted salary. An additional 3% Location Allowance will be added to posted salary for northern location.

About the Job:

The Data Integration Analyst designs, builds, and maintains data integration and data architecture solutions that enable timely, secure, and reliable access to high-quality corporate data. Working within the Data Architecture & Integration function, the role connects internal and external systems, applications, APIs, and data services to deliver governed, accurate, and reliable data supporting operational and analytical needs across the organization.

This role develops and optimizes data pipelines, workflows, and transformation processes, and contributes to the evolution of enterprise data architecture patterns such as data warehousing, data virtualization, and cloud-based integration. The role partners closely with Information Systems, Information Technology, Business Intelligence, Geospatial Systems, and business stakeholders to translate data needs into technical specifications, troubleshoot integration issues, and implement durable solutions that improve reliability, consistency, and trust in corporate data.

Through disciplined documentation, version control, and deployment practices, the Data Integration Analyst supports sustainable delivery and operational stewardship of integration components, ensuring integrations are observable, supportable, and aligned with governance, privacy, and security requirements.

Organization Chart:

Commissioner, Chief Executive Officer

Chief Financial Officer, Executive Vice President, People & Transformation

Chief Digital Officer

Executive Director, Information & Digital Services

Director, Architecture & Innovation

Manager, Data Architecture & Integration

Data Integration Analyst

Responsibilities

Lead end-to-end delivery of data integration solutions from requirements through deployment and operationalization, connecting internal and external systems, applications, Application Programming Interfaces (APIs), and data services to support operational and analytical use cases.

Develop and optimize data pipelines, workflows, and transformation processes to ensure data is delivered in a timely, consistent, reliable manner across platforms and business units.

Analyze source systems and datasets to define integration requirements, identify data quality issues affecting integrated data flows, and recommend improvements to standardization, consistency, and usability of corporate data.

Create, refine, and maintain logical and physical data models that support new and existing business processes, and enable consistent downstream consumption.

Develop and maintain API-based integrations (e.g., REST/GraphQL or other service-oriented patterns), including integration specifications, interface/data contracts, versioning expectations, and lineage documentation, while ensuring operational support documentation is maintained.

Implement automation and orchestration approaches to streamline data movement, reduce manual effort, and improve repeatability and resilience of integration processes.

Own operational stewardship for integration services (monitoring, reliability, security controls, issue management, and root-cause analysis), proactively manage integration dependencies and data risks, and communicate operational health, risks, and remediation actions to stakeholders.

Lead the development and maintenance of data integration patterns, reference architectures, and reusable components (e.g., data virtualization/warehouse/cloud integration patterns), evaluating emerging integration technologies and trends to improve delivery efficiency, productivity, and long-term maintainability, while ensuring alignment with BCER standards.

Support internal and external data sharing initiatives by ensuring integrations and datasets comply with governance, privacy, and security requirements.

Contribute to enterprise data cataloguing, metadata, and lineage practices by maintaining documentation and integration artifacts that improve discoverability, stewardship, and supportability of trusted data products.

Use Git (or equivalent) version control and continuous integration/continuous delivery (CI/CD) release practices to manage integration code, configuration, and deployment artifacts; apply disciplined change management, documentation, validation/testing, and operational readiness practices for all integration work.

Provide technical direction and quality review of contractor-delivered integration components, ensuring deliverables align with standards and operational readiness expectations.

Qualifications

Education:

Master’s degree from a recognized post-secondary institution in a related field such as Computer Science, Information Systems, Data Management, Engineering, or a related discipline, and three years of relevant experience; or

Bachelor’s degree from a recognized post-secondary institution in a related field such as Computer Science, Information Systems, Data Management, Engineering, or a related discipline, and four years of relevant experience; or

An equivalent combination of education, training, and experience may be considered.

Experience:

Demonstrated experience designing, building, and supporting data integration solutions that move and transform data across systems and platforms to support operational and analytical needs.

Demonstrated experience with SQL and working with relational and non-relational data sources, including building reliable data transformations and integration workflows.

Demonstrated experience developing and supporting API-based integrations and service-oriented interfaces, including troubleshooting reliability, performance, and security issues.

Demonstrated experience in data modeling (logical and physical) and applying data warehousing and/or data virtualization concepts to support governed, consistent data consumption.

Demonstrated experience with version control (e.g., Git) and structured change management practices for integration code, configuration, and deployment artifacts.

Demonstrated experience with automation/orchestration approaches for data movement and integration operations, including monitoring and operational support practices.

Demonstrated experience producing clear technical documentation (integration specifications, data mappings, lineage notes, runbooks) and translating stakeholder needs into implementable technical requirements.

Preference may be given to individuals with experience in data cataloguing/metadata management practices and/or cloud-based integration patterns, including exposure to cloud platforms and enterprise orchestration approaches.

Key Competencies: Analytical Thinking

The ability to examine and understand complex situations by breaking them down into components, identifying patterns or relationships, and applying logical reasoning to systematically organize information and identify key factors or underlying causes prior to making decisions.

Communicating Effectively

The ability to convey information clearly, accurately, and appropriately to the intended audience. It involves utilizing multiple forms of communication channels and techniques, such as verbal and written communication, active listening, and nonverbal cues, to ensure a message is understood and received as intended. It involves being mindful of the audience’s needs, preferences, and cultural backgrounds, adapting the message and delivery style accordingly to facilitate mutual understanding and engagement.

Execution and Driving Results

The ability to align activities and resources to deliver on planned actions, meeting or surpassing high standards or excellence and achievement orientation. This includes keeping commitments, following through on objectives, and continuously striving for improvement.

Problem Solving and Judgement

The ability to systematically analyze problems, identify root causes, evaluate potential solutions, and make sound decisions to address challenges and achieve desired outcomes.

If you are interested in applying for this role and meet the minimum selection criteria, please select “Apply Now” and submit your application prior to the closing date. Applicants should review the education and experience listed in the job requisition and clearly articulate how their work experience and skills are aligned with the requirements. Please note, applicants will only be contacted if they are selected to proceed further in the process. An eligibility list with a duration of 6 months may be established.

About the BC Energy Regulator:

The BC Energy Regulator (BCER) is the Province of B.C.’s life-cycle energy resources regulator. The BCER is a Crown agency with a mandate to ensure energy resource activities are undertaken in a manner that: protects public safety and the environment, supports reconciliation with Indigenous peoples and the transition to low-carbon energy, conserves energy resources and fosters a sound economy and social well-being.

As a cost recoverable, values driven organization, we prioritize safety, stewardship and Indigenous interests throughout the full project lifecycle – from exploration to reclamation – and support the transition to clean energy. The BCER is committed to reconciliation with Indigenous Peoples, honouring the Provincial commitment to the United Nations Declaration on the Rights of Indigenous Peoples, the Declaration on the Rights of Indigenous Peoples Act, and the Truth and Reconciliation Commission (TRC) Calls to Action. Through fostering respectful and collaborative relationships with Indigenous partners and stakeholders, the BCER delivers on Government’s priorities.

The BCER has an innovative forward-thinking workplace that demonstrates our core values. Through continuous improvement and development, the BCER is agile and responsive to the rapidly changing environment in which we operate. We are diverse and inclusive, with transparency, innovation, and integrity as foundation of our respectful culture.

What We Offer:

The BCER operates under a Hybrid Office Model whereby employees work from both a home office and a designated BCER office location in order to support our mandate (eligibility may vary, depending on position).

The BCER is proud to be an equal employment opportunity employer. We do not discriminate based on the protected grounds under the Human Rights Code. The BCER is committed to providing reasonable accommodations for the removal of barriers for qualified individuals. If you need assistance or accommodation, please let us know.

We acknowledge and respect the many First Nations, each with unique cultures, languages, legal traditions and relationships to the land and water, on whose territories the British Columbia Energy Regulator's work spans.

Please contact us at Recruitment@bc-er.ca if you require any assistance or more information.

The Digital Innovation Department is responsible for the strategic development of digital, data and technology capabilities that help to modernize, advance and futureproof the BC Energy Regulator. The department enables continuous innovation and evolution of BCER’s processes, products and services anchored in user-centric, data-driven approaches.

The Digital Innovation Department’s mission is to:

• Design experiences that are user centred and quick to deliver.

• Rely on user feedback and data to optimize and influence the future of BCER’s products, services and processes.

• Integrate and connect technologies, data, platforms and products in meaningful ways that enhance the end user experience while serving our internal requirements.

• Experiment with prototypes and iterative development using agile processes.

• Create a consistent experience both online and offline for users of BCER’s systems and services.

Within the Digital Innovation Department, the Architecture & Innovation program area is responsible for the strategic design, development, and management of digital and data capabilities that support innovation, operational efficiency, and data-informed decision-making across the organization. This program area includes Web & SharePoint Development, Business Intelligence, and Data Architecture & Integration functions.