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 Company

Company

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.