Power BI Developer

We are seeking an experienced Power BI Developer / Business Intelligence Analyst to support a large-scale modernization effort impacting financial planning, analysis, and reporting capabilities. This role focuses on analyzing legacy reporting assets, improving data models, and delivering high-quality Power BI dashboards and paginated reports to business stakeholders. Project Context A multi-year financial systems transformation is underway, requiring remediation and redesign of interfaces, reporting programs, databases, and automated processes. The selected consultant will help transition legacy reporting and query assets (including WebFOCUS/Mainframe FOCUS) into modern reporting and data solutions, aligned to updated business processes and chart of accounts structures. Responsibilities

• Assess the current data environment and data structures to identify required transformations prior to dashboard/report development.
• Partner with leadership to develop an enterprise reporting roadmap.
• Review existing reports with business users and recommend improvements based on evolving needs.
• Collaborate with developers and end users to automate data transformation and reduce dependency on Excel-based pivot analysis.
• Read and document WebFOCUS/Mainframe FOCUS queries and convert them into T-SQL.
• Work with database administrators to design and implement database views and stored procedures to support reporting needs.
• Build and maintain Power BI dataflows and reusable datasets.
• Analyze financial data and provide recommendations to improve reporting data models.
• Administer a dedicated Power BI workspace (security, publishing, organization, and governance support).
• Train business users (including finance/comptroller-aligned teams) on how to use and interpret Power BI reporting outputs.

• Bachelor’s degree in a technology- or finance-related field or equivalent experience (year-for-year substitution acceptable).
• 3+ years of Business Intelligence experience.
• 2+ years building dashboards and reports in Microsoft Power BI.
• Experience with IBM DB2 databases.
• Strong SQL skills (including complex queries and performance-aware design).

Required Skills (KSAs)

• Building dashboards and interactive reports using Power BI.
• Developing Power BI Paginated Reports.
• Data governance best practices (security, access, stewardship, definitions, and quality).
• Knowledge of data management concepts: data warehousing, ODS, data lakes, master data management.
• Experience reporting on financial datasets (e.g., general ledger, purchasing, revenue).
• Understanding of dimensional modeling concepts: OLAP, star/snowflake schema.
• Familiarity with Power BI integrations across Microsoft tools (e.g., Power Automate, Power Apps, PowerPoint, Teams).
• Ability to translate business questions into clear visuals, metrics, and actionable insights.
• Experience implementing reporting solutions that combine multiple data sources.
• Knowledge of mainframe flat files.
• Familiarity with the SCRUM framework.

Preferred Qualifications

• Experience with Oracle Data Warehouse environments.
• Knowledge of mainframe programming languages and systems.
• Familiarity with ERP / financial systems.
• Hands-on experience with WebFOCUS.