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