Dayton Data Analyst — Power BI, SQL & Ops Insights

Mechanical Services & Design; Dayton (OH); On-site; USD 58,240 - 74,880; Full time

Benefits offered by this job

FREE Training and Education

PTO

401(k) match

Profit Sharing

Competitive Medical, Vision, andDental

Health Savings Account match

Company paid Short‑ and Long‑TermDisb

Company paid Life Insurance Policy

Job summary

Mechanical Services & Design is seeking a Data Analyst for an in-person Dayton, OH role. You will transform complex data into actionable insights, develop dashboards, and collaborate with leaders to drive operational excellence.

You will work with Power BI, Excel, Power Automate, SQL, Python, and R to identify trends, improve processes, and deliver data-driven recommendations across the organization.

Qualifications

• Associate’s or Bachelor’s degree in Data Analytics, Information Systems, Business, or a related field preferred.
• High School Diploma/GED required.
• 2+ years of experience in data analysis, reporting, or BI roles or equivalent education/experience.
• Experience with Power BI, advanced Excel, and data analysis tools (SQL, Python, or R) preferred.

Responsibilities

• Review, create, and update reporting and dashboards using Power BI, Excel, and Power Automate.
• Communicate requirements and timelines with stakeholders to complete projects effectively.
• Update SOP documentation and maintain system functionality docs.
• Proactively communicate reporting and dashboard needs to supervisors and stakeholders.
• Develop clear SOPs for system usage and document system functionality.
• Produce required reporting on a project basis in Power BI, Excel, or Power Automate.
• Perform data analysis scripting using SQL, R, Python, etc., as needed.
• Partner with CIO and process owners to plan and execute reporting needs.

Skills

Data analysis

Reporting

BI collaboration

Education

Associate/Bachelor's degree in Data Analytics or related field

High School Diploma/GED

Tools

Power BI

Microsoft Excel

Power Automate

SQL

Python

R

Job description

Mechanical Services & Design is seeking a Data Analyst for an in-person Dayton, OH role. You will transform complex data into actionable insights, develop dashboards, and collaborate with leaders to drive operational excellence.

You will work with Power BI, Excel, Power Automate, SQL, Python, and R to identify trends, improve processes, and deliver data-driven recommendations across the organization.