IT Analyst II - Extract, Transform and Load Developer
- Classification: IT Analyst II
- Union: AUPE GSS
- Department: (CORP) IT Enterprise Anal & BI
- Primary Location: Holy Cross Site Phase II
- 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
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 warehousing and business intelligence, commensurate professional development in data integration, and continuous professional training in industry best practices, tools, and methodologies. Technical skills – proficient with multiple 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 and SSMS skills; 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 high volume disparate data sources across mixed environments and platforms into common data structures. Analytical skills -able to deconstruct multiple complex data structures and processes and innovate data solutions using Scrum, DevOps, and BusOps development methods; experience performing system and data analysis; and experience understanding business requirements and translating into technical implementations. Communication skills - well understood oral and written communication skills with proven ability to estimate, plan, and interact in a team environment; able to write technical documentation and diagram workflows; 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.
Please note:
All postings close at 23:59 MT of the posting end date indicated.
Security Screening:
A satisfactory criminal record check and/or Vulnerable Sector Search is required prior to your first day of work. Additionally, all employees have an ongoing duty to disclose any charges or convictions that may occur during their employment with AHS.
Healthy Albertans. Healthy
Communities. Together.
We’re passionate about what we do. Our team of skilled and dedicated health care professionals, support staff, and physicians promote wellness and provide health care every day, all across Alberta.
Everything we do at AHS reflects a patient and family centred approach; it’s about putting patients’ and families’ experiences, priorities and trust first.
We are an equal opportunity employer. AHS values the diversity of the people and communities we serve and is committed to attracting, engaging and developing a diverse and inclusive workforce.
