Sql analyst Jobs in North York, ON

Teranet is currently looking for a Data Analyst for a six-month fixed-term opportunity. You will be accountable for the delivery of data and data products to customers, including performing data quality and coverage reviews, investigating discrepancies, and supporting customer inquiries related to data deliveries.

This is a great opportunity to build and develop your data analytics experience while interacting with key internal and external stakeholders as part of a bright and dynamic Data Solutions and Delivery team.

What You’ll Be Doing

Data Delivery (50%)

• Review customer contracts and requirements to understand the scope of deliverables

• Retrieve data from various sources, including relational databases, files and data lakes

• Perform data manipulations using SQL or Excel

• Validate deliverables for completeness, accuracy and consistency prior to release

• Package data and data products for delivery

• Transfer data and data products to customers using secure file transfer or other approved delivery tools

• Provide billing support to Finance partners

• Create and maintain documentation for data delivery processes and procedures

Data Quality (30%)

• Review data quality and coverage against predefined quality measures

• Identify and investigate data inconsistencies, gaps and other quality issues

• Analyze data from multiple sources to validate accuracy, completeness and coverage

• Perform data fixes using SQL or Excel

• Extract data from various sources, including paper records, scanned documents, websites and databases

• Research and obtain data from additional sources, including open-data sources

Customer Support (20%)

• Provide front-line support for customer inquiries and requests

• Troubleshoot and resolve customer issues related to data deliveries and data products

• Coordinate required setup and administrative activities for customer accounts

• Communicate with customers and internal partners regarding data deliveries, requirements and issues

• Coordinate with internal teams as needed to investigate and resolve customer issues

• Create and maintain documentation for support processes and procedures

About You

• Bachelor’s degree in a relevant field, or equivalent combination of education and experience

• Minimum of 2 years of relevant experience in data analysis, data operations or a related role

• Proficiency in SQL, Excel and Access

• Strong attention to detail with the ability to identify and investigate data inconsistencies

• Strong problem-solving and analytical skills

• Strong organizational and communication skills, with the ability to manage recurring deliverables and work effectively with internal and external stakeholders

• Exposure to Python, Tableau or other data and reporting tools is considered an asset

Let’s Talk Pay

We believe in being upfront about pay and helping you make informed decisions about your career. The hourly range for this role is $32.00-$38.00/hr. We understand that great talent comes in many forms, each with unique skills, experience, and potential. Your hourly rate will be tailored to reflect the experience you bring and the impact you’re ready to have on this role.

Our Human Approach to Hiring

At Teranet, we use smart technology to make hiring faster and more efficient. Artificial Intelligence (AI) tools help us review applications and identify strong matches—but the real decisions? Those are made by our awesome people. Every interaction you’ll have, and every decision we make, is led by humans. AI may support us, but it’s human connection that drives every hire.

At Teranet, we are committed to fostering an inclusive, accessible environment, where all employees and customers feel valued, respected, and supported. We are dedicated to building a workforce that reflects the diversity of our customers and the communities in which we live and serve. If you require accommodation during the recruitment and selection process, please let us know and we will work with you to meet your needs.

Come As You Are. We Like You That Way!