logo

View all jobs

SQL developer and QA analyst - 18247

Toronto, ON
Join our team
Join the Procurement Analytics Center of Excellence (PACE), and support our
mission to transform the chief procurement office (CPO) to a fully digital organization where data is at the heart of every decision we make.

We are an advanced data and software development team thriving on solving business problems and supporting procurement decisions using the power of data, advanced analytics, and reliable software. We provide end to end support from strategy and development to deployment and monitoring of all assets, including machine learning model, Tableau dashboards and data engineering ETLs using cutting edge Cloud technologies (e.g., Google BigQuery and GCP AI Platform), open source tools (e.g., Python, Sklearn, NLTK, Tensorflow), and enterprise products (e.g., Tableau, GitHub, Terraform).

In achieving our goal to enable data-driven decision making in CPO, PACE team is looking for an experienced SQL developer and quality assurance analyst who is able to regularly engage and interact with our data scientists and engineers to transform data, perform regular and automated data quality assessments and identify opportunities to improve data quality to ensure data is useful and reliable around the clock.

What you’ll do:
As an experienced Data Analyst in the PACE, you will be closely working with seasoned data scientists and engineers and support them by developing SQL queries that transform raw data into desirable format which is ready for reporting or analytics. You regularly perform quality assurance and UAT with business to ensure data is reliable and has the highest possible quality so people can trust the data at all the time. You will be driving a lot of innovation in automating data quality assurance and reporting/flagging any data issue. You have the opportunity to provide data quality feed to our engineers and scientists to change in the way we extract, process, and ingest data in Google Cloud Platform. This is a very exciting opportunity indeed!

Work closely with business stakeholders to learn about data issues and insight gaps and take action to fill the gap.
Work with data engineers and scientists within PACE and develop SQL scripts for reporting, storytelling, and insight generation.
Proactively looking at opportunities to blend data from across different enterprise systems to generate actionable insights that drive business value.
Leverage innovative technologies and rigorous methods to extract, analyze, evaluate and interpret complex, multi-dimensional and constantly changing data.
Question the status-quo and old processes, challenge assumptions, and advocate for high quality data that enables data-driven decision making.
Influence PACE strategy and priorities while collaborating with other PACE team members to enable, design, develop, and deploy both data and quality assurance solutions.
Continuously push the data quality boundaries towards 100% data quality and availability.
Regularly explore open source communities and 3rd party tools to inject data quality processes and tools in our automated data ingestion and processing pipeline

Must have skills:   
1. · Minimum 3-5 years of experience developing intermediate to advanced SQL queries
2. · Minimum 1-3 years of experience with Python for data science
3. · Minimum 3-5 years of experience performing data analysis and data quality
4. · Intermediate to advanced knowledge of testing software/data systems, including regression, unit, integration, and user acceptance testing
5. · Prior experience with Agile and Jira
6. · Familiarity with GitHub and CD/CI
 
Nice to have skills:  
1. **** Knowledge and experience with SAP S4 HANA, SAP ECC is a big asset*** (this skill would be a benefit to candidates with lower Python experience)
2. Knowledge and experience with Google Cloud Platform (GCP), including Google BigQuery and AI Notebook
3. · Familiar with software development methodologies and best practices
4. · Experience in ML model production deployment and monitoring

Who you are:
· Hold bachelor or master with major in data science, computer science, or applied mathematics (or related quantitative disciplines)
· Minimum 3-5 years of experience developing intermediate to advanced SQL queries
· Minimum 1-3 years of experience with Python for data science
· Minimum 3-5 years of experience performing data analysis and data quality
· Intermediate to advanced knowledge of testing software/data systems, including regression, unit, integration, and user acceptance testing
· Prior experience with Agile and Jira
· Familiarity with GitHub and CD/CI
· Excellent communication and presentation skills
· Team player
Great-to-have:
· Knowledge and experience with Google Cloud Platform (GCP), including Google BigQuery and AI Notebook
· Knowledge and experience with SAP S4 HANA, SAP ECC is a big asset
· Familiar with software development methodologies and best practices
· Experience in ML model production deployment and monitoring

More Openings

Helpdesk Level 2 Support
System Admin
Deployment Supervisor

Share This Job

Powered by