Data Analyst

JOB DESCRIPTION

Performs data collection, analysis, validation, cleansing, and reporting. Designs, codes, tests, debugs, and documents ETL processes, SQL queries, and stored procedures. Extracts and analyzes data from various sources, including databases, manual files, and external websites. Responds to data inquiries from various groups within an organization. Creates and publishes regularly scheduled and ad hoc reports. Documents reporting requirements and processes and validates data components as required. Requires experience with relational databases and knowledge of query tools and/or statistical software. Strong analytical and organizational skills also essential. Must possess expert level knowledge of MS Excel.

What are the top 3-5 skills and qualifications (technology/application/software, etc.) required?
· Strong GIS background
· Experience with Access databases and SharePoint
· Proficiency in Microsoft Office Suite (Excel, Access, SharePoint)
· Familiarity with distribution management systems (DMS) preferred
· Effective data analysis and data validation skills

2. What non-technical skills are necessary (i.e., such as communication, problem solving, team player)?
· Effective communicator
· Collaborative and team-oriented
· Self-starter with strong time management skills
· Ability to work independently in a remote setting

3. Ideal candidate background and how many years required?
Ideal background includes GIS or mapping experience (e.g., utility or communications mapping).
2–4 years of relevant experience preferred