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).
24 years of relevant experience preferred