Power BI & Azure Data Systems Analyst

MECHANICAL SERVICES & DESIGN INC; Dayton (OH); On-site; USD 70,000 - 100,000; Full time

Benefits offered by this job

Training and Education Support

PTO

401(k) match

Health, Vision, Dental Insurance

Holidays and Disability Insurance

Life Insurance

Job summary

Mechanical Services & Design Inc is seeking a Business Intelligence & Systems Analyst to transform complex data into actionable insights. You will own Power BI dashboard design, data modeling, and governance, while collaborating with cross-functional teams to meet business goals.

The role focuses on Azure data transformations, automation, and scalable reporting across the organization, leveraging Power BI Apps, DAX, and Power Query to improve efficiency and decision making.

Qualifications

• Requires 3+ years of experience in data analysis, BI, reporting, or business systems.
• Experience with Power BI (data modeling, DAX, publishing) and SQL query troubleshooting.
• Hands-on experience with Azure data services and data transformation.
• Strong Excel skills and familiarity with Power Platform tools.

Responsibilities

• Own design, development, and management of Power BI dashboards, semantic models, and reports.
• Build and publish Power BI Apps for governed access to reports.
• Write and optimize SQL queries, views, and datasets for operational and exec reporting.
• Design data transformations for the Azure platform and perform data modeling.
• Collaborate with stakeholders to understand requirements and deliver solutions.
• Lead SOP documentation and system functionality documentation.
• Support discovery, testing, training, deployment, and continuous improvement.

Skills

Analytical thinking

Communication

Problem solving

Data storytelling

Business analysis

Education

Bachelor’s or Associate degree in Data Analytics/IS/Business

High School Diploma/GED

Tools

Power BI

SQL

Azure data services

Microsoft Excel

Power Automate

Power Apps

SharePoint

Microsoft 365

Python

R

Copilot Studio

Job description

Mechanical Services & Design Inc is seeking a Business Intelligence & Systems Analyst to transform complex data into actionable insights. You will own Power BI dashboard design, data modeling, and governance, while collaborating with cross-functional teams to meet business goals.

The role focuses on Azure data transformations, automation, and scalable reporting across the organization, leveraging Power BI Apps, DAX, and Power Query to improve efficiency and decision making.