ETL Application Specialist

3 months ago

Calgary, Canada Vista Projects Limited Full time

Vista Projects is an integrated industrial engineering firm that helps clients navigate the digital transformation of their projects and operations. Our proven project execution process is based on a “single source of truth” model that eliminates the potential for inefficient engineering designs, cost overruns, and project completion delays.

Why We Do It

We believe the world needs industrial projects and that intelligent engineering data can increase the likelihood of innovative solutions getting to market. Over the years, we have earned our reputation as a trusted industrial engineering partner, working on some of the most successful facility projects in the Canadian energy sector.

Where We Work

The benefits of our approach apply across several industrial markets, from biofuels and produced water treatment to gas processing and in-situ heavy oil. Our headquarters are in Calgary, Alberta.

What You Would Do in This Role

The ETL Applications Specialist is responsible for the extraction, transformation, and loading of documents and data between applications. Duties include:

  • Establishing new system integrations as well as maintenance and support for existing implementations.
  • Performing enhancements to existing systems with a focus on .NET development.
  • Maintaining and monitoring complex ETL activities.
  • Authoring XML configurations to prepare data sources for publishing.
  • Maintaining servers and databases for ongoing projects.
  • Customizing reports as per project requirements.
  • Performing continuous improvement and development of Vista’s AVEVA NET / AIM build.
  • Ensuring data integrity across the platform.
  • Troubleshooting and solving application challenges.
  • Producing workflows and procedures.
  • Developing detailed project work instructions for users.
  • Training the project team on using applications.
  • Keeping abreast of technological and software developments affecting the application.
  • Preliminary liaising with the IT, Engineering, Design, and Project Management teams to ensure a fit-for-purpose implementation that meets all stakeholders' needs.
  • Leveraging APIs on desktop and cloud-based systems to facilitate automation and data transfer.
  • Liaising with internal project teams and clients as needed.
Requirements
  • Bachelor’s degree or diploma in a related field (Management Information Systems, Engineering, Design and Drafting, Computer Science, etc.) or equivalent experience.
  • Strong working experience in Visual Studio, including .NET programming in Visual Basic or C#.
  • Strong working experience in MS SQL Databases including basic administration and security tasks.
  • Experience with Oracle and other databases.
  • Knowledge of relational database management.
  • Experience with SQL Server Integration Services (SSIS) and SQL Reporting Services (SSRS).
  • Understanding of ETL, data warehousing, and reporting architecture.
  • Experience configuring and maintaining Windows 2016+ Servers and IIS.
  • Team player with a positive attitude and always willing to accept new challenges.
  • Strong verbal and written communication skills.
Preferred
  • Previous experience with AVEVA toolset(s) including AVEVA NET / AIM development and administration experience.
  • Experience in data visualization and analysis (e.g., PowerBI or similar tools).
  • Processing JSON and XML files supplied by cloud-based services.
  • Experience developing and implementing new applications.
  • Knowledge of engineering data.
  • Less than 14 years of combined education and experience.
  • Able to complete most duties with limited support from Senior or Lead team member.
  • Provide training and support to less experienced team members.
Why People Like Working with Us

Working with Vista is a chance to learn and grow while contributing to the type of challenging industrial projects that the world requires. If that doesn’t excite you, this role likely won’t be a fit.

Challenging projects require focus and we enable our people to do their best work with modernized project systems that are based on our leading use of intelligent data-centric execution architecture. Our staff and clients like it because it gives them real-time access to validated data shared across all project departments. This fosters project design and business decisions based on a single, authoritative source of truth and provides increased transparency and collaboration with team members and clients, leading to improved engineering quality and a product we can all take pride in.

What We Offer

An opportunity with Vista is not just a job; it is a chance to tackle challenging industrial projects with colleagues who are among the most recognized and accomplished in their disciplines.

Vista offers all employees
  • A stimulating, fast-paced and challenging work environment where you will contribute to interesting industrial engineering projects.
  • A robust and consistent recruitment process that ensures your colleagues are likeminded and comparably capable.
  • An opportunity to be a part of an entrepreneurial, technically skilled team which has established leadership in innovative engineering solutions.
  • A strong value-based philosophy that provides an informal, close-knit team environment, where you and your family feel like a part of our organization, and not just an employee number.
  • Competitive compensation and benefits, including a performance-linked variable pay program.
  • Company-sponsored social events and team sports.
  • Flexible work schedules, half-day Fridays, and free parking.
  • An organization that values and encourages diversity.
  • Shareholder opportunities are a long-term potential for exceptional employees.
How to Apply

Please complete the application form below and include a cover letter concisely demonstrating how your skills and experience align with our job posting. By submitting this application, you consent to our Privacy Policy, and you consent to receive transactional electronic messages from Vista and third parties acting on our behalf.

Note: As part of the hiring process there will be a technical testing component that will take up to two hours and can be completed at home on your own timelines. Candidates may be required to complete a security clearance procedure prior to receiving an offer. #J-18808-Ljbffr

  • ETL Systems Integration Specialist

    4 weeks ago

    Calgary, Alberta, Canada Vista Projects Limited Full time

    Job SummaryVista Projects Limited is seeking an ETL Systems Integration Specialist to join our team. As a key member of our engineering team, you will be responsible for the extraction, transformation, and loading of documents and data between applications.Key ResponsibilitiesThe successful candidate will be responsible for establishing new system...

  • Informatica ETL Specialist

    2 weeks ago

    Calgary, Alberta, Canada Nova Tribes Inc Full time

    About the RoleWe are seeking a highly skilled Informatica ETL developer to join our team at Nova Tribes Inc. This is a fantastic opportunity for an experienced professional to take on new challenges and responsibilities.Key ResponsibilitiesData Integration: Design, develop, and implement complex data integration solutions using Informatica PowerCenter and...

  • ETL Test Lead

    3 months ago

    Calgary, Alberta, Calgary region, Canada Cigniti Technologies Full time

    We are looking for strong ETL test lead with Automation experience. Responsibilities:Collaboration - Collaborating with cross-functional teams including developers, business analysts, data engineers, and business users to understand requirements and ensure successful testing.Test Planning - Develop Test Plans, following the ETL and BI systems testing best...

  • Software Engineering Application Developer

    4 weeks ago

    Calgary, Alberta, Canada Artech LLC Full time

    We are seeking a highly skilled Software Engineering Application Developer to join our team at Artech LLC. This is a 6-month contract opportunity for a remote worker in Calgary, AB.Design and implement scalable ingestion frameworks with data engineering experience.Develop expertise in AWS services, including Redshift, S3, DynamoDB, EMR serverless, Lambdas,...

  • Lead GIS Data Integration Specialist

    2 weeks ago

    Calgary, Alberta, Canada CP Full time

    Job OverviewWe are seeking a highly skilled Lead GIS Data Integration Specialist to join our team at CP.About the RoleThe successful candidate will be responsible for designing, implementing, and overseeing real-time and near real-time ETL workflows that manage GIS data integration with various systems.Key ResponsibilitiesDesign and implement ETL workflows...

  • Aveva Applications Specialist

    3 months ago

    Calgary, Canada Vista Projects Limited Full time

    **What Vista Does**: Vista Projects is an integrated industrial engineering firm that helps clients navigate the digital transformation of their projects and operations. Our proven project execution process is based on a “single source of truth” model that eliminates the potential for inefficient engineering designs, cost overruns and project completion...

  • Application Specialist

    4 weeks ago

    Calgary, Alberta, Canada PARAMOUNT AGRO GROUP LTD Full time

    Our company is seeking a highly skilled Application Specialist to join our team. The successful candidate will have a strong background in application management and be able to handle a variety of tasks with ease.Main Responsibilities:Application ManagementTechnical SupportProblem SolvingWe offer a dynamic work environment and opportunities for growth and...

  • Senior Data Integration Specialist

    2 weeks ago

    Calgary, Alberta, Canada Nova Tribes Inc Full time

    Job Title: Senior Data Integration SpecialistNova Tribes Inc is seeking a highly skilled Senior Data Integration Specialist to join our team. The ideal candidate will have 7-10 years of experience in ETL development with a focus on Informatica and working knowledge of Linux and shell scripting.The successful candidate will be responsible for maintaining and...

  • AVEVA Applications Specialist

    3 months ago

    Calgary, Canada Vista Projects Limited Full time

    What Vista DoesVista Projects is an integrated industrial engineering firm that helps clients navigate the digital transformation of their projects and operations. Our proven project execution process is based on a “single source of truth” model that eliminates the potential for inefficient engineering designs, cost overruns and project completion...

  • Aveva E3D Applications Specialist

    5 months ago

    Calgary, Canada Vista Projects Limited Full time

    **What Vista Does**: Vista Projects is an integrated industrial engineering firm that helps clients navigate the digital transformation of their projects and operations. Our proven project execution process is based on a “single source of truth” model that eliminates the potential for inefficient engineering designs, cost overruns and project completion...

  • Software Engineering

    2 weeks ago

    Calgary, Canada Artech LLC Full time

    Title: Software Engineering - Application Developer Position - 2 Start Date: Dec-2-2024 | End Date: May-2-2025 Remote - 100% Location: Calgary - Preferred Pay Rate - T4 - $48 | Inc - $55 6 years of data engineering experience with a proven track record of designing and implementing scalable ingestion framework. 4 years hands on...

  • Applications Specialist

    6 months ago

    Calgary, Canada Designfusion Full time

    **Why Designfusion?***: Designfusion is a dynamic, evolving company that is always looking for the right people to help our company grow. We look for people with industry experience who possess a positive "can do" attitude. People who are creative thinkers and not afraid to take on challenges. Calgary **JOB TITLE**: Applications Specialist ‍...

  • Colour Application Specialist

    2 weeks ago

    Calgary, Alberta, Canada EUROPEAN PAINTING SERVICES LTD Full time

    Job Title: Colour Application SpecialistAbout the Role:We are seeking a skilled Colour Application Specialist to join our team at European Painting Services Ltd. This is a permanent position requiring 30-40 hours of work per week.Key Responsibilities:Prepare, clean, and sand surfaces for paintingRepair cracks and holes in wallsMix paint to the desired colour...

  • Data Integration Specialist

    3 weeks ago

    Calgary, Alberta, Canada Nova Tribes Inc Full time

    **Position Overview**The Data Integration Specialist at Nova Tribes Inc will be responsible for providing support for existing workflows through performance tuning, organic growth planning, and creating new logic for data source changes.This position will be involved in new workflow development through database design, logic design, performance tuning, and...

  • Gis Integration Specialist

    4 weeks ago

    Calgary, Canada City of Calgary Full time

    If you are committed to public service, enjoy collaborating with others, share our values and have a desire to learn and grow, join The City of Calgary. City employees deliver the services, run the programs and operate the facilities which make a difference in our community. We support work-life balance, promote physical and psychological safety, and offer...

  • Enterprise Data Integration Specialist

    2 weeks ago

    Calgary, Alberta, Canada Nova Tribes Inc Full time

    Job OverviewPURPOSE OF THE POSITIONNova Tribes Inc is seeking an experienced Enterprise Data Integration Specialist to join our team. The successful candidate will be responsible for designing, implementing, and maintaining data integration solutions using Informatica and other technologies.POSITION ACCOUNTABILITIES:Responsible for data integration using in...

  • Software Developer

    3 weeks ago

    Calgary, Alberta, Canada Fluidstream Inc. Full time

    Job Title: Software Developer - Application SpecialistAbout the Role:We are seeking an experienced Software Developer - Application Specialist to join our team at Fluidstream Inc. The ideal candidate will have a strong background in software development, with a focus on application programming and PLC expertise.Key Responsibilities:Design, develop, and...

  • Data Integration Specialist

    2 weeks ago

    Calgary, Alberta, Canada Nova Tribes Inc Full time

    Job DescriptionWe are seeking a highly skilled Data Integration Specialist to join our team at Nova Tribes Inc.About the RoleThis position will provide critical support for existing workflows through performance tuning, organic growth planning, and creating new logic for data source changes. The successful candidate will be involved in new workflow...

  • Application Specialist

    2 months ago

    Calgary, Canada Vista Projects Limited Full time

    Vista Projects is an integrated industrial engineering firm that helps clients navigate the digital transformation of their projects and operations. Our proven project execution process is based on a “single source of truth” model that eliminates the potential for inefficient engineering designs, cost overruns and project completion delays.What You Would...

  • Data and Analytics Specialist

    1 month ago

    Calgary, Canada Canadian Cancer Society Full time

    **Job Title**: Data and Analytics Specialist **Work Model**: Hybrid work model **Salary Band**: 5 ($56,000 - $84,000 CAD CAD) **WHY JOIN THE CANADIAN CANCER SOCIETY (CCS)?** The Canadian Cancer Society works tirelessly to save and improve lives. We raise funds to fuel the brightest minds in cancer research. We provide a compassionate support system for...