Back


Job Detail

Data Solutions Engineer

Altis Recruitment

Toronto, Ontario

Data Solutions Engineer

Altis Recruitment

Toronto, Ontario
 
Salary: From 100,000 to 130,000 per Year
 
County: 39
 
One of our largescale education clients in Toronto is actively looking for a Data Solutions Engineer / Data Architect. 

The Data Solutions Engineer reports to the Senior Manager, Academic Applications & Analytics. The primary focus of this position is to serve as the technical lead for the design and implementation of enterprise-level data solutions that enable data extraction, transformation, and modelling in support of a variety of academic, operations and research initiatives. This role will ensure that technical solutions and architectures are built reliably, are optimized for scale and meet enterprise security standards. The successful incumbent will act as an important contributor to strategies for managing the client's growing learning records store, enriching the institutional data repository, and powering the development of new learning analytics dashboards.

Your responsibilities will include:

  • Developing and implementing architectural framework for highly complex and confidential university-wide IT system
  • Reconciling business requirements with information architecture needs for highly complex system integration
  • Conducting data modelling for business system analysis
  • Advising on data structure designs
  • Analyzing and configuring highly complex enterprise applications and services
  • Developing, testing, and modifying programming code
  • Planning, implementing and operating IT systems independently
  • Advising on cost, feasibility and impact of different implementation solutions

Essential Qualifications:

  • Bachelor's Degree or acceptable combination of equivalent experience.
  • 8+ years of experience as a Data Architect/Data Engineer with a demonstrated ability in data modelling, ETL pipelines, data integration and data architecture to design, develop and implement enterprise big data solutions
  • 5+ years of experience in large scale technology architecture, operations and design-related disciplines
  • 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
  • Strong understanding and experience implementing Azure and AWS cloud computing concepts, architectures, and services. This includes but is not limited to AWS S3, AWS Lambda, AWS Glue, AWS Athena, AWS SQS, AWS Kinesis, AWS Redshift, AWS EMR, AWS ECS, Azure Data Factory, Azure Data Lake Analytics, Azure Databricks and Azure Synapse Analytics
  • Knowledge and experience building CI/CD pipelines using tools such as Jenkins, AWS Developer Tools and Azure DevOps to automate testing, building, and deploying infrastructure and application code using IaC practices.
  • Hands on experience with 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
  • Expert level skill with SQL
  • Building ETL pipelines for large-scale data extraction, transformation, and partitioning
  • Expert data modelling and database design skills (both dimensional and relational)
  • Proficient with business intelligence and reporting/analytics tools (e.g. Tableau, PowerBI) to analyze data
  • Techniques for detecting and addressing data quality issues
  • Interacting with middleware (API gateways)
  • Writing complex, highly optimized SQL, and Python to interact with large data sets as needed for data engineering, modeling and processing
  • Excellent analytical and problem resolution skills
  • Excellent written and verbal communications skills at both a technical and business level, able to build and foster positive relationships with highly dispersed and dynamic teams

Assets (Nonessential): AWS/Azure Certified Solutions Architect. Professional certification and/or other AWS/Azure professional certifications.

To be successful in this role you will be:

  • Communicator
  • Cooperative
  • Motivated self-learner
  • Procedural
  • Resourceful
  • Team player
Salary Range: $100,000 to $130,000

We’re an equal opportunity 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.

 

We are committed to hiring military and Veteran spouses and encourage you to identify your connection with the MSEN when reaching out to us or applying to any of our open roles.

 

Have questions or want to learn more about us? We would love to hear from you!

 Altis Recruitment Team

Email: militaryfamilies@altis.com

613-230-3700

 

 

About Altis Recruitment

Welcome on behalf on the Altis Recruitment team! Altis has a long-standing business relationship with the Defence community. For more than 30 years, we have been grateful to work alongside the Department of National Defence and countless military professionals. We know that family members of military personnel often make many personal sacrifices to support their loved ones. We understand that it can be difficult to pursue a career when embracing sudden changes like relocation and deployment. For some, this has meant putting a pause on career goals or professional development. We would like to provide you with everything you need for a successful and confident job search – in addition to access to job opportunities. Download the checklists our experts have created to help you be at your best from application to interview.