BI Data Analyst

Rea
Dublin, OH

Rea  is a growing Top 100 business advisory & accounting firm providing our clients services in tax, accounting, and business consulting. We have a ‘People First’ culture and we focus on our employees’ well-being and professional development. With over 400 professionals and locations throughout Ohio, our firm has a culture that respects a work-life balance for our team. We also provide competitive compensation and a robust benefits plan.

The BI Data Analyst will play a critical role in leveraging Power BI and Azure SQL to analyze data, build data sets, develop insightful reports, and create efficient workflows. The role’s use of these tools will contribute to data-driven decision-making and process optimization across our organization. 

Responsibilities

  • Utilize Power BI to gather and transform data from various sources (IE Excel, APIs, SQL), creating visually appealing and interactive dashboards to present key insights to stakeholders  
  • Collaborate with cross-functional teams to understand data requirements and design meaningful visualizations that drive informed decisions  
  • Design robust generalized SQL datasets through combining raw data for reports. 
  • Work closely with end-users to gather requirements and ensure that dashboards meet their needs effectively  
  • Identify opportunities for reporting and process automation across internal clients and implement solutions that deliver tangible benefits  
  • Apply data cleansing and transformation techniques using Power Query to ensure data accuracy and consistency across different data sources  
  • Collaborate with data warehouse engineers to enhance data quality and resolve data integration issues  
  • Collaborate with team members to share best practices, provide technical guidance, and support the adoption of Power Platform tools  
  • Train end-users on using Power BI, Power Apps, and Power Automate effectively for their respective needs  
  • Ensure compliance with data governance policies and implement security measures to protect sensitive data within Power Platform solutions  
  • Stay up-to-date with Microsoft's updates and features related to Power Platform to maintain best practices  

Knowledge, Skills and Abilities

  • Proficiency in data analysis, visualization, and report creation using Power BI  
  • Strong understanding of data transformation, ETL processes, and data modeling concepts  
  • Familiarity with data governance principles and best practices for maintaining data accuracy and security  
  • Excellent communication skills, both written and verbal, to convey technical concepts to non-technical stakeholders  
  • Analytical mindset with the ability to translate business requirements into effective Power BI Dashboards or power platform apps. 
  • Problem-solving skills to troubleshoot issues and optimize Power Platform applications  
  • Experience working in a collaborative team environment and a track record of delivering results on time 
  • Bachelor's or Master's degree in Computer Science, Information Technology, Data Science, or a related field 
  • Proven experience (5+ years) as a Data Analyst, with demonstrated expertise in Microsoft Power Platform tools (Power BI, Power Apps, Power Automate) , intermediate SQL knowledge
  • Hands-on experience developing custom Power BI Dashboards, analyzing data within SQL databases, building company wide usable datasets
  • Analyzing raw data and identifying useful metrics and new ways of looking at data to help drive the business
  • Travel to client locations as needed 

Rea offers a wide variety of benefits to help support our employees' health, wellness and financial goals.

  • Health Care Plan (Medical, Dental & Vision)
  • Retirement Plan (401k)
  • Life Insurance (Basic, Voluntary & AD&D)
  • Paid Time Off (Vacation, Sick & Public Holidays)
  • Family Leave (Maternity, Paternity)
  • Short Term & Long Term Disability
  • Training & Development
  • Wellness Resources
  • Four (4) weeks PTO
  • Twelve (12) paid holidays, of which three (3) are floating holidays

Rea does not accept unsolicited resumes from individual recruiters or third-party recruiting agencies without pre-approval from Rea’s Talent team. Pre-approval is required before any external candidate can be submitted. Rea will not be responsible for fees related to unsolicited resumes and for candidates who are sent directly to our hiring managers.

Posted 2025-09-22

Recommended Jobs

Electrical Estimator

IES Residential, Inc.
Cincinnati, OH

Job Description Job Description Overview IES Residential, Inc. is one of the nation's largest and most respected electrical, plumbing, HVAC, solar, and cable solutions providers for single-fa…

View Details
Posted 2025-08-23

General Practice Care-Associate Veterinaria-Boardman-OH

USVTA LLC
Boardman, OH

We are looking for an Associate Veterinarian to join our team! Requirements ~  DVM or VMD Benefits Enjoy a positive and engaging workplace culture where your input is valued. Benefit…

View Details
Posted 2025-09-21

Faith Based Licensed Therapist

CORNERSTONE WELLNESS CENTER LLC
Lagrange, OH

Job Description Job Description Benefits: Patient Generating and Marketing Competitive salary Flexible schedule Opportunity for advancement Benefits/Perks Careers Advancement Op…

View Details
Posted 2025-08-06

Experience Midwestern Charm as a Telemetry Nurse!

NurseRecruiter
Columbus, OH

Registered Nurse - Telemetry - Travel - (Tele RN) Embrace the adventure of travel nursing as a Telemetry Nurse in Columbus, where you'll care for patients in a dynamic, innovative environment! Pictur…

View Details
Posted 2025-08-20

CNC HBM Speedram Operator Weekend

BWXT
Barberton, OH

At BWX Technologies, Inc. (NYSE: BWXT), we are People Strong, Innovation Driven. A U.S.-based company, BWXT is a Fortune 1000 and Defense News Top 100 manufacturing and engineering innovator that pro…

View Details
Posted 2025-09-16

Accounting Specialist

United Rehabilitation Services of Dayton
Dayton, OH

Accounting Specialist Community Employment Services – Full Time Position Duties Collect and enter data into assigned data systems; verify accuracy of data in preparation for billing; prepare and su…

View Details
Posted 2025-08-06

Call Center Representative/Dispatcher/Scheduler/Quality Control

Access 2 Interpreters, LLC.
Columbus, OH

Job Description Job Description Dispatcher/Scheduler/Quality Control 7am - 3pm ($20.00/hr) We are looking for a Dispatcher/Scheduler to work with our Interpreters who are dispatched/sched…

View Details
Posted 2025-07-28

Teller

The Croghan Colonial Bank
Oak Harbor, OH

Teller - Oak Harbor, OH (full-time, on-site): Who We Are - Community Relationships are our priority, and our team here at Croghan Colonial Bank strives to help our communities have the most su…

View Details
Posted 2025-09-01

Clinical Reimbursement Auditing Nurse

Engage Consulting
Toledo, OH

Description Clinical Reimbursement Auditing Nurse – Remote Full-Time | Remote | Compact Nursing License Required We are seeking a highly skilled Clinical Reimbursement Auditing Nurse to jo…

View Details
Posted 2025-09-20

Shift Manager (Shift Supervisor)

Taco Bell
Middlefield, OH

Shift Manager (Shift Supervisor) (Must be 18+ Years of Age) Are you a highly skilled and motivated individual looking for an immediate opportunity in the food & beverage industry? Do you thrive in a …

View Details
Posted 2025-09-20