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.