Data Architect
- Classification: Senior Analyst
- Union: Exempt
- Unit and Program: Architecture Services
- Primary Location: Centre 70
- Location Details: As Per Location
- Negotiable Location: Provincial
- Employee Class: Regular Full Time
- FTE: 1.00
- Posting End Date: 07-SEP-2022
- Date Available: 17-SEP-2022
- Hours per Shift: 7.75
- Length of Shift in weeks: 2
- Shifts per cycle: 10
- Shift Pattern: Days
- Days Off: Saturday/Sunday
- Minimum Salary: $28.20
- Maximum Salary: $48.45
- Vehicle Requirement: Not Applicable
Working knowledge of on-premises ETL/ELT tools such as Informatica PowerCenter and Alteryx. Strong understanding of Cloud based data warehouse concepts like MPP, Data Migration, Ingestion, Concurrency, and Multiple Data Workloads - Snowflake, Data Bricks, etc. Experience in Cloud-based ELT/ETL tools – Informatica, Fivetran, Data Factory, etc. Excellent performance tuning skills related to Ingestion tasks, transformations, and reporting queries and procedures. Experience with job scheduling tools, and data pipeline management tools – Airflow, Argo, etc. Strong understanding of PL/SQL, SQL, and T-SQL. Relational database experience in Oracle and MS SQL Server. Platform: Windows/Linux. Strong Analytical & Problem-Solving Skills. Ability to use industry knowledge to relate to business requirements.
Additional Required Qualifications:
As required.
Preferred Qualifications:
Cloud training and/or certifications for Data Ingestion, Transformation, and Analytics. Preferably Snowflake.
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.
