Power BI Reporting & Analytics Consultant
Akron, OH
Full time or Part time available
Position Overview
We are seeking a Power BI Reporting & Analytics Consultant to support project and portfolio management initiatives through the design, development, and optimization of reporting and analytics solutions. This role will partner closely with client stakeholders to transform complex business needs into actionable dashboards, reports, and data-driven insights that support strategic decision-making across large-scale programs and capital projects. The ideal candidate combines strong Power BI development expertise with business analysis skills, stakeholder engagement experience, and an understanding of project portfolio management environments. Experience supporting utilities, infrastructure organizations, or regulated industries is highly preferred.
Key Responsibilities
- Design, develop, configure, and maintain Power BI dashboards, reports, and analytics solutions using system data, Power BI Dataflows, and other enterprise data sources.
- Partner with business stakeholders to gather, analyze, document, and validate business and functional requirements.
- Translate reporting requirements into scalable and sustainable Power BI solutions that support project and portfolio management objectives.
- Develop and maintain data models, reporting frameworks, and visualizations that enable accurate, repeatable, and efficient reporting.
- Support data extraction, transformation, migration, and integration activities while ensuring data integrity and consistency across systems.
- Collaborate with project teams to establish and monitor data quality metrics, ensuring completeness, accuracy, and reliability of reporting data.
- Participate in client-facing meetings, discovery sessions, workshops, demonstrations, status updates, and feedback discussions.
- Communicate project progress, risks, dependencies, and recommendations to both technical and non-technical stakeholders.
- Identify opportunities for process improvement, automation, and enhanced reporting capabilities that increase operational efficiency and business value.
- Assist with ongoing reporting support, troubleshooting, and continuous enhancement efforts.
- Perform additional duties as assigned.
Required Qualifications
- Bachelor’s Degree in Business, Computer Science, Engineering, Information Systems, or a related field from an accredited institution.
- Minimum of 3 years of relevant experience in reporting, analytics, business intelligence, or data-focused consulting roles.
- Experience developing dashboards, reports, and data visualizations using Microsoft Power BI.
- Experience gathering, documenting, and validating business and functional requirements.
- Strong analytical, troubleshooting, and problem-solving capabilities.
- Excellent verbal and written communication skills.
- Ability to effectively present information to both technical and business audiences.
- Ability to work independently while also collaborating within cross-functional teams.
Preferred Qualifications
- Experience supporting project portfolio management (PPM) platforms and reporting environments.
- Experience working within utilities, infrastructure organizations, engineering services firms, or large capital project environments.
- Experience within regulated industries, particularly electric, gas, water, or energy utilities.
- Experience leading client-facing discovery sessions, facilitating stakeholder workshops, and influencing business decisions.
- Knowledge of data modeling, ETL processes, data governance, and reporting best practices.
- Experience driving organizational change through reporting, analytics, and process improvement initiatives.
About Us: At Brooksource, relationships are the foundation of everything we do. Since 2000, we’ve built lasting partnerships with clients, consultants, and internal teams to deliver an exceptional experience across every engagement. As a trusted IT and Engineering services provider, Brooksource supports Fortune 500 organizations through Experience-Driven Staffing, Professional Services, and Elevate, our proprietary Workforce Transformation program. Whether you're hiring for software development, cloud computing, cybersecurity, data analytics, or enterprise IT, our customized staffing solutions are designed to align with your company’s unique goals, culture, and technology stack. We offer flexible hiring models, including contract, contract-to-hire, and direct placement to meet your evolving business needs. We are a certified partner of leading platforms, including Salesforce, AWS, Microsoft, and Google Cloud, enabling us to deliver scalable, end-to-end technology solutions. With a growing national footprint, Brooksource is redefining expectations in IT consulting, engineering services, and technology workforce solutions. EEO Statement: Brooksource is an equal opportunity employer that does not discriminate on the basis of actual or perceived race, color, creed, religion, national origin, ancestry, citizenship status, age, sex or gender (including pregnancy, childbirth, lactation and related medical conditions), gender identity or gender expression, sexual orientation, marital status, military service and veteran status, physical or mental disability, protected medical condition as defined by applicable state or local law, genetic information, or any other characteristic protected by applicable federal, state, or local laws and ordinances. Benefits & Perks: Brooksource offers competitive medical, dental, vision, Health Savings Account, Dependent Care FSA, and supplemental coverage with plans that can fit each employee’s needs. We offer a 401k plan that includes a company match and is fully vested after you become eligible, paid time off, sick time, and paid company holidays. We also offer an Employee Assistance Program (EAP) that provides services like virtual counseling, financial services, legal services, life coaching, etc. Pay Disclaimer:The pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.
Pay: Up to $40.00 per hour
Work Location: In person
