ETL Developer

Calgary, AB, Canada
Full Time
EDS
Mid Level

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 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
  • Automating manual tasks
  • 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 with web languages (HTML 5/CSS, JavaScript) and scripting (PowerShell, command line interface, Python)
  • 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 12 to 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 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 an offer.

Share

Apply for this position

Required*
Apply with Indeed
We've received your resume. Click here to update it.
Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

150