Data Analyst

ERIS is a leading provider of environmental risk data and insights across North America. They are seeking a Data Analyst to support the collection, maintenance, and updating of databases, ensuring data accuracy and integrity across multiple sources.

Responsibilities

• Research, collect, and download environmental risk data from regulatory agencies, remediation programs, and other sources
• Write SQL queries to verify data completeness, accuracy, and integrity
• Develop and execute SQL ETL scripts to extract, transform, and load data from various source formats into Oracle databases
• Perform data compilation, conversion, cleansing, validation, and string manipulation activities
• Analyze and structure data, including determining appropriate table normalization and data models
• Conduct address cleaning, geocoding, and coordinate conversion using proprietary tools
• Monitor and maintain data quality standards across multiple datasets
• Investigate and resolve data discrepancies and anomalies
• Assist with environmental risk data projects and other data-related initiatives as required
• Communicate findings, issues, and recommendations clearly to stakeholders, providing regular project and status updates
• Support continuous improvement efforts related to data acquisition, processing, and quality assurance

Skills

• Recent completion of a degree or diploma in Computer Science, Geomatics/GIS, Environmental Science, Environmental Engineering, or a related field
• Experience compiling, transforming, and manipulating data from various file formats, including .csv, .txt, .xlsx, and .xml
• Understanding of SQL and relational database concepts
• Strong analytical and problem-solving skills with the ability to identify and resolve data issues efficiently
• Excellent attention to detail and commitment to data accuracy and integrity
• Strong organizational skills with the ability to manage multiple priorities and meet deadlines in a fast-paced environment
• Excellent collaboration and interpersonal skills, with the ability to work effectively within cross-functional teams
• Strong written and verbal communication skills, including the ability to communicate information clearly, concisely, and effectively
• Quick learner with a proactive attitude and a willingness to develop new technical and business knowledge
• Working knowledge of, or a strong interest in learning, geography, GIS, and spatial data concepts is considered an asset
• Experience with scripting, automation, or process improvement tools is considered an asset

Benefits

• Extended health benefits
• Pension
• Flexible workplaces and schedules

Company Overview