Data System Integration Specialist

5 months ago


Vancouver, Canada HTEC Hydrogen Technology & Energy Corp Full time

Do you have a passion for the environment and cleantech, and a drive to change our world for the better? Are you eager to build your career in a growing company, enjoy getting exposure to a variety of tasks, and enjoy new challenges? Keep reading We may have your dream job

At HTEC we’re unlocking the potential of hydrogen to reduce climate change and air pollution. Based in Vancouver, we design, build, and operate hydrogen fuel supply solutions to support the deployment of hydrogen fuel cell electric vehicles. Every day, we’re delivering safe, reliable, convenient, sustainable, and low-cost hydrogen to customers and consumers, how, when, and where they need it.

Job Brief:
Reporting to the Data Manager, the Information System Specialist will be part of the IS-DM (Information Systems and Data Management) team and will be responsible for the Network of Data Systems by developing system integration to the PLC and PI systems. The Data System Integration Specialist is responsible for ensuring existing and new developments are completed safely abiding all standard system and security programs requirements.

**Responsibilities**:

- Develop SQL and PI system integration based on inputs from the PM and/or engineering team
- Test, modify and update SQL, PLC and PI System and verify functionality as described in the engineering documents and drawings.
- Configure, test, and commission industrial networking devices including switches, firewalls, and interfaces between Control Systems and Information Technology (IT) systems.
- Participate in verifying correct functionality of field devices along with other commissioning team members; identify and resolve problems caused by PLC/DCS configuration and/or programming.
- Identifying and documenting deficiencies.
- Provide input and follow up on deficiencies to make sure they are addressed and closed satisfactorily.
- Completing defined commissioning documentation (e.g., check sheets, ITPs, and test reports).
- Recording final and accurate as-left condition of PLC and DCS configuration and programming on redlines of engineering documents, drawings, and project documentation.
- Support and provide input to development of detailed plans for execution of work.
- Monitoring the schedule and productivity of work and work collaboratively to resolve issues and barriers.
- Design, develop and maintain datasets & data app.
- Collaborate with IT department and teams across business to build and maintain data pipelines that extract, transform, and load data from various sources into relevant datasets.
- Support the design and development of data models and dashboards that support reporting, analysis, and visualization.
- Optimize all stages of the data analysis process, from extraction through the modelling and visualization.
- Act as a System Expert by supporting team members in the use and interpretation of data and understanding of metrics and reporting requirements.
- Collaborates with and provides training and knowledge transfer to business end-users of reports and data sources.
- Supports ad hoc and other unplanned analysis and reporting needs as determined by management priority and business changes.

**Requirements**:

- Bachelor's degree in computer science, Statistics, Business or relevant field. An equivalent combination of education and/or work experience will be considered.
- Minimum 5 years of experience with SQL development, statistical analytics, KPI development and metrics reporting, preferably in a Program & Project Management environment with quantitative metric analysis.
- Experience with Microsoft Power Query & SQL.
- Experience working with data and databases, including working experience with programming languages and business intelligence tools to build dataflow, datasets and analytical solutions.
- Experience with the Microsoft Power Platform, including Power Apps and Power Automate (Flow) is an asset.
- Experience with Azure Analytics Services, including Azure Analysis Services, is an asset.
- Expertly demonstrable understanding of database structure, business object models, and large-scale data processing techniques.
- Experience in App and Web development is an asset.
- Familiarity and understanding of critical metric analysis, performance measurement, financial systems, and project scheduling/controls systems.
- Demonstrate System knowledge and ability to merge multiple data sources into substantial information, review incomplete data, tackle problems, and provide recommendation for significant solutions.
- Deep technical communication ability, including the ability to clearly and concisely detail and communicate complex data structures and process maps.
- Demonstrated analytical and problem-solving skills.
- Excellent verbal/written communication and interpersonal skills.
- Excellent organizational skills, including ability to prioritize a variety of work assignments.
- Outstanding time management skills and ability to work independently with mínim



  • Vancouver, Canada PHSA Full time

    **Job Summary**: Reporting to the Decision Support Consultant, Information Integration, the Data Integration Specialist provides integrated healthcare data analysis and interpretation to senior leadership, agency committees, departments and external consultants. This role is responsible for opportunity identification, business requirements analysis, design...


  • Vancouver, British Columbia, Canada Synthesis Health Full time

    Job Title: Software Development and Integration SpecialistWe are seeking a highly skilled Software Development and Integration Specialist to join our team at Synthesis Health. This individual will be responsible for developing and implementing software solutions that meet the needs of our customers.About the RoleThe ideal candidate will have a strong...


  • Vancouver, British Columbia, Canada British Columbia Lottery Corporation Full time

    About the RoleWe are looking for a skilled Data Integration Specialist 3 to join our Data Services team at the British Columbia Lottery Corporation.As a key member of our team, you will design, develop, and maintain BCLC's data integration solutions.Your responsibilities will include developing ETL workflows, supporting the Enterprise Data Warehouse (EDW)...


  • Vancouver, Canada Fluor Corporation Full time

    Fluor is one of Canada's top employers and is recognized globally as a leader in the Engineering, Procurement, Construction, Fabrication, and Maintenance industry. Our focus on innovation and providing cost-effective technology-based solutions is second to none. As we look to the future, we need creative, ambitious, and innovative professionals who can help...


  • Vancouver, British Columbia, Canada Amazon Data Services Canada, Inc. Full time

    We are seeking a highly skilled Data Systems Architect to join our team at Amazon Data Services Canada, Inc. The ideal candidate will have experience designing and implementing data systems that simplify bringing new models to customers and enhance the visibility into our underlying modeling process.In this role, you will work closely with our Product and...


  • Vancouver, Canada Forsta Full time

    Company Description Looking to level up your career by working with an ambitious global team? Want to play a key role in the success of a growing healthcare and technology company? Interested in engaging in online conversations about patient experience, consumer and employee insights, customer experience (CX), the evolution of the healthcare industry, and...


  • Vancouver, British Columbia, Canada Paladin Technologies Full time

    About the RoleWe are seeking a skilled Cybersecurity Systems Integration Specialist to join our team at Paladin Technologies.Job SummaryThis is a fantastic opportunity to work with our experienced team in installing, maintaining, and repairing security systems. As a Cybersecurity Systems Integration Specialist, you will assist in system design, installation,...


  • Vancouver, British Columbia, Canada CB Canada Full time

    Job Title: Intermediate Data Integration Developer, SSISCB Canada is seeking an experienced Intermediate Data Integration Developer, SSIS to join our team.Job SummaryWe are looking for a skilled Intermediate Data Integration Developer, SSIS to support and develop SSIS solutions executing systems integrations and data migrations. The ideal candidate will have...


  • Vancouver, Canada Forsta Full time

    Company Description Looking to level up your career by working with an ambitious global team? Want to play a key role in the success of a growing healthcare and technology company? Interested in engaging in online conversations about patient experience, consumer and employee insights, customer experience (CX), the evolution of the healthcare industry, and...


  • Vancouver, British Columbia, Canada Canfor Full time

    About the RoleWe are seeking a highly skilled and experienced Senior Integration Specialist to join our team at Canfor. As a key member of our organization, you will be responsible for designing, implementing, and maintaining complex cloud-based data integration systems.


  • Vancouver, British Columbia, Canada NTT DATA Full time

    Job OverviewWe are seeking an experienced Digital Portfolio Optimization Specialist to join our team in Vancouver, British Columbia, Canada. This role is critical in optimizing our integrated portfolio by combining analysis of business, financial, technology, and risk perspectives.About the RolePortfolio Rationalization/Optimization: Lead the rationalization...


  • Vancouver, British Columbia, Canada Global Pharma Tek Full time

    Job Description:As a Software Development Specialist - Data Integration at Global Pharma Tek, you will be responsible for mapping out and documenting data flows within SSIS packages related to the MHSU MRR dataset. This includes source and destination data stores, transformations, and conditional logic.Data Governance ComplianceYou will ensure that all...


  • Vancouver, British Columbia, Canada CB Canada Full time

    **Data Integration Expert Wanted**At CB Canada, we are seeking a highly skilled Data Integration Expert to join our team.The ideal candidate will have extensive experience with SSIS solutions, system integrations, and data migrations. They will also be proficient in leveraging SSIS experience to reverse engineer, modify, and manage existing integrations...


  • Vancouver, British Columbia, Canada Ainsworth Full time

    Overview: Ainsworth, a subsidiary of GDI, is a dynamic and rapidly growing organization that seeks to hire a skilled RTLS System Integration Specialist. This role is responsible for designing, programming, commissioning, and servicing multiple healthcare technologies, including but not limited to RTLS and nurse call systems. Salary Range: $28-$42 per...


  • Vancouver, British Columbia, Canada Canfor Full time

    Integration Specialist Role OverviewCanfor is seeking a highly skilled Integration Specialist to join our team. As an Integration Specialist, you will be responsible for designing, developing, testing, supporting, and maintaining A2A and B2B (EDI) integrations using Software AG webMethods-related technologies and Azure stack.Key ResponsibilitiesAnalysis,...


  • Vancouver, British Columbia, Canada AbCellera Full time

    About the RoleWe are seeking a highly skilled Data Integrity and Governance Specialist to join our Digital Quality team at AbCellera. As a key member of our team, you will work closely with GxP operational subject matter experts, the Information Technology team, and cross-functional system analysts and developers to define, design, and execute data...


  • Vancouver, British Columbia, Canada Paladin Technologies Full time

    Company Overview:PALADIN Technologies is a leading North American complex systems integrator for building technology solutions, including IP security, alarms & monitoring, audio visual, low-voltage infrastructure, and networking. As a leader in the design, deployment, optimization, management, and maintenance of communication and digital networks, PALADIN...


  • Vancouver, British Columbia, Canada D2L Full time

    Role SummaryAs a Senior Integration Specialist at D2L, you will be responsible for designing, developing, and maintaining seamless integrations between various applications and systems using the Workato platform. This role involves collaborating with customers to understand business requirements, creating efficient workflows, and ensuring data accuracy and...


  • Vancouver, British Columbia, Canada DSI Recruiting Full time

    We are seeking a seasoned Data Modeling and Integration Expert to drive data-centric projects at DSI Recruiting.This role plays a pivotal part in understanding complex business requirements, analyzing data, and translating those needs into technical solutions. You will be responsible for designing and optimizing data models, ensuring seamless database...


  • Vancouver, British Columbia, Canada Paladin Technologies Full time

    Unlock Your Potential in a Dynamic RolePaladin Technologies, a premier complex systems integrator, is seeking a skilled Senior Audio Visual Systems Integration Specialist to lead large commercial AV installation projects.