BI Data Analyst

Job Description

Job Description

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

• Focus on front-end development of Power BI dashboards for business users.
• Use existing data sets and data warehouse to build high quality reports.
• Analyze existing data and determine novel metrics to bring to the business for helpful insights.
• 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

Requirements

Benefits

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

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.