University of Alberta

Senior Solutions Architect

Strategic Analysis

Competition No.  -    S106933788
Posting Date  -    Aug 31, 2017
Closing Date  -    Sep 25, 2017
Position Type  -    Full Time - Operating Funded
Salary Range  -    $80,090 to $114,246 per year
Grade  -    14
Hours  -    35

This position offers a comprehensive benefits package which can be viewed at:  

Reporting to the Associate Director, Strategic Analysis and Data Warehousing (SADW), the Senior Data Architect will develop a detailed knowledge of the underlying data and data products and serve as the subject matter expert on context and content, leveraging of data for information products to service institutional requirements and provides support and management of quality assurance processes related to, but not limited to, extract transform loads, artifact migrations, data and information quality. This position requires someone who is a hands-on analyst, technologist and architect, who has extensive experience in data and information management, data warehousing and analytics technologies, and who is an exceptional SQL programmer. These skills are required to provide SADW with tactical and strategic direction in solutions architecture, modeling and processes; with an emphasis on data quality assurance and consistency context and content across platforms and products.

This position will supervise at least one full-time analyst, and will also require working collaboratively with other SADW staff (for example training, coaching and mentoring programmers and analysts). The successful candidate will exhibit superior communication skills, including the ability to understand users’ business requirements and translate these to technical solutions.

SADW is a fast-paced dynamic work environment where the ability to respond quickly, clearly and with accuracy is paramount. Therefore, the successful candidate will be accountable to respond to analytical requests as well, drawing upon the data warehouse and understanding of the business of the University. This is a unique position, as there are currently no other data architecture roles within the University of Alberta, so the successful candidate will also require initiative and the ability to think creatively and independently.


  • Consults, conveys and translates data requirements into logical, physical and semantic layer models across the analytical data environment
  • Provides leadership in establishing analytic environments required for structured, semi-structured and unstructured data
  • Creates a product architecture roadmap that maintains the integrity, flexibility and longevity of SADW’s data practice and satisfies the business need to fast value delivery
  • Recommends and conducts data architecture and design, implementation, testing and maintenance processes for complex data implementations; troubleshoots related issues, following architectural best practices and appropriate business rules
  • Develops and implements database solutions to store and retrieve information
  • Profiles and analyzes source system data to determine data relationships, design framework, consistency and quality and integration points within the data warehouse
  • Develops, administers and enforces data integrity and quality across data access points
  • Enables and leads analytics user community in the understanding, location and selection of appropriate data sources to achieve key business goals
  • Creates and maintains critical data documentation and metadata, enabling people to understand and leverage data as a shared asset
  • Provides guidance and sets standards for the data warehouse data architecture and business process model for artifact migrations
  • Works with senior research systems analysts and database administrators to improve data strategy, quality and governance
  • Works closely with business and external users to quickly deliver high-quality information products
  • Works collaboratively with stakeholders to drive the adoption of solutions
  • Conducts complex analyses and prepare formal results using existing DW tools
  • Participates in business intelligence projects to ensure implementation using both Agile and Waterfall methods
  • Mentors and provides timely feedback and performance assessments to direct report(s)


  • Minimum Bachelor’s Degree in a technology area of study, preferably in Computer Science, Information Sciences or Analytics; Masters preferred; equivalent combinations of education and experience will be considered
  • Minimum 5 years of experience in a structured IT environment with a variety of methodologies, and strong technical environment management disciplines
  • Experience with applied advanced data integrity, quality assurance and process improvements to DW ETL processes and integration points using industry standard tools and methodologies
  • Holistic understanding of the components of an analytic architecture; and how to implement
  • Experience in developing conceptual and reference architecture, processes and standards
  • Leveraged database, analytical, statistical and reporting tools to extract and/or build data and information artifacts e.g. SQL, SQR, Excel, Access, Tableau, etc.
  • Experience with DB platforms from Microsoft and Oracle with specific focus on SQL/PSQL programming
  • Exceptional programming skills in MS SQL
  • Advanced knowledge of Relational Database Design, Dimensional Database Design, Star or Snowflake schema
  • Professionalism in conduct of consultation, collaboration and facilitation with peers and leaders
  • Strong communication (verbal and written), analytical, problem solving, work and project management skills
  • Strong understanding of higher education issues, particularly those involving students, faculty, human resources and financials, with systematic periodic research in selected websites and journals

How to Apply

Apply Online

Note: Online applications are accepted until midnight Mountain Standard Time of the closing date.

We thank all applicants for their interest; however, only those individuals selected for an interview will be contacted.

The University of Alberta is committed to an equitable, diverse, and inclusive workforce. We welcome applications from all qualified persons. We encourage women; First Nations, Métis and Inuit persons; members of visible minority groups; persons with disabilities; persons of any sexual orientation or gender identity and expression; and all those who may contribute to the further diversification of ideas and the University to apply.