Data System Integration Specialist

4 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 ECF Data, LLC Full time

    At Fluor, we are proud to design and build projects and careers. This requires teams that are as unique as the projects we execute. We are committed to fostering a work environment that embraces Diversity, Equity, and Inclusion (DE&I) for all so our employees and stakeholders benefit from the creative solutions derived as a result of embracing differences....


  • Vancouver, Canada Providence Healthcare Full time

    Article Flag: Mandatory Vaccination Please Note: As per the current Public Health Orders (Long Term Care/Seniors Assisted Living Provincial Health Order and the Health Sector Order), as of October 26, 2021, all employees working for Providence Health Care must be fully vaccinated against COVID-19. Proof of vaccination status will be required. Summary:...


  • Vancouver, British Columbia, Canada Trez Capital Full time

    Job Title: Data Integration SpecialistTrez Capital is a leading provider of private commercial real estate debt and equity financing solutions in Canada and the United States. We are seeking a highly skilled Data Integration Specialist to join our team.Job Summary:The Data Integration Specialist will work with the Director, Data Analytics to develop,...


  • Vancouver, British Columbia, Canada Trez Capital Full time

    Job Title: Data Integration SpecialistTrez Capital is a leading provider of private commercial real estate debt and equity financing solutions in Canada and the United States. We are seeking a highly skilled Data Integration Specialist to join our team.Job Summary:The Data Integration Specialist will work with the Director, Data Analytics to develop,...


  • Vancouver, British Columbia, Canada Accoravillage Full time

    Job Title: Data Integration SpecialistWe are seeking a highly skilled Data Integration Specialist to join our team at Accoravillage. As a key member of our data management team, you will be responsible for developing, implementing, and maintaining data integration and reporting solutions to improve analytical reporting, digitization, and process...


  • Vancouver, British Columbia, Canada Accoravillage Full time

    Job Title: Data Integration SpecialistWe are seeking a highly skilled Data Integration Specialist to join our team at Accoravillage. As a key member of our data management team, you will be responsible for developing, implementing, and maintaining data integration and reporting solutions to improve analytical reporting, digitization, and process...


  • Vancouver, British Columbia, Canada Accoravillage Full time $73,485 - $105,570

    About the RoleWe are seeking a highly skilled Data Integration Specialist to join our team at Accoravillage. As a key member of our data analytics department, you will play a critical role in developing, implementing, and maintaining data integration and reporting solutions.Key ResponsibilitiesDevelop and implement ETL processes to support data integration...


  • Vancouver, British Columbia, Canada Accoravillage Full time $73,485 - $105,570

    About the RoleWe are seeking a highly skilled Data Integration Specialist to join our team at Accoravillage. As a key member of our data analytics department, you will play a critical role in developing, implementing, and maintaining data integration and reporting solutions.Key ResponsibilitiesDevelop and implement ETL processes to support data integration...


  • 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 Trez Capital Full time $73,485 - $105,570

    Trez Capital Job OpportunityWe are seeking a highly skilled Data Integration Specialist to join our team at Trez Capital. As a key member of our data analytics department, you will play a crucial role in developing, implementing, and maintaining data integration and reporting solutions to improve analytical reporting, digitization, and process...


  • Vancouver, British Columbia, Canada Trez Capital Full time $73,485 - $105,570

    Trez Capital Job OpportunityWe are seeking a highly skilled Data Integration Specialist to join our team at Trez Capital. As a key member of our data analytics department, you will play a crucial role in developing, implementing, and maintaining data integration and reporting solutions to improve analytical reporting, digitization, and process...


  • Vancouver, British Columbia, Canada CB Canada Full time

    Job SummaryCB Canada is seeking a highly skilled Senior Data Integration Specialist to join our team. As a key member of our data integration team, you will be responsible for designing, developing, and implementing SSIS solutions to execute systems integrations and data migrations.Key ResponsibilitiesDesign and Develop SSIS Solutions: Create and implement...


  • Vancouver, British Columbia, Canada CB Canada Full time

    Job SummaryCB Canada is seeking a highly skilled Senior Data Integration Specialist to join our team. As a key member of our data integration team, you will be responsible for designing, developing, and implementing SSIS solutions to execute systems integrations and data migrations.Key ResponsibilitiesDesign and Develop SSIS Solutions: Create and implement...


  • Vancouver, British Columbia, Canada Accoravillage Full time $73,485 - $105,570

    About the RoleWe are seeking a highly skilled Data Integration Specialist to join our team at Accoravillage. As a key member of our Data Analytics department, you will be responsible for developing, implementing, and maintaining data integration and reporting solutions to improve analytical reporting, digitization, and process efficiencies.Key...


  • Vancouver, British Columbia, Canada Accoravillage Full time $73,485 - $105,570

    About the RoleWe are seeking a highly skilled Data Integration Specialist to join our team at Accoravillage. As a key member of our Data Analytics department, you will be responsible for developing, implementing, and maintaining data integration and reporting solutions to improve analytical reporting, digitization, and process efficiencies.Key...


  • Vancouver, British Columbia, Canada Trez Capital Group Full time $73,485 - $105,570

    Trez Capital Group Job DescriptionWe are seeking a highly skilled Data Integration Specialist to join our team at Trez Capital Group. As a key member of our data analytics team, you will be responsible for developing, implementing, and maintaining data integration and reporting solutions to improve analytical reporting, digitization, and process...


  • Vancouver, British Columbia, Canada Trez Capital Group Full time $73,485 - $105,570

    Trez Capital Group Job DescriptionWe are seeking a highly skilled Data Integration Specialist to join our team at Trez Capital Group. As a key member of our data analytics team, you will be responsible for developing, implementing, and maintaining data integration and reporting solutions to improve analytical reporting, digitization, and process...


  • Vancouver, British Columbia, Canada Accoravillage Full time $73,485 - $105,570

    About the RoleWe are seeking a highly skilled Data Integration Specialist to join our team at Accoravillage. As a key member of our data analytics team, you will be responsible for developing, implementing, and maintaining data integration and reporting solutions to improve analytical reporting, digitization, and process efficiencies.Key...


  • Vancouver, British Columbia, Canada Accoravillage Full time $73,485 - $105,570

    About the RoleWe are seeking a highly skilled Data Integration Specialist to join our team at Accoravillage. As a key member of our data analytics team, you will be responsible for developing, implementing, and maintaining data integration and reporting solutions to improve analytical reporting, digitization, and process efficiencies.Key...


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