Job Information
Vista Projects Limited ETL Application Specialist in Calgary, Alberta
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 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 (https://www.vistaprojects.com/privacy/) , 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.
Powered by JazzHR