MECHANICAL SERVICES & DESIGN INC

Data Analyst

MECHANICAL SERVICES & DESIGN INC · Dayton, Ohio, United States · $58K–$75K/yr

Facilities Services · 201-500 employees

23 h ago
Mid (2-5 yrs) Full-time United States
Log in to apply, save this posting, or score it against your profile with AI.

About the role

The Data Analyst transforms complex data into actionable insights through the creation of interactive dashboards and reporting. They collaborate with stakeholders to optimize business processes and maintain standard operating procedures to ensure data integrity.

What they look for

Power BI Microsoft Excel Power Automate SQL Python R Data Analysis Dashboard Development Process Documentation Data Mining Stakeholder Communication SOP Development

Requirements

Candidates should have 2+ years of experience in data analysis and proficiency with tools like Power BI, SQL, and Python. A degree in Data Analytics or a related field is preferred, and US citizenship or permanent residency is required.

Benefits

Free Training And Education PTO 401(k) Match Profit Sharing Medical Insurance Vision Insurance Dental Insurance Health Savings Account Match Short-Term Disability Long-Term Disability Life Insurance Policy

Full description

Job DetailsJob Location: Dayton, OH 45431Position Type: Full TimeSalary Range: $28.00 - $36.00 HourlyMSD is looking for a Data Analyst to join our team! The Data Analyst serves as a strategic partner to the business by transforming complex data into meaningful insights that drive informed decision-making and operational excellence. In this role, you will collaborate with leaders and cross-functional teams to understand business objectives, develop impactful reporting and interactive dashboards, and deliver data-driven solutions that improve efficiency, visibility, and performance across the organization. Leveraging tools such as Power BI, Microsoft Excel, Power Automate, SQL, Python, R, 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, the Data Analyst plays a vital role in optimizing business processes by developing and maintaining standard operating procedures, documenting system functionality, and ensuring data integrity across projects. Success in this position requires a combination of technical expertise, analytical thinking, and strong communication skills, as you'll regularly partner with stakeholders to translate business needs into scalable reporting solutions. 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. The Data Analyst plays a key role in transforming data into meaningful business insights that drive smarter decisions across the organization. Using tools such as Power BI, Microsoft Excel, Power Automate, SQL, Python, and other data analysis technologies, this role develops impactful dashboards, reporting, and process documentation while partnering with stakeholders to identify opportunities, improve business processes, and deliver data-driven solutions that support organizational success. Key Job Duties Review, create, and update reporting and dashboards utilizing required system such as Power BI, Microsoft Excel, and Power Automate. Communicate with appropriate team members and stakeholders to understand requirements and complete projects effectively. Review, create, and update Standard Operating Procedure (SOP) documentation and maintain system functionality documentation. Proactively communicates with Supervisor and business stakeholders around reporting and dashboard needs, ensuring clear understanding of requirements and timelines. Work with team to develop clear and concise standard operating procedures for system usage and documents systems functionality. Produce required reporting as needed on a project by project basis in systems such as: Power BI, Microsoft Excel, and/or Power Automate . Produce required scripting and data analysis using data mining tools and techniques, such as SQL, R, Python, or similar on a project basis. Partners with the Chief Information Officer, management, and business process owners to plan and execute on reporting and dashboard 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 2+ years of experience in data analysis, reporting, or business intelligence roles (or equivalent combination of education and experience) Experience with Power BI, advanced Excel, and data analysis tools (SQL, Python, or R) is highly desirable 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 Profit Sharing 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. Qualifications