ERIS has an immediate entry-level opportunity for a Data Analyst to assist in the collection, loading and updating of ERIS’ databases. This is a full-time position, working 35 hours per week in our Toronto office.
Specific Responsibilities & Daily Tasks:
- Researching, collecting and downloading environmental risk data
- Writing SQL queries to verify the completeness and integrity of data
- Writing SQL load scripts to extract, transform load (ETL) data from various formats into Oracle
- Executing other data activities such as data compilation, data conversion, data cleaning, string manipulation
- Address cleaning, geocoding, and coordinate conversion using custom software
- Assisting with other environmental risk data-related tasks as required
Knowledge & Educational Requirements:
- Degree /Diploma in Computer Science/Software Development/Information Technology
- A solid understanding of relational databases
- Strong SQL writing abilities
- Experience compiling and manipulating data in different formats
- An outgoing, assertive yet pleasant manner towards clients, suppliers and co-workers
- Working knowledge of .csv, .txt, .xls, .xml file formats
- Experience with Oracle PL/SQL is an asset
- Knowledge of and/or interest in different types of environmental risks would be considered an asset
- Excellent oral/written and interpersonal communication skills
- Good command of the English language with clear, concise and efficient telephone communication
- Quick and enthusiastic learner
- Strong problem solving and analytical skills
- Detail oriented
- Strong organizational skills, ability to multi-task and work under pressure
- Ability to work independently but also as a team player
This role does not involve statistical or quantitative analysis. It’s a great job for new graduates from computing programs or with programming/database experience.
If you are interested in this position, please send a cover letter and resume to: careers[at]erisinfo[dot]com, including the phrase ‘Data Analyst #0233’ in the subject line.
Applicants must provide a plain text file version (.txt) of their resume to be considered. ERIS welcomes and encourages applications from people with disabilities.