JOBS

Data Solution Architect

Toronto (ON) Both (on-site & remote)
Opportunity Number: 2070614
Duration
Permanent
IndustrySpecialization
EducationArchitecture
LanguageSecurity Clearance
English verbal and writtenCriminal Check at time of placement
Start PeriodDate Posted
One to two weeksFriday, September 9, 2022
Job Description

Our large-scale education client is looking for a Data Solution Architect to join permanently join their team.

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 our client's growing learning records database, enriching the institutional data repository and powering the development of new learning analytics dashboards.

This is a permanent role that requires the Data Solution Architect to work onsite a minimum of 2-days per week at their office in Downtown Toronto (Bathurst & College). It will be a 7.5 hour day.

Roles and 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


Qualifications and Experience
  • 5+ years of IT experience in large scale technology architecture, operations and design-related disciplines
  • 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
  • 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 onexperience in big data technologies including Spark, Hadoop, Hive, HDFS, Python
  • 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
  • 8+ years experience in a similar role
  • Skills in the following areas; Data warehouse and data lake architecture principles
  • 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
  • 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 withlarge data sets as needed for data engineering, modeling and processing
  • Infrastructure orchestration using IaC principles and CI/CD pipelines
  • Ability to communicate highly technical and complex security concepts effectively across all levels of the organization (both IT and business)
Nice to have:

  • AWS/Azure Certified Solutions Architect Professional certification and/or other
  • AWS/Azure professional certifications

Apply Today

We’re an equal opportunities employer committed to increasing diversity and inclusion in today’s workforce. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status. Minorities, women, LGBTQ candidates, and individuals with disabilities are encouraged to apply. If you require an accommodation, please review our accessibility policy and reach out to our accessibility officer with any questions.
Merci de l’intérêt que vous manifestez pour ce poste. La description du poste nous a été fournie en anglais par notre client. Si vous souhaitez passer l’entrevue avec nous en français ou fournir votre CV en français, nous vous confierons à une personne de notre équipe qui parle français.

Opportunity Number: 2070614

Similar Jobs

Data Solution Architect

 Permanent

 Toronto

 One to two weeks

Technical Architect - Disaster Recovery Specialist!

 Contract

 Toronto

 ASAP

DevOps Architect /100% Remote

 Permanent

 Toronto

 One to two weeks