Data Analyst

Overview

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.

Responsibilities

• 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.

Top skills and qualifications

• 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

Non-technical skills

• Effective communicator
• Collaborative and team-oriented
• Self-starter with strong time management skills
• Ability to work independently in a remote setting

Ideal candidate background

• Ideal background includes GIS or mapping experience (e.g., utility or communications mapping).
• 2–4 years of relevant experience preferred