Data Analyst

Teranet Inc; Toronto; On-site; CAD 44,000 - 52,000; Full time

Job summary

Teranet Inc. is seeking a Data Analyst for a six-month fixed-term opportunity to deliver data products and support customers. You will perform data quality reviews, data retrieval from databases and data lakes, and respond to inquiries.

You will work with SQL, Excel and Access, and interact with internal and external stakeholders to ensure accurate data deliveries and documentation.

Qualifications

• 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.

Responsibilities

• 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.
• 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.
• 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.

Skills

SQL

Excel

Access

Python

Tableau

Education

Bachelor’s degree

Job description

Data Analyst (Fixed Term)Who We AreTeranet is Canada’s leader in the delivery and transformation of statutory registry services with extensive expertise in land and commercial registries. We also market insightful property and data solutions, as well as practice management automation to thousands of customers in real estate, financial services, government, utilities, and legal markets.Connect. Grow. Thrive Together.To learn more about who we are, visit our website: www.teranet.caAbout the RoleTeranet 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 DoingData Delivery (50%)Review customer contracts and requirements to understand the scope of deliverablesRetrieve data from various sources, including relational databases, files and data lakesPerform data manipulations using SQL or ExcelValidate deliverables for completeness, accuracy and consistency prior to releasePackage data and data products for deliveryTransfer data and data products to customers using secure file transfer or other approved delivery toolsProvide billing support to Finance partnersCreate and maintain documentation for data delivery processes and proceduresData Quality (30%)Review data quality and coverage against predefined quality measuresIdentify and investigate data inconsistencies, gaps and other quality issuesAnalyze data from multiple sources to validate accuracy, completeness and coveragePerform data fixes using SQL or ExcelExtract data from various sources, including paper records, scanned documents, websites and databasesResearch and obtain data from additional sources, including open-data sourcesCustomer Support (20%)Provide front-line support for customer inquiries and requestsTroubleshoot and resolve customer issues related to data deliveries and data productsCoordinate required setup and administrative activities for customer accountsCommunicate with customers and internal partners regarding data deliveries, requirements and issuesCoordinate with internal teams as needed to investigate and resolve customer issuesCreate and maintain documentation for support processes and proceduresAbout YouBachelor’s degree in a relevant field, or equivalent combination of education and experienceMinimum of 2 years of relevant experience in data analysis, data operations or a related roleProficiency in SQL, Excel and AccessStrong attention to detail with the ability to identify and investigate data inconsistenciesStrong problem-solving and analytical skillsStrong organizational and communication skills, with the ability to manage recurring deliverables and work effectively with internal and external stakeholdersExposure to Python, Tableau or other data and reporting tools is considered an assetLet’s Talk PayWe 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 HiringAt 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!