*This is a legacy provincial website of the ATA. Visit our new website here

Junior Data Solutions Analyst

Permanent Full-Time Position

The Alberta Teachers' Association (ATA) is proud to be one of Alberta’s Top Employers for 2022. As the professional organization of teachers, the ATA promotes and advances public education, safeguards standards of professional practice and serves as the advocate for its members.

Reporting to Team Lead, Solutions Architecture, the Junior Data Solutions Analyst works in a team to develop and maintain cloud infrastructure and web-based solutions to meet the business needs of the Association and its’ members. Specific responsibilities include: 

  • Expand reporting/analytics capabilities by creating or enhancing reports (such as Power BI, Excel, SSRS) and report data sources
  • Develop visual reports, dashboards, and KPI scorecards and communicate these to key stakeholders to support business goals and initiatives
  • Implement reporting/analytics end user tools and cloud/on-premises backend infrastructure that enhance the Associations’ reporting and analysis capabilities
  • Configure and manage Azure data and related infrastructure
  • Support the migration of on-premises data assets to the cloud
  • Use SQL Server and Azure SQL to monitor and optimize the performance of database instances
  • Respond to and resolve database access, uptime, and performance issues; and
  • Support the design, development and maintenance of data driven projects as required 

Formal educational requirements

  • Certificate or diploma in computing technology or a related field. 
  • A Bachelor’s degree in computer science, information technology or a related field is an asset.
  • Being a Microsoft Certified Solutions Expert and having cloud-related certification are assets. 

Software experience in one or more of the following:

  • Experience with Microsoft SQL Server database administration or similar 
  • Experience managing and supporting database environments hosted in Microsoft Azure 
  • Experience building/configuring Azure infrastructure (SaaS, PaaS and IaaS) 
  • Experience writing and optimizing SQL queries using TSQL
  • Experience building and maintaining reports with SSRS and/or Power BI 

Familiarity with Microsoft development tools 

  • SQL Server and Power BI security features and how to administer them
  • Microsoft BI Stack 

Ability to 

  • Effectively prioritize and execute tasks to meet project timelines
  • Work in a team-oriented, collaborative environment 

Salary: This position offers a competitive starting salary of $66,764 to a maximum of $84,157 depending on experience, plus a full range of employer-paid benefits.

Hours of Work: 35 hours per week, Monday to Friday.

Work Location: Barnett House (11010 142 Street NW), Edmonton.

Note: The ATA is a values diversity, inclusion and provides professional development and on-site career growth to all staff. In addition to the salary scale listed above, opportunities exist for successful candidates to grow with our ITS Team into higher paid positions. We offer a great working environment, an in-house cafeteria, free parking, and above average benefits. 

HOW TO APPLY: Submit a cover letter and resume in one attachment along with the names and telephone numbers of two business references should be addressed to Connor Poon, HR Administrator and emailed to HR@ata.ab.ca. This posting will remain active until the position has been filled.

The Alberta Teachers’ Association thanks all applicants for their interest, however only those candidates selected for an interview will be contacted.