Database Analyst/Programmer - 307

DSM-H Consulting; Peoria (IL); Hybrid; USD 65,000 - 90,000; Full time

Job summary

DSM-H Consulting in Peoria, IL seeks an experienced data analyst to assist in developing and delivering reports and dashboards, analyze offerings, and prepare technical documentation. This role supports senior analysts and cross-functional teams.

Required are 5+ years in data analytics, strong SQL, Snowflake, and dashboard tools (Tableau/Power BI), plus exceptional attention to detail and communication skills. Hybrid in-office structure with team interaction.

Qualifications

• Minimum 5 years of experience in data analysis or analytics capacity.
• Strong proficiency in SQL and data querying.
• Experience with Snowflake or similar data platforms.
• Experience with Tableau and/or Power BI dashboards.
• Attention to detail and ability to deliver accurate data insights.

Responsibilities

• Assist in development, testing, and delivery of reports and dashboards.
• Identify user requirements and define technical specifications.
• Prepare technical documentation for senior analysts and tech teams.
• Support senior analysts by fulfilling data requests and preparing reports.
• Collaborate with internal Client employees and team members.

Skills

Accuracy & Detail

Business Data Analysis

Effective Communications

Requirements Analysis

SQL

Snowflake

Tableau

Power BI

AI Workflows

Data Structures in SQL

Tools

Snowflake

Tableau

Power BI

SQL

Job description

- Assisting in the development, testing, and delivery of reports/dashboards services/products; Analyzing existing offerings, preparing technical documentation, and recommending upgrades.

- Identifying user/client requirements for reports or dashboards a product or service and defining technical specifications; Preparing technical documentation and sharing them with senior analysts and technical teams; executing to deliver the solution.

- Supporting senior analysts by fulfilling their data requests, preparing reports, and providing technical assistance.

Typical task breakdown

- Assisting in the development, testing, and delivery of reports/dashboards services/products; Analyzing existing offerings, preparing technical documentation, and recommending upgrades.

- Identifying user/client requirements for reports or dashboards a product or service and defining technical specifications; Preparing technical documentation and sharing them with senior analysts and technical teams; executing to deliver the solution.

- Supporting senior analysts by fulfilling their data requests, preparing reports, and providing technical assistance.

Interaction with team

- Team consists of 3 folks but work closely with a 4th person.

- Working with internal Client employees

Work environment

in office couple days but this could eventually turn into a full RTO

Education & Experience Required

- Degree not required but they must have a minimum of 5 yrs exp in this capacity

Required Technical Skills

(Required)

- Accuracy and Attention to Detail: Extensive understanding the necessity and value of accuracy; ability to complete tasks with high levels of precision.

- Business Data Analysis: Extensive knowledge of business data analysis; ability to collect, identify, analyze and interpret business data using various kinds of techniques to meet business needs and requirements.

- Effective Communications: Working understanding of effective communication concepts, tools and techniques; ability to effectively transmit, receive, and accurately interpret ideas, information, and needs through the application of appropriate communication behaviors.

- Requirements Analysis: Working knowledge of tools, methods, and techniques of requirement analysis; ability to elicit, analyze and record required business functionality and non-functionality requirements to ensure the success of a system or software development project.

Considerations for Top Candidates

Proven experience in the ability to query and analyze large & complex data sets in Snowflake or other similar tools (typically 2+ years)

Experience with AI workflows such as data pipeline engineering and prompt engineering

Proven experience in design and prototyping dynamic views and visualizations for large and complex data sets in Tableau and/or Power BI (typically 2+ years)

Practical experience delivering production deployed solutions (typically 2+ years)

Self-starter and driven while working well in team environment

Strong attention to detail in order to spot inaccuracies in coding or data

Experience with data structures using SQL