Business Reporting Analyst

Insight Global; Columbus (OH); On-site; USD 80,000 - 110,000; Full time

Job summary

Insight Global is seeking an experienced Business Reporting Analyst to join the Office of the CIO's Business Management Office. You will support operational, financial, workforce, staffing, and spend reporting across Technology and drive consistency and scalability in recurring reports and dashboards.

The ideal candidate has strong analytical, reporting, and business-partnering skills, with hands-on experience in Tableau and/or Power BI, and familiarity with ServiceNow, SharePoint, and related

Qualifications

• 3-6 years of experience in business reporting, data analysis, or technology reporting.
• Experience partnering with Finance, Operations, or Technology teams; financial services knowledge preferred.
• Strong hands-on experience creating reports/dashboards with Tableau and/or Power BI.
• Advanced Excel skills and ability to work with large, complex data sets.
• Familiarity with ServiceNow, SharePoint, Power Automate/Power Apps, AWS Athena, SQL, or Python.

Responsibilities

• Validate data and perform variance analysis to identify reporting anomalies.
• Document data sources, rules, and processes to support consistency and knowledge sharing.
• Develop and maintain recurring reports for Technology, including workforce, staffing, and spend.
• Collaborate with BMO and internal teams to translate requirements into reports and dashboards.
• Identify opportunities to streamline reporting and support automation initiatives.
• Translate business questions into formal reporting requirements and data definitions.
• Create and improve dashboards using Tableau, Power BI, Excel, and related tools.

Skills

Data analysis

Data validation

Communication

Problem solving

Tools

Tableau

Power BI

SQL

Python

ServiceNow

SharePoint

Power Automate

Power Apps

AWS Athena

Job description

Job Summary: We are seeking an experienced Business Reporting Analyst to join the Business Management Office (“BMO”) within the Office of the CIO of our client. This role will support reporting such as operational, financial, workforce, staffing, and spend across Technology while helping improve the consistency, quality, and scalability of recurring reports and dashboards.

The ideal candidate will bring strong analytical, reporting, and business partnership skills, with experience supporting Finance, Operations, or Technology organizations, preferably within financial services. The candidate should be comfortable working with large data sets, translating business needs into reporting requirements, validating data accuracy, and communicating key messages to stakeholders. Strong hands‑on experience with Tableau and/or Power BI is required, along with familiarity with ServiceNow and related reporting tools.

Key Responsibilities:

• Perform data validation, quality checks, variance review, and root‑cause analysis to identify reporting anomalies and ensure accuracy.
• Document report processes, data sources, business rules, procedures, and assumptions to support consistency and knowledge sharing.
• Develop, maintain, and enhance recurring business operations, workforce, staffing, and spend reporting for Technology.
• Partner with the BMO team and BMO lead and internal teams as needed to understand reporting needs, confirm requirements, and deliver accurate reporting outputs.
• Identify opportunities to streamline manual reporting processes and support automation efforts that improve efficiency, repeatability, and scalability.
• Translate business questions into clear reporting requirements, data definitions, functional specifications, and repeatable report logic.
• Create, maintain, and improve dashboards, reports, and data views using Tableau, Power BI, Excel, ServiceNow, and other approved tools.
• Support reporting standards, naming conventions, data quality practices, and BMO reporting guidelines.
• Seek and identify trends in various data and reports.
• Participate in working sessions and report reviews with stakeholders, as applicable, and with our internal team.
• The analyst role is responsible for hands‑on report development/delivery, data validation, requirements gathering, documentation, and process improvement.

Required Qualifications:

• 3-6 years of experience in business reporting, data analysis, financial analysis, operations analysis, or Technology reporting.
• Experience working with Finance, Operations, Technology, or business management teams; financial services or banking experience preferred.
• Strong hands‑on experience creating reports, dashboards, and data visualizations in Tableau and/or Power BI.
• Advanced Excel skills and ability to work with large, complex data sets.
• Ability to validate data, troubleshoot anomalies, reconcile inconsistencies, and identify root causes of reporting issues.
• Strong verbal and written communication skills, with the ability to explain data in a concise and impactful manner.
• Critical thinker with strong organizational skills, attention to detail, and focus on quality and accuracy.
• Ability to manage competing priorities, meet deadlines, and work independently with composure in a fast‑paced environment.
• Familiarity with ServiceNow, SharePoint, Power Automate, Power Apps, AWS Athena, SQL, or Python preferred.
• Familiarity with normal forms and denormalization of database tables for data conversion from SQL databases to Power BI/Tableau compatible formats
• Familiarity with dimensional modeling and implementing slowly changing dimensions (SCD Type 2 and Type 6). Useful for tracking changes over time through historical snapshots (for example, tracking an employee who moves from contract to FTE and allocating their hours/work to each bucket based on the transfer date).
• Preferably local to Columbus, OH or Dallas, TX.