Senior Data Solutions Architect with strong hands on technical experience to design, develop and implement enterprise big data solutions for a Major Educational Client
Job Type: Permanent
Positions to fill: 2
Start Date: Jul 01, 2022
Job End Date: Jul 01, 2022
Pay Rate: Salary: Negotiable
Job ID: 120764
Location: Toronto
Location: DT Toronto (Hybrid)
Duration: Full Time Opportunity
Role Description:
The Data Solutions Architect reports to the Manager of Application Administration within the ITS – Academic & Collaborative Technologies unit. The primary focus of this position is to provide technology and architectural leadership with respect to the design and delivery of enterprise-level big data solutions to support a variety of academic and research initiatives. The Data Solutions Architect will work in collaboration with business and technical stakeholders to build and implement data pipelines, data processing, data warehouse and analytics capabilities using cloud technologies. This role will ensure that technical solutions and environments are built reliably, optimized for scale, and meet enterprise security standards. The successful incumbent will act as an important contributor to strategies for managing the University’s growing learning records database, enriching the institutional data repository, and powering the development of
Responsibilities
About the Team:
The Enterprise Academic & Collaborative Technologies (ACT) group is a partnership between the Chief Information Officer’s (CIO) division and the Centre for Teaching Support & Innovation (CTSI).
ACT is a central department responsible for all matters pertaining to the development, operation, maintenance, and effectiveness of core teaching and learning systems and enterprise collaborative technologies at the University. Included within these responsibilities are the academic toolbox (the learning management system and associated applications), web hosting services (CMS), collaborative applications (i.e., MS Teams) and enterprise video-mediated applications, including the central video-conferencing bridge and support for mobile application development (via the MADLab). This responsibility includes vendor relationship management with both for-profit suppliers as well as non-profit and consortium partners. ACT also serves as the main connector between the CIO's portfolio and library technology services.
Your opportunity:
The Chief Information Officer (CIO) portfolio, operating as Information Technology Services (ITS), is home to over 200 IT professionals who provide University-wide IT services and systems to enable the University to maintain its status as Canada’s leading institution of learning, discovery and knowledge creation. From direct support to enterprise-grade academic and administrative applications (student, financial, HR and research) to online learning, information security, collaboration tools and network infrastructure, our work enables the Universities steadfast commitment to being an internationally significant research university with excellent undergraduate, graduate and professional programs.
ITS provides leadership and undertakes strategic and tactical initiatives to secure the greatest value from the University’s investment in IT. By strategically focusing on our people and working in collaboration with academic administrators, process owners and distributed IT service providers, ITS identifies technology opportunities and inefficiencies, and implements services and technology solutions to reduce complexity and improve aggregate IT experience of students, faculty and staff.
We are excited about the future as we focus our efforts, with broad input from our community, on the development and execution of the IT strategic plan. We live our core values which shape our culture and guide our efforts – they include service and operational excellence, creativity and critical thinking, culture of learning, shared leadership, and teamwork.
Duration: Full Time Opportunity
Role Description:
The Data Solutions Architect reports to the Manager of Application Administration within the ITS – Academic & Collaborative Technologies unit. The primary focus of this position is to provide technology and architectural leadership with respect to the design and delivery of enterprise-level big data solutions to support a variety of academic and research initiatives. The Data Solutions Architect will work in collaboration with business and technical stakeholders to build and implement data pipelines, data processing, data warehouse and analytics capabilities using cloud technologies. This role will ensure that technical solutions and environments are built reliably, optimized for scale, and meet enterprise security standards. The successful incumbent will act as an important contributor to strategies for managing the University’s growing learning records database, enriching the institutional data repository, and powering the development of
Responsibilities
- Developing and updating architectural framework for highly complex and confidential university-wide IT systems
- Reconciling business requirements with information architecture needs for highly complex system integration
- Conducting data modelling for business system analysis
- Analyzing and recommending suitability of major new equipment or software systems
- Analyzing and configuring highly complex enterprise applications and services
- Designing, testing, and modifying programming code
- Planning and implementing IT systems independently
- Advising on cost, feasibility, and impact of different implementation solutions
- 8+ years experience as a Data Solutions Architect
- 3+ years of experience as a Data Architect/Data Engineer with a demonstrated strength in data modeling, ETL development and data warehousing to design, develop and implement enterprise big data solutions
- 5+ years of IT experience in large scale technology architecture, operations, and design-related disciplines
- Strong experience in Data warehouse and data lake architecture principles
- 3+ years of experience with SQL and managing large data sets using relational databases (MySQL, SQL Server, PostgreSQL, etc.)
- 3+ years of concrete programming and scripting language experience (e.g. Python, Java) with understanding of SDLC principles
- Practical experience using data visualization and business intelligence tools (e.g., Tableau, Power BI) to analyze data
- In-depth working experience using AWS and Azure platform services including:
- AWS Glue, AWS Athena, AWS SQS, AWS Kinesis, AWS Redshift, AWS EMR, AWS S3, Azure Data Lake, Azure Databricks and Azure Synapse Analytics
- Hands on experience in big data technologies including Spark, Hadoop, Hive, HDFS, Python
- Interacting with middleware (API gateways)
- Data modeling for data warehousing/analysis (Denormalized – Star & Snowflake Schemas, Data Vault)
- Writing complex, highly optimized SQL and Python to interact with large data sets as needed for data engineering, modeling and processing
- Infrastructure orchestration using IaC principles and CI/CD pipelines
- Business information requirement analysis experience with a strong understanding of project management principles
- Solid experience with data privacy and security practices, metadata management, data governance and access controls within an enterprise data management framework
- Data integration and streaming integration concepts and architecture
- Data ETL pipelines for large-scale transformations, conversion and partitioning
- Business intelligence, query, and reporting/analytics tools
- Techniques for detecting and addressing data quality issues
- Bachelor's Degree or acceptable combination of equivalent experience.
- AWS/Azure Certified Solutions Architect Professional certification and/or other AWS/Azure professional certifications
- Ability to communicate highly technical and complex security concepts effectively across all levels of the organization (both IT and business)
- Communicator
- Cooperative
- Motivated self-learner
- Procedural
- Resourceful
- Team player
About the Team:
The Enterprise Academic & Collaborative Technologies (ACT) group is a partnership between the Chief Information Officer’s (CIO) division and the Centre for Teaching Support & Innovation (CTSI).
ACT is a central department responsible for all matters pertaining to the development, operation, maintenance, and effectiveness of core teaching and learning systems and enterprise collaborative technologies at the University. Included within these responsibilities are the academic toolbox (the learning management system and associated applications), web hosting services (CMS), collaborative applications (i.e., MS Teams) and enterprise video-mediated applications, including the central video-conferencing bridge and support for mobile application development (via the MADLab). This responsibility includes vendor relationship management with both for-profit suppliers as well as non-profit and consortium partners. ACT also serves as the main connector between the CIO's portfolio and library technology services.
Your opportunity:
The Chief Information Officer (CIO) portfolio, operating as Information Technology Services (ITS), is home to over 200 IT professionals who provide University-wide IT services and systems to enable the University to maintain its status as Canada’s leading institution of learning, discovery and knowledge creation. From direct support to enterprise-grade academic and administrative applications (student, financial, HR and research) to online learning, information security, collaboration tools and network infrastructure, our work enables the Universities steadfast commitment to being an internationally significant research university with excellent undergraduate, graduate and professional programs.
ITS provides leadership and undertakes strategic and tactical initiatives to secure the greatest value from the University’s investment in IT. By strategically focusing on our people and working in collaboration with academic administrators, process owners and distributed IT service providers, ITS identifies technology opportunities and inefficiencies, and implements services and technology solutions to reduce complexity and improve aggregate IT experience of students, faculty and staff.
We are excited about the future as we focus our efforts, with broad input from our community, on the development and execution of the IT strategic plan. We live our core values which shape our culture and guide our efforts – they include service and operational excellence, creativity and critical thinking, culture of learning, shared leadership, and teamwork.
