BUSINESS INTELLIGENCE & SYSTEM ANALYST

MSD Inc.; Dayton (OH); On-site; USD 39,000 - 55,000; Full time

Benefits offered by this job

PTO

401(k) match

Health Insurance

Short/Long-Term Disability

Life Insurance

Job summary

MSD Inc. is seeking a Business Intelligence & Systems Analyst in Dayton, OH to transform complex data into meaningful insights and drive operational excellence. You will develop Power BI dashboards and Apps, build robust data models, and optimize SQL queries.

The role partners with the CIO and cross-functional teams to design data transformations on Azure, automate processes with Power Platform, and maintain SOPs. Strong communication and English proficiency are essential.

Qualifications

• 3+ years in data analysis, BI, or business systems roles.
• Experience with Power BI data modeling, DAX, publishing, and apps.
• Azure data services and transforming data into Azure platform experiences.

Responsibilities

• Own design, development, and ongoing management of Power BI dashboards and apps.
• Build, publish, manage, and secure Power BI Apps for governance.
• Write, optimize, and maintain SQL queries and data sets.
• Design data transformation processes into Azure for reliable analytics.
• Use Power Query, DAX, and data modeling for accurate reporting.
• Lead discovery, requirements, testing, and deployment for BI solutions.
• Collaborate with CIO and business owners to plan BI needs.

Skills

Power BI

SQL

Azure data services

Power Platform

Excel

Python/R

Copilot Studio

Communicating in English

Education

Associate degree

Bachelor's degree

High School Diploma/GED

Tools

Power BI

Power Automate

Power Apps

SharePoint

Microsoft 365

Azure

SQL

Job description

BUSINESS INTELLIGENCE & SYSTEM ANALYST# BUSINESS INTELLIGENCE & SYSTEM ANALYSTHot JobDayton, OH 45431## OverviewSalary Range$28.00 - $40.00 HourlyPosition TypeFull Time## 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 licenseBenefits:* 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 PolicyWe 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.*