Business Systems Analyst, BI & Reporting

Vernovis; Miamisburg (OH); On-site; USD 75,000 - 95,000; Full time

Job summary

Vernovis in Miamisburg, OH seeks a technically hands-on Business Systems Analyst to support data, BI, reporting and process-improvement initiatives across the organization. This role improves decision-making, data quality, reporting consistency, and operational performance while aligning solutions with IT standards and data governance.

The role combines data analysis and stakeholder engagement; the ideal candidate can work with data, develop reports and dashboards, investigate data-quality

Responsibilities

• Partner with stakeholders to understand reporting needs and priorities.
• Translate business needs into data, reporting, and system requirements.
• Develop and maintain Power BI dashboards, scorecards, KPI reports, and ad hoc reports.
• Write SQL queries to retrieve, transform, and validate data.
• Work with data warehouses, data lakes, and data models supporting analytics.
• Investigate data discrepancies and perform trend and root-cause analyses.
• Create current-state and future-state process maps and user stories.
• Identify opportunities to automate manual processes and improve workflows.
• Present findings and recommendations to nontechnical stakeholders.

Job description

Business Systems Analyst, BI & Reporting
Location: Miamisburg, OH
Work Arrangement: Fully Onsite
Job Type: Full-Time
Reports to: Chief Information Officer
We are seeking a technically hands‑on Business Systems Analyst to support data, business intelligence, reporting, and process‑improvement initiatives across the organization. This role will help improve decision‑making, data quality, reporting consistency, and operational performance while aligning solutions with established IT standards, data governance, and enterprise technology direction.
This hybrid role combines the technical capabilities of a Data and BI Analyst with the stakeholder engagement, requirements gathering, and process analysis skills of a Business Analyst. The ideal candidate can work directly with data, understand how it flows between enterprise systems, develop reports and dashboards, investigate data‑quality issues, and clearly communicate findings to nontechnical business stakeholders.

What You’ll Do:

• Partner with stakeholders across operations, finance, human resources, project management, executive leadership, and IT to understand reporting needs, workflows, challenges, and priorities.
• Translate business needs into clear data, reporting, workflow, and system requirements.
• Gather, validate, transform, and analyze data from multiple enterprise systems.
• Develop and maintain Power BI dashboards, scorecards, KPI reports, and recurring or ad hoc reporting.
• Write SQL queries and use appropriate analytical tools to retrieve, transform, analyze, and validate data.
• Work with data warehouses, data lakes, data models, and pipelines that support reporting and analytics.
• Investigate data discrepancies and conduct trend, variance, and root cause analyses to identify likely drivers, recommend practical solutions, and support informed business decisions.
• Develop current‑state and future‑state process maps, gap analyses, business requirements, user stories, and supporting documentation.
• Identify opportunities to replace manual processes with improved digital workflows, automation, or reporting solutions.
• Present technical findings and recommendations to nontechnical stakeholders in a clear, actionable manner.
• Support data cleansing, standardization, governance, and data‑quality initiatives.
• Document and maintain data definitions, business rules, data lineage, and reporting standards in collaboration with IT leadership, data owners, and functional process owners.
• Assist with system implementations, upgrades, integrations, testing, and data validation.
• Coordinate with external technology partners on changes to the organization’s data and reporting environment.
• Train end users on dashboards, reports, analytics tools, and updated business processes.
  

Business Systems Analyst, BI & Reporting
<