IT Analyst II – Data Integration Developer

Job title: IT Analyst II – Data Integration Developer

Company: Alberta Health Services

Job description: Your Opportunity:

We are looking for a self-motivated, focused, productive and well-organized individual wanting to be part of an information-as-an-asset Analytics and BI program. The ideal candidate aspires to help others access and use data and information, as well as progressing their data management skills in a broad variety of initiatives aimed at informational value. The DI (Data Integration) Developer is responsible for acquiring, processing, managing, and sharing data. The position develops ETL, ELT and data integration processes including defining source and target and creating mappings, sessions, and workflows for operations and projects. The role is responsible for accessing, integrating, and making available multiple disparate data sources using data integration and modeling tools to design, model, estimate, plan, map, connect, integrate and cleanse data for analysis and reporting. This developer can define, produce, receive, test, and stage data extracts according to diverse requirements, when on-prem, in the cloud, or a hybrid. The incumbent ensures continuous improvement, enhancement, and support of data warehouse, repository, and BI environments, applications, and tools. The position utilizes agile, project, and service management methodology, applies change management; writes technical and business documentation; and works closely with other developers and analysts, subject matter experts, vendor support, and IT technical and clinical services peers with an information outcomes focus. This position is located in Calgary; Edmonton locations will be considered. Description:

As an IT Analyst II, you will provide technical support related to information technology applications either directly to users of the systems or to service delivery functions. You will ensure reliable operations of information systems, resolve complex technical problems, find solutions to customer needs, and lead projects and program initiatives. You will be responsible for more advanced application, telecom or technology support duties. You will investigate, diagnose, and resolve complex problems that have typically been escalated several levels before assignment to this position, and will translate business requirements into technical requirements for a solution and recommend a potential approach to the vendor. You will analyse the solution provided to ensure that it fits both technical requirements and business needs. You will also spend time on project or initiative leadership and delivery.

• Classification:

IT Analyst II * Union:
AUPE GSS * Department:
(CORP) IT Enterprise Anal & BI * Primary Location:
QuarryPark * Multi-Site:
Not Applicable * FTE:
1.00 * Posting End Date:
26-JAN-2021 * Employee Class:
Regular Full Time * Date Available:
01-MAR-2021 * Hours per Shift:
7.75 * Length of Shift in weeks:
2 * Shifts per cycle:
10 * Shift Pattern:
Days * Days Off:
Saturday/Sunday * Minimum Salary:
$37.31 * Maximum Salary:
$50.38 * Vehicle Requirement:
Not Applicable

Required Qualifications:

Completion of bachelor’s degree in Computer Science or Information Technology or equivalent.

Additional Required Qualifications:

Experience – 3 to 5 years applying progressive knowledge and experience in data integration, warehousing, repositories, business intelligence and analytics; commensurate professional development and continuous professional training in industry best practices, tools, and methodologies. Technical skills – proficient with multiple SQL Server business intelligence tools and data integration tools using Informatica PowerCenter, Visual Studio/SSIS etc. with related competencies in metadata management and data quality using Data Quality Services; advanced SQL programming; able to work in UNIX/Linux and Windows; proficient data and information architecture skills including relational and dimensional data modeling using Visio, PowerDesigner, Toad etc.; and experience mapping and connecting multiple large disparate data sources into common data structures. Analytical skills -able to deconstruct multiple complex data structures and processes and innovate data solutions; experience performing system and data analysis; able to produce reports and visualizations, and experience understanding business requirements and translating into technical implementations. Communication skills – well developed oral and written communication skills with proven ability to estimate, plan, and interact in a team environment; able to write technical and business documentation and draw diagrams; and able to articulate issues and solutions and engage and collaborate to achieve consensus with others.

Preferred Qualifications:

Prefer certification in ITIL Foundations, relevant tool-based training tied to hands-on experience, and skills in machine learning using Python, data virtualization using PolyBase, and cloud-based tasks using Azure, and use of Scrum, DevOps, and BusOps frameworks.

Expected salary:

Location: Calgary, AB

Job date: Thu, 21 Jan 2021 23:45:00 GMT