Senior Power BI Architect - Government Financial Systems

We are seeking a highly experienced Senior Power BI Architect to lead the design, development, and implementation of an enterprise financial reporting and business intelligence solution for a potential Oklahoma state government engagement., The Senior Power BI Architect will serve as the primary technical lead responsible for designing and building a comprehensive Power BI reporting environment from the ground up.

This role involves integrating financial data from PeopleSoft, SharePoint, and other enterprise systems; developing advanced data models; creating financial reporting dashboards; and establishing a sustainable reporting architecture that can be maintained and expanded over time.

The selected consultant will collaborate with LocalPeople’s PeopleSoft integration specialists, project leadership, financial subject matter experts, and agency stakeholders., * Lead the architecture, design, development, deployment, and maintenance of an enterprise Power BI dashboard suite.

• Develop advanced Power BI semantic models, relationships, DAX measures, calculated fields, and reporting structures.
• Integrate data from PeopleSoft Financials, SharePoint, and additional financial data sources.
• Collaborate with PeopleSoft functional and technical specialists to identify and validate financial reporting data.
• Develop dashboards supporting governmental accounting, reconciliations, financial controls, annual audits, and regulatory reporting.
• Support Generally Accepted Accounting Principles (GAAP) Package tracking and Schedule of Expenditures of Federal Awards (SEFA) reporting.
• Establish appropriate data validation, reconciliation, and reporting accuracy controls.
• Collaborate with financial leadership and business stakeholders to translate reporting requirements into technical solutions.
• Design reporting solutions that comply with applicable state IT security, governance, and accessibility standards.
• Develop comprehensive documentation covering data connections, transformation logic, semantic models, DAX calculations, and architectural decisions.
• Provide knowledge transfer and technical training to agency personnel.
• Support ongoing dashboard maintenance, enhancements, troubleshooting, and ad hoc reporting requests.
• Ensure solutions are maintainable, scalable, and free from unnecessary vendor-specific dependencies., * Previous experience integrating Power BI with Oracle PeopleSoft Financials and Supply Chain Management (FSCM).
• Experience working with Oklahoma state agencies or other state government organizations.
• Understanding of governmental accounting, state fiscal policies, internal controls, and audit processes.
• Experience developing GAAP-related reporting, SEFA reporting, federal award tracking, or government financial reconciliation dashboards.
• Previous experience supporting Comptroller, Controller, CFO, or equivalent financial management offices.
• Familiarity with Microsoft Fabric, Azure-based data services, and enterprise Power BI governance.
• Microsoft Power BI or Fabric certifications.

Engagement Details

This is an anticipated 1099 independent contractor opportunity supporting a public-sector enterprise reporting initiative.

The consultant is expected to serve as the primary Power BI technical resource during implementation, with the possibility of continued support, maintenance, and enhancement work following initial deployment.

The project will be managed by LocalPeople LLC, with additional PeopleSoft integration and financial systems expertise available as needed.

• Minimum five years of professional experience developing Power BI dashboards, including enterprise-level solutions.
• Demonstrated experience independently architecting and maintaining complex Power BI reporting environments.
• Advanced proficiency in Power BI Desktop, Power BI Service, Power Query, DAX, data modeling, and data transformation.
• Experience integrating multiple enterprise data sources, including relational databases and SharePoint.
• Strong SQL skills and experience developing complex financial reporting datasets.
• Demonstrated experience with data reconciliation, validation, and financial analytics.
• Ability to translate business requirements into technical architectures and production-ready reporting solutions.
• Experience developing technical documentation and supporting knowledge transfer.
• Strong communication skills and ability to work directly with senior financial leadership and technical stakeholders.
• Ability to work independently while coordinating with an established systems integration and project management team., * How many years of professional experience do you have designing, developing, and maintaining Microsoft Power BI dashboards?
• Have you independently designed and implemented an enterprise Power BI dashboard environment from the ground up?
• How many years of hands-on experience do you have developing advanced DAX measures, Power Query transformations, calculated fields, and relational data models?
• Do you have experience integrating Power BI with Oracle PeopleSoft, SharePoint, or other enterprise financial systems?
• Have you developed Power BI financial reporting solutions for state or local government agencies, including reconciliation, audit reporting, GAAP, or SEFA reporting?

Final project schedule, duration, work location expectations, and compensation will be established based on contract award and agency requirements.

LocalPeople LLC www.localpeople.us

This opportunity is contingent upon contract award and is not a guarantee of employment or engagement.

Pay: $80.00 - $90.00 per hour

Expected hours: 40.0 per week

LocalPeople LLC is an established technology consulting firm specializing in enterprise resource planning (ERP), systems integration, financial systems modernization, and public-sector technology solutions. We have extensive experience supporting Oklahoma state agencies with PeopleSoft implementations, integrations, application support, financial workflows, and reporting solutions.