Back to jobs

Business Intelligence & System Analyst

Pay
$28–40/hour — pay source
Salary $28.00 - $40.00 Hourly
Read the full posting
Work setting
Not stated
Employment
Full-time — employment source
Employment type in the employer’s posting: Full Time
From the employer’s posting

What you’ll work on

Full posting
  • Design, publish and manage Power BI dashboards, semantic models, apps and refresh schedules

  • Write, optimize and maintain SQL queries, views and reusable datasets

  • Design data transformation processes into the Azure platform

  • Automate manual entry and repetitive work with Power Automate, Power Apps and related tools

  • Create and update SOP and system functionality documentation

From the employer’s posting
Own the design, development, and ongoing management of Power BI dashboards, semantic models, reports, workspaces, apps, access, and refresh schedules.
Write, optimize, and maintain SQL queries, views, and reusable datasets for operational and executive reporting.
Design and implement data transformation processes into the Azure platform to support reliable analytics and reporting.
Identify opportunities to reduce manual entry, disconnected spreadsheets, and repetitive work through automation and process improvement.
Review, create, and update Standard Operating Procedure (SOP) documentation and system functionality documentation.

Before you apply

Work authorization
US citizens or permanent residents onlyUS Citizenship or Permanent Resident Status required

Benefits in the posting

Full benefits wording
  • FREE Training and Education
  • PTO
  • 401(k) match
  • Bonus Program
  • Competitive Medical, Vision, and Dental
  • Health Savings Account match
  • Company paid Short- and Long-Term Disability
  • Company paid Life Insurance Policy
  • Mechanical Services & Design complies with applicable federal civil rights laws and does not discriminate, exclude people, or treat them differently because of race, color, ethnicity, religion, culture, language, national origin, age, disability, socioeconomic status, sex, sexual orientation, or gender identity or expression in its various programs and activities.

From the employer’s posting.

Posting record

Report an error
Status in our records
Live
First seen by us
Nov 6, 202615 days ago
Recorded sightings
16
Last seen by us
Nov 21, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

$95K–$145K is typical

The middle half of what similar US postings state. This one doesn’t list pay.

From 2,327 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 15

Similar jobs usually come down between day 5 and day 43.

From 16,008 similar postings that came down. Coming down is not always a hire.

Mechanical Services & Design is hiring

1 open job

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • R
  • SQL
  • Azure
  • Excel
  • Power BI
  • Power Query
Where the posting names them
- Advanced Microsoft Excel skills - Experience with Python, R, or other programming languages for data analysis, automation, or transformation preferred - Experience with Microsoft Copilot and Copilot Studio preferred
The Business Intelligence & Systems Analyst serves as a strategic partner to the business by transforming complex data into meaningful insights that drive informed decision-making and operational excellence. Reporting directly to the Chief Information Officer and working as a member of the Business Systems team, you will collaborate with leaders and cross-functional teams to understand business objectives, develop impactful reporting and interactive dashboards (including Power BI Apps), support Azure data transformation, and deliver data-driven solutions that improve efficiency, visibility, and performance across the organization. Leveraging tools such as Power BI, SQL, Azure data services, Microsoft Excel, Power Automate, Power Apps, and other data analysis technologies, you will identify trends, uncover opportunities for process improvement, and provide actionable recommendations that support organizational goals. Beyond reporting and analytics, this role plays a vital role in optimizing business processes by developing and maintaining standard operating procedures, documenting system functionality, supporting automation, and ensuring data integrity. Success in this position requires a combination of technical expertise, analytical thinking, and strong communication skills. This is an excellent opportunity for a detail-oriented, curious, and solutions-focused professional who enjoys solving complex problems, leveraging technology to improve operations, and making a measurable impact through data.
- Build, publish, manage, and secure Power BI Apps to deliver organized and governed access to reports and dashboards for business users. - Write, optimize, and maintain SQL queries, views, and reusable datasets for operational and executive reporting. - Design and implement data transformation processes into the Azure platform to support reliable analytics and reporting.
- 3+ years of experience in data analysis, business intelligence, reporting, or business systems roles (or equivalent combination of education and experience) - Demonstrated experience with Power BI (data modeling, Power Query, DAX, publishing, workspace management, and building/managing Power BI apps) and SQL (joins, aggregations, data validation, and query troubleshooting) - Hands-on experience with Azure data services and data transformation into the Azure platform
MSD is looking for a Business Intelligence & Systems Analyst to join our team! The Business Intelligence & Systems Analyst serves as a strategic partner to the business by transforming complex data into meaningful insights that drive informed decision-making and operational excellence. Reporting directly to the Chief Information Officer and working as a member of the Business Systems team, you will collaborate with leaders and cross-functional teams to understand business objectives, develop impactful reporting and interactive dashboards (including Power BI Apps), support Azure data transformation, and deliver data-driven solutions that improve efficiency, visibility, and performance across the organization. Leveraging tools such as Power BI, SQL, Azure data services, Microsoft Excel, Power Automate, Power Apps, and other data analysis technologies, you will identify trends, uncover opportunities for process improvement, and provide actionable recommendations that support organizational goals. Beyond reporting and analytics, this role plays a vital role in optimizing business processes by developing and maintaining standard operating procedures, documenting system functionality, supporting automation, and ensuring data integrity.
- Write, optimize, and maintain SQL queries, views, and reusable datasets for operational and executive reporting. - Design and implement data transformation processes into the Azure platform to support reliable analytics and reporting. - Use Power Query, DAX, and data modeling techniques to prepare data and deliver accurate, scalable reporting.
- Identify opportunities to reduce manual entry, disconnected spreadsheets, and repetitive work through automation and process improvement. - Design and support solutions using Microsoft Power Automate, Power Apps, SharePoint, Microsoft 365, Azure, and related tools. - Review, create, and update Standard Operating Procedure (SOP) documentation and system functionality documentation.
- Demonstrated experience with Power BI (data modeling, Power Query, DAX, publishing, workspace management, and building/managing Power BI apps) and SQL (joins, aggregations, data validation, and query troubleshooting) - Hands-on experience with Azure data services and data transformation into the Azure platform - Experience with Microsoft Power Platform, including Power Automated and Power Apps
- Experience with Microsoft Power Platform, including Power Automated and Power Apps - Advanced Microsoft Excel skills - Experience with Python, R, or other programming languages for data analysis, automation, or transformation preferred
Key Job Duties - Own the design, development, and ongoing management of Power BI dashboards, semantic models, reports, workspaces, apps, access, and refresh schedules. - Build, publish, manage, and secure Power BI Apps to deliver organized and governed access to reports and dashboards for business users.
- Own the design, development, and ongoing management of Power BI dashboards, semantic models, reports, workspaces, apps, access, and refresh schedules. - Build, publish, manage, and secure Power BI Apps to deliver organized and governed access to reports and dashboards for business users. - Write, optimize, and maintain SQL queries, views, and reusable datasets for operational and executive reporting.
- Design and implement data transformation processes into the Azure platform to support reliable analytics and reporting. - Use Power Query, DAX, and data modeling techniques to prepare data and deliver accurate, scalable reporting. - Communicate with team members and stakeholders to understand requirements and complete projects effectively.

Your next step

Complete your application on www.paycomonline.net. The employer’s form will show what is required.

Applying through Paycom

  • The application asks you to sign in or create a Paycom account with the employer.

Already applied? Track this application

Job description

View original posting ↗

Description

MSD is looking for a Business Intelligence & Systems Analyst to join our team!

 

The Business Intelligence & Systems Analyst serves as a strategic partner to the business by transforming complex data into meaningful insights that drive informed decision-making and operational excellence. Reporting directly to the Chief Information Officer and working as a member of the Business Systems team, you will collaborate with leaders and cross-functional teams to understand business objectives, develop impactful reporting and interactive dashboards (including Power BI Apps), support Azure data transformation, and deliver data-driven solutions that improve efficiency, visibility, and performance across the organization.

Leveraging tools such as Power BI, SQL, Azure data services, Microsoft Excel, Power Automate, Power Apps, and other data analysis technologies, you will identify trends, uncover opportunities for process improvement, and provide actionable recommendations that support organizational goals. Beyond reporting and analytics, this role plays a vital role in optimizing business processes by developing and maintaining standard operating procedures, documenting system functionality, supporting automation, and ensuring data integrity.

Success in this position requires a combination of technical expertise, analytical thinking, and strong communication skills. This is an excellent opportunity for a detail-oriented, curious, and solutions-focused professional who enjoys solving complex problems, leveraging technology to improve operations, and making a measurable impact through data.

 

 

Key Job Duties

  • Own the design, development, and ongoing management of Power BI dashboards, semantic models, reports, workspaces, apps, access, and refresh schedules.
  • Build, publish, manage, and secure Power BI Apps to deliver organized and governed access to reports and dashboards for business users.
  • Write, optimize, and maintain SQL queries, views, and reusable datasets for operational and executive reporting.
  • Design and implement data transformation processes into the Azure platform to support reliable analytics and reporting.
  • Use Power Query, DAX, and data modeling techniques to prepare data and deliver accurate, scalable reporting.
  • Communicate with team members and stakeholders to understand requirements and complete projects effectively.
  • Identify opportunities to reduce manual entry, disconnected spreadsheets, and repetitive work through automation and process improvement.
  • Design and support solutions using Microsoft Power Automate, Power Apps, SharePoint, Microsoft 365, Azure, and related tools.
  • Review, create, and update Standard Operating Procedure (SOP) documentation and system functionality documentation.
  • Lead or support discovery, requirements, testing, training, deployment, and continuous improvement of reporting and systems solutions.
  • Partner with the Chief Information Officer, management, and business process owners to plan and execute on reporting and systems needs that support organizational goals.

 

Candidate Requirements:

  • Associate’s or Bachelor’s degree in Data Analytics, Information Systems, Business, or a related field preferred
  • High School Diploma/GED required
  • 3+ years of experience in data analysis, business intelligence, reporting, or business systems roles (or equivalent combination of education and experience)
  • Demonstrated experience with Power BI (data modeling, Power Query, DAX, publishing, workspace management, and building/managing Power BI apps) and SQL (joins, aggregations, data validation, and query troubleshooting)
  • Hands-on experience with Azure data services and data transformation into the Azure platform
  • Experience with Microsoft Power Platform, including Power Automated and Power Apps
  •  Advanced Microsoft Excel skills
  • Experience with Python, R, or other programming languages for data analysis, automation, or transformation preferred
  • Experience with Microsoft Copilot and Copilot Studio preferred
  • Additional experience with SharePoint, Microsoft 365, APIs, or related systems preferred
  • Able to communicate clearly in written and verbal English
  • US Citizenship or Permanent Resident Status required
  • Unencumbered US Driver’s license

 

Benefits:

  • FREE Training and Education
  • PTO
  • 401(k) match
  • Bonus Program
  • Competitive Medical, Vision, and Dental
  • Health Savings Account match
  • Company paid Short- and Long-Term Disability
  • Company paid Life Insurance Policy

 

We value our employees and are committed to doing everything possible to ensure your continued growth and opportunities!

 

Mechanical Services & Design complies with applicable federal civil rights laws and does not discriminate, exclude people, or treat them differently because of race, color, ethnicity, religion, culture, language, national origin, age, disability, socioeconomic status, sex, sexual orientation, or gender identity or expression in its various programs and activities.

Salary

$28.00 - $40.00 Hourly

Demand for Analyst roles

New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 993, the most 1,510, and the latest week had 1,367.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay
Salary $28.00 - $40.00 Hourly
Location & working pattern

Dayton, OH 45431

Working pattern and location restrictions need checking in the full posting.

Work authorization
- Able to communicate clearly in written and verbal English - US Citizenship or Permanent Resident Status required - Unencumbered US Driver’s license

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.