Data Analyst

TechDigital Group; Denver (CO); On-site; USD 60,000 - 80,000; Full time

Job summary

A leading technology company in Denver, Colorado, is seeking a Data Analyst with a strong GIS background. The role involves data collection, ETL process management, and reporting. Candidates should have expertise in MS Excel and familiarity with Access databases and SharePoint. Ideal candidates will possess strong analytical skills and work effectively in a collaborative environment. This position offers opportunities for data analysis in a fast-paced setting.

Qualifications

• 2-4 years of relevant experience preferred.
• Expert level knowledge of MS Excel required.
• Strong analytical and organizational skills are essential.

Responsibilities

• Design, code, test, debug, and document ETL processes.
• Extract and analyze data from diverse sources.
• Create and publish reports as required.

Skills

Strong GIS background

Experience with Access databases and SharePoint

Proficiency in Microsoft Office Suite

Effective data analysis skills

Familiarity with DMS

Tools

Microsoft SQL

Statistical software

Job description

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