Data Analyst

TechDigital Group; Saint Paul (MN); On-site; USD 60,000 - 80,000; Full time

Job summary

A leading technology company located in Saint Paul, Minnesota, is seeking a data analyst proficient in data collection, analysis, and ETL processes. The ideal candidate will have strong skills in MS Excel and a solid understanding of relational databases. Responsibilities include performing data analysis, generating reports, and responding to data inquiries. This role offers an exciting opportunity to work with diverse data sources and contribute to critical reporting processes.

Qualifications

• Experience with relational databases and knowledge of query tools.
• Expert-level knowledge of MS Excel required.
• Strong analytical and organizational skills needed.

Responsibilities

• Perform data collection, analysis, validation, cleansing, and reporting.
• Design, code, test, debug, and document ETL processes.
• Extract and analyze data from various sources.
• Respond to data inquiries and create ad hoc reports.
• Document reporting requirements and validate data components.

Skills

Data collection and analysis

ETL processes

SQL queries

Data validation

MS Excel

Statistical software knowledge

Strong analytical skills

Organizational skills

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 are also essential.
• Must possess expert-level knowledge of MS Excel.