Hybrid Power BI Developer

at Public Consulting Group

• Job title: Power BI Developer
• Job type: Full Time
• Experience level: Mid level, Senior
• Salary: $76,900 - $86,900 per year
• Degree requirement: Bachelor's Degree
• Tech skills: Azure, ETL, SQL
• Location requirements: Hybrid, United States

About the role

• Power BI Developer at Public Consulting Group enhancing data-driven solutions for partners in health, education, and human services. Collaborating to maintain and create BI infrastructures during projects and operations.

Responsibilities

• Support internal and external projects by developing solutions using Power BI, Power Platform, and Excel.
• Create, maintain, and enhance Power BI dashboards and Power Platform applications in both test and production environments.
• Perform data analysis using Excel, including advanced formulas, pivot tables, and data visualization techniques.
• Troubleshoot issues, manage production changes following lifecycle and risk guidelines, and act as a subject matter expert for assigned systems.
• Gather business and analytical requirements with a focus on data-driven decision-making.
• Design and develop dashboards and reports using Power BI.
• Clean, transform, and model data using Power BI and DAX to create calculated columns, measures, and relationships.
• Develop and optimize SQL queries, views, stored procedures, and user-defined functions to support reporting and analytics.
• Document processes and standards for creating and maintaining Power BI reports and Excel-based analysis tools.
• Conduct unit testing and support QA efforts to ensure accuracy and quality of Power BI and Excel solutions.
• Lead special projects, delegate tasks, and deliverables meet business needs and timelines.
• Stay current with Power BI updates, Microsoft Fabric, and industry trends to continuously improve BI capabilities.

Requirements

• Bachelor’s degree in a related field (e.g., Data Analytics, Information Systems, Computer Science) or equivalent experience (6+ years) in a technical or analytical role.
• 2+ years of hands-on experience with Microsoft Power BI, including building dashboards, data modeling, and visualization.
• 3+ years of experience working as a data analyst, with proven ability to interpret data, identify trends, and deliver actionable insights using tools like Excel and Power BI.
• Proficient in Power BI Desktop and Power BI Service, including report creation, publishing, and workspace management.
• Solid understanding of DAX (Data Analysis Expressions) and Power Query (M language) for data modeling and transformation.
• Strong proficiency in Microsoft Excel, including advanced formulas, pivot tables, and data visualization techniques.
• Experience with data modeling, ETL (Extract, Transform, Load) processes, and performance tuning to optimize report efficiency and accuracy.
• Ability to design and manage relationships, hierarchies, and metadata in Power BI datasets.
• Proficiency in SQL and working with relational databases (e.g., SQL Server, Azure SQL, Synapse).

Benefits

• medical and dental care benefits
• 401k
• PTO
• parental leave
• bereavement leave