Log In
Sign Up
Your Opportunity:
The IT Technical Specialist (Data Architecture and Data Engineering) has key responsibilities to work with technical team members to plan and configure changes, resolve complex technical problems, design solutions and ensure reliable operation of information services and products. As an IT Technical Specialist, you play an essential role to ensure that deliverables meet both technical requirements and business needs. You create blueprints that ETL Developers and Data Engineers follow. Continuing professional development is your norm, and you keep up to date on information application technology and trends. You use effective communication and listening skills and know which audiences to use tech-speak or business language. This position is located in Calgary; Edmonton location and remote/hybrid will be considered.
Description:
The IT Technical Specialist is an expert in the data architecture and engineering area, has deep knowledge of data management, software engineering, and infrastructure and operations related to data warehousing, business intelligence, and analytics. The IT Technical Specialist works collaboratively with team members, IT colleagues, business clients and collaborators to manage diverse projects and operations. The successful candidate must balance work simultaneously on multiple projects and operational activities with changing priorities, make decisions and give clear and concise advice and recommendations. Job responsibilities: Modeling and designing data structures (data modeling), storage, and integration solutions. Leading database analysis, design, and build efforts while coaching and mentoring team members. Ensuring that the database designs fulfill the requirements, including data volume, frequency needs, and long-term data growth. Monitoring system performance by designing and implementing system health monitoring, performing regular tests, troubleshooting, and integrating new features. Recommending solutions to improve new and existing database systems. Educating staff members through training and individual support. Offering support and responding to system problems in a timely manner. Managing relationships with team members, peer IT groups, business clients and software vendor support.
- Classification: IT Application Srvcs Level 4
- Union: Exempt
- Unit and Program: Health Information Exchange
- Primary Location: Holy Cross Site Phase II
- Location Details: Eligible to work remotely within Alberta
- Negotiable Location: Provincial
- Employee Class: Regular Full Time
- FTE: 1.00
- Posting End Date: 17-JAN-2023
- Date Available: 19-JAN-2023
- Hours per Shift: 7.75
- Length of Shift in weeks: 2
- Shifts per cycle: 10
- Shift Pattern: Days
- Days Off: Saturday/Sunday
- Minimum Salary: $34.52
- Maximum Salary: $59.20
- Vehicle Requirement: Not Applicable
Required Qualifications:
Completion of bachelor’s degree in Computer Science or Information Technology or equivalent. Five years applying progressive knowledge and skill in data engineering, data integration, data warehousing, repositories, business intelligence and analytics; up to date with industry best practices, trends, tools, and methodologies. Experience with leading small teams of developers and administrators, coaching, mentoring and coordinating operations. Proven background of designing and implementing architectural solutions.
Additional Required Qualifications:
Technical skills: Strong technical understanding and hands on experience with relational and dimensional data modeling and architecture principles. Highly competent with structured query language (SQL) and T-SQL or PL/SQL. Deep knowledge of best practices through relevant experience across data-related disciplines and technologies, particularly for enterprise-wide data architectures, data management, data governance and data warehousing. Creating, tunning and operating ETLs/ELTs to handle data extraction from various data sources (in cloud and on-premises) and various formats. Strong Data Warehousing and Business Intelligence skills including scalability issues for enterprise level data warehouse. Proficient with data integration tools and languages such as Informatica PowerCenter, SSIS, and Python. Able to work in Linux, Windows, and cloud environments. Analytical skills – experience performing system, process, and data analysis; expert analysis of complex systems for problem solving/debugging technical, process or data failures/issues. Communication skills – well developed verbal and written communication skills; proven ability to interact in a team environment; able to write technical documentation and draw models and workflows; able to articulate issues and solutions and adjust tech-speak for audiences; routinely engages and collaborates to achieve consensus; and coordinates work of multiple developers and IT teams to achieve desired outcomes.
Preferred Qualifications:
A strong team player with conflict resolution and problem-solving skills. Actively builds and maintains positive relationships. Ability to work with business areas to understand business requirements and develop solutions. Strong technical background in Data Engineering (Data Management, Software engineering and Infrastructure and operations). Self-motivated, focused, independent and productive.
