BUSINESS INTELLIGENCE & SYSTEM ANALYST

MECHANICAL SERVICES & DESIGN INC•Dayton, OH
•$28 - $40

About The Position

The Business Intelligence & Systems Analyst serves as a strategic partner to the business, transforming complex data into meaningful insights that support informed decision-making and operational excellence. Reporting directly to the Chief Information Officer and working as part of the Business Systems team, this role collaborates with leaders and cross-functional teams to understand business objectives, develop reporting and interactive dashboards—including Power BI Apps—support Azure data transformation, and deliver data-driven solutions that improve organizational efficiency, visibility, and performance. The role uses Power BI, SQL, Azure data services, Microsoft Excel, Power Automate, Power Apps, and other data analysis technologies to identify trends, uncover process-improvement opportunities, and provide actionable recommendations. It also supports business-process optimization by maintaining standard operating procedures, documenting system functionality, supporting automation, and ensuring data integrity. Success requires technical expertise, analytical thinking, and strong communication skills.

Requirements

  • High school diploma or GED required.
  • Associate’s or bachelor’s degree in Data Analytics, Information Systems, Business, or a related field preferred.
  • At least 3 years of experience in data analysis, business intelligence, reporting, or business systems roles, or an equivalent combination of education and experience.
  • Demonstrated Power BI experience, including data modeling, Power Query, DAX, publishing, workspace management, and building and managing Power BI Apps.
  • SQL experience, including 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 Automate and Power Apps.
  • Advanced Microsoft Excel skills.
  • Clear written and verbal communication skills in English.
  • U.S. citizenship or permanent resident status required.
  • Unencumbered U.S. driver’s license required.

Nice To Haves

  • Experience with Python, R, or other programming languages for data analysis, automation, or transformation.
  • Experience with Microsoft Copilot and Copilot Studio.
  • Additional experience with SharePoint, Microsoft 365, APIs, or related systems.

Responsibilities

  • Design, develop, and manage Power BI dashboards, semantic models, reports, workspaces, apps, access, and refresh schedules.
  • Build, publish, manage, and secure Power BI Apps that provide organized and governed access to reports and dashboards.
  • 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 procedures and system-functionality documentation.
  • Lead or support discovery, requirements gathering, 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 reporting and systems needs that support organizational goals.

Benefits

  • Free training and education
  • Paid time off (PTO)
  • 401(k) match
  • Bonus program
  • Competitive medical, vision, and dental coverage
  • Health Savings Account match
  • Company-paid short- and long-term disability
  • Company-paid life insurance policy
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service