ETL Application Specialist

4 weeks 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:

  • stablishing 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 than14 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 the 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 anoffer.

What's your citizenship / employment eligibility?*

LinkedIn Profile URL:

Desired salary*

In 150 characters or fewer, tell us what makes you unique. Try to be creative and say something that will catch our eye* 150

#J-18808-Ljbffr

  • ETL Application Specialist

    1 month ago

    Calgary, Alberta, 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 delaysWhy...

  • ETL Test Lead

    4 weeks ago

    Calgary, Canada Atlantis IT Group Full time

    Bachelor’s Degree in computer science, information systems, business administration or other industry related curriculum) or combination of education and equivalent experience 9+ years of experience in testing ETL, Data, BI, and reporting applications 9+ years of experience in reporting/data visuali

  • ETL Test Lead

    1 month ago

    Calgary, Canada Atlantis IT Group Full time

    Bachelor’s Degree in computer science, information systems, business administration or other industry related curriculum) or combination of education and equivalent experience9+ years of experience in testing ETL, Data, BI, and reporting applications9+ years of experience in reporting/data visualization tools Tableau, and Business Objects9+ years of...

  • ETL Test Lead

    1 month ago

    Calgary, Canada Atlantis IT Group Full time

    Bachelor’s Degree in computer science, information systems, business administration or other industry related curriculum) or combination of education and equivalent experience 9+ years of experience in testing ETL, Data, BI, and reporting applications 9+ years of experience in reporting/data visualization tools Tableau, and Business Objects 9+ years of...

  • ETL Test Lead

    1 month ago

    Calgary, Canada Atlantis IT Group Full time

    Bachelor’s Degree in computer science, information systems, business administration or other industry related curriculum) or combination of education and equivalent experience9+ years of experience in testing ETL, Data, BI, and reporting applications9+ years of experience in reporting/data visualization tools Tableau, and Business Objects9+ years of...

  • Python Snowflake ETL Developer

    2 weeks ago

    Calgary, Alberta, Canada Synechron Full time

    Role: Python Snowflake ETL DeveloperLocation: Montreal, QC OR Mississauga, ON (hybrid/3 days in a week) from day oneFull time or contract hybrid – relocation assistance is provided. Must be in either Mississauga, ON or Montreal from day one.We are in search of a skilled Data and Warehouse Engineer proficient in Python, PySpark, SQL ETL Warehousing, and...

  • Applications Specialist

    4 weeks ago

    Calgary, Canada Designfusion Full time

    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. When we have a position open, we'll list the specific opportunity below. However, we are...

  • Applications Specialist

    4 weeks ago

    Calgary, Canada Designfusion Full time

    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. When we have a position open, we'll list the specific opportunity below. However, we are...

  • Aveva E3D Applications Specialist

    1 week 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...

  • Python Snowflake ETL Developer

    1 month ago

    Calgary, Canada Synechron Full time

    Role: Python Snowflake ETL DeveloperLocation: Montreal, QC OR Mississauga, ON (hybrid/3 days in a week) from day oneFull time or contract hybrid – relocation assistance is provided. Must be in either Mississauga, ON or Montreal from day one.We are looking for a Data and Warehouse Engineer with strong Python, PySpark, SQL ETL Warehousing and ideally some...

  • Python Snowflake ETL Developer

    1 month ago

    Calgary, Canada Synechron Full time

    Role: Python Snowflake ETL Developer Location: Montreal, QC OR Mississauga, ON (hybrid/3 days in a week) from day one Full time or contract hybrid – relocation assistance is provided. Must be in either Mississauga, ON or Montreal from day one. We are looking for a Data and Warehouse Engineer with strong Python, PySpark, SQL ETL Warehousing and ideally...

  • Python Snowflake ETL Developer

    1 month ago

    Calgary, Canada Synechron Full time

    Role: Python Snowflake ETL DeveloperLocation: Montreal, QC OR Mississauga, ON (hybrid/3 days in a week) from day oneFull time or contract hybrid – relocation assistance is provided. Must be in either Mississauga, ON or Montreal from day one.We are looking for a Data and Warehouse Engineer with strong Python, PySpark, SQL ETL Warehousing and ideally some...

  • Python Snowflake ETL Developer

    2 weeks ago

    Calgary, Alberta, Canada Synechron Full time

    Role: Python Snowflake ETL DeveloperLocation: Montreal, QC OR Mississauga, ON (hybrid/3 days in a week) from day oneFull time or contract hybrid – relocation assistance is provided. Must be in either Mississauga, ON or Montreal from day one.We are looking for a Data and Warehouse Engineer with strong Python, PySpark, SQL ETL Warehousing and ideally some...

  • Applications Specialist

    2 weeks 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 ‍...

  • Geospatial Solution Specialist

    2 weeks ago

    Calgary, Alberta, Canada CGI Full time

    Position Description: Ready to join an outstanding community of builders who are committed to diversity and inclusion, corporate social responsibility and encourages the freedom to innovate, influence decisions, and chart an exciting career? CGI is more than just an IT company. Be part of a team that supports the local community and has the ability draw...

  • Geospatial Solution Specialist

    4 weeks ago

    Calgary, Canada CGI Full time

    Position Description: Ready to join an outstanding community of builders who are committed to diversity and inclusion, corporate social responsibility and encourages the freedom to innovate, influence decisions, and chart an exciting career? CGI is more than just an IT company. Be part of a team that supports the local community and has the ability...

  • AVEVA E3D Applications Specialist

    4 weeks 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 delaysWhy We Do ItWe...

  • AVEVA E3D Applications Specialist

    4 weeks 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 delaysWhy We Do ItWe...

  • Senior ETL Quality Assurance Lead

    2 days ago

    Calgary, Canada Randstad Canada Full time

    We are looking for a seasoned Senior Quality Assurance (QA) Data Tester to join our Calgary logistics client on an initial 6-month contract. As a key member, you will leverage your expertise in ETL technologies, dashboard testing, and master data validation to ensure the integrity and reliability of our data warehouse and business intelligence reports,...

  • Python Snowflake ETL Developer

    4 weeks ago

    Calgary, AB, Canada Synechron Full time

    Role: Python Snowflake ETL DeveloperLocation: Montreal, QC OR Mississauga, ON (hybrid/3 days in a week) from day oneFull time or contract hybrid – relocation assistance is provided. Must be in either Mississauga, ON or Montreal from day one.We are looking for a Data and Warehouse Engineer with strong Python, PySpark, SQL ETL Warehousing and ideally some...