Power BI Lead - Financial Dashboarding for Executive Business Reviews

INSPYR Solutions; Houston (TX); Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

Comprehensive medical benefits

Competitive pay

401(k) retirement plan

Job summary

A leading company in technology solutions is seeking a Power BI Developer to create financial dashboards for executive reviews. The ideal candidate will have extensive experience in BI development, particularly with Power BI, and will work closely with finance and operations teams to deliver actionable insights. This role requires strong analytical skills and the ability to present complex data clearly to stakeholders.

Qualifications

• 5+ years of experience in BI development focused on Power BI.
• 3+ years in financial analysis or FP&A.
• Expertise in DAX and Power Query.

Responsibilities

• Design and develop executive-level Power BI dashboards.
• Integrate data from various sources including SAP and SQL Server.
• Collaborate with stakeholders to align KPIs with business goals.

Skills

DAX

Power Query (M)

SQL

Financial Analysis

Data Visualization

Analytical Thinking

Job description

Power BI Lead - Financial Dashboarding for Executive Business Reviews

Get AI-powered advice on this job and more exclusive features.

Title: Power BI Developer - Financial Dashboarding for Executive Business Reviews
Location: Houston, TX 77056
Duration: Contract
Work Authorization: US Citizen, Green Card, or authorized to work in the US
Hybrid: 3 days onsite

Job Description:

We are seeking an experienced and analytical Power BI Developer to design, build, and maintain executive-level financial dashboards for Monthly Business Reviews (MBR) and Quarterly Business Reviews (QBR). The ideal candidate will collaborate closely with finance, operations, and leadership teams to create compelling, interactive dashboards that provide actionable insights on key business performance metrics such as Net Revenue, EBITDA, Cash Flow, SG&A, Production Efficiency, and Distribution/Transportation Costs.

Key Responsibilities:

1. Dashboard Design & Development:

• Design and develop high-impact, visually compelling Power BI dashboards tailored for executive-level consumption.
• Translate complex financial and operational data into intuitive visuals and metrics aligned with MBR/QBR processes.
• Build drill-down capabilities to allow executives to explore metric drivers by region, product line, or business unit.

Data Modeling & Integration:

• Connect to diverse data sources including SAP (FI/CO), Snowflake, AWS S3, Excel, and SQL Server to create reliable, refreshable data models.
• Develop and optimize DAX queries and data transformations (Power Query/M) for high performance and scalability.
• Ensure semantic models are aligned with business definitions for KPIs and metrics.

Business Stakeholder Engagement:

• Collaborate with Finance, FP&A, Manufacturing, and Logistics teams to gather requirements and align KPIs with strategic goals.
• Conduct stakeholder interviews to understand current pain points and translate them into user-centric dashboard features.
• Regularly present dashboard updates, insights, and enhancement plans to leadership teams.

Governance & Documentation:

• Ensure data security, access control, and compliance with internal governance standards.
• Maintain comprehensive documentation on dashboard logic, data sources, and business rules.
• Implement CI/CD processes and version control for Power BI artifacts.

Key Metrics Supported:

• Financial: Net Revenue, Gross Profit, EBITDA, Operating Income, Cash Flow (Operating, Investing, Financing)
• Operational: Production Volumes, Yield, Utilization Rates, Cost per Unit
• Cost Metrics: SG&A Cost, Transportation & Distribution Costs, Inventory Turnover
• Strategic KPIs: Variance Analysis (Actual vs. Forecast/Budget), Working Capital, ROIC

Qualifications and Skills:

• 5+ years of experience in BI development with a strong focus on Power BI.
• 3+ years of experience in financial analysis, FP&A, or working with finance-related KPIs.
• Expertise in DAX, Power Query (M), and building complex data models.
• Proficiency in SQL and integrating cloud data sources (e.g., Snowflake, AWS, Azure).
• Experience in creating dashboards tailored to C-level audiences with strong UX/visualization design principles.
• Demonstrated ability to work with large, complex datasets and translate them into executive-level insights.

Preferred:

• Experience working in manufacturing, industrial, or distribution industries.
• Familiarity with SAP data structures, particularly FI/CO, MM, and SD modules.
• Background in data warehousing and ETL design.
• Exposure to corporate finance concepts such as P&L, balance sheet, and cash flow analysis.

Soft Skills:

• Executive presence and the ability to present complex data in a concise, insightful manner.
• Strong analytical thinking and attention to detail.
• Proactive problem solver who can work independently and in cross-functional teams.
• Effective communicator with the ability to translate technical language for business stakeholders.

Our benefits package includes:

• Comprehensive medical benefits
• Competitive pay
• 401(k) retirement plan
• …and much more!

About INSPYR Solutions

Technology is our focus and quality is our commitment. As a national expert in delivering flexible technology and talent solutions, we strategically align industry and technical expertise with our clients’ business objectives and cultural needs. Our solutions are tailored to each client and include a wide variety of professional services, project, and talent solutions. By always striving for excellence and focusing on the human aspect of our business, we work seamlessly with our talent and clients to match the right solutions to the right opportunities. Learn more about us at inspyrsolutions.com.

INSPYR Solutions provides Equal Employment Opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, INSPYR Solutions complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities.