Roles/Responsibilities:
 Design and implement data models, data integration, and data transformation processes to ensure accurate,
reliable data analysis for business users.
 Lead Power BI and Microsoft Project development and enhancements to meet evolving business
requirements, investigating and resolving complex production issues within the BI ecosystem.

 Collaborate with project teams and external IT business partners to design new technical solutions,
ensuring smooth resolution of any issues that arise.
 Serve as the Power BI expert, guiding the development of dashboards and reports, and providing directions
to ensure alignment with project goals.
 Work closely with Microsoft Project resources to gather requirements, design, develop, and test solutions,
while preparing comprehensive documentation, including Business
 Requirements Documents (BRD), Technical Design Specifications (TDS), and Source - to-Target Mapping
(STM).
 Facilitate User Acceptance Testing (UAT), Integration Testing, and Regression Testing, ensuring the
accuracy and completeness of all BI development efforts.
 Integrate data from multiple sources into Power BI reports, including pulling Project
 Online data, optimizing SQL Server performance, and leveraging SSRS if needed.
 Optimize existing reports, including program metrics, statistical, and demographic reports,
 while identifying opportunities for performance improvements.
 Collaborate with (PC) clients to support Extract, Transform, Load (ETL) reporting,
 production support, enhancements, and troubleshooting activities.
 Work with the existing QuickBase application to develop and generate custom reports in Microsoft Project
using BI tools or SSRS.
 Devise and execute a strategic vision for Power BI, aligning it with organizational goals and fostering a
culture of data-driven decision-making.
 Lead the end-to-end implementation of Power BI solutions, from data acquisition and
 transformation to the creation of dynamic and impactful dashboards.
 Conduct regular code reviews, ensuring adherence to best practices in Power BI development.
 Implement and enforce data governance policies specific to Power BI solutions.
 Connect Project Online to ensure data quality, compliance, and the secure handling of sensitive
information.
Mandatory Skills:
Minimum of five (5) years of demonstrated experience in the services listed
in the Statement of Work.
1. As part of Project Web Application (PWA) environment, a Sr. SQL Developer .NET Developer with
Power BI using DAX experience plays a crucial role in optimizing PWA functionality.
2. They are responsible for database management, including SQL Server development (T-SQL), stored
procedures, performance tuning, and Extract, Transform, and

3. Load (ETL) processes to ensure data integrity and efficiency. They also develop and integrate custom .NET
applications using C# and ASP.NET, enabling advanced automation and workflow enhancements within
PWA. Resources will also be required to developed code in Microsoft Project Online to implement features
such as Stoplights.
4. Additionally, expertise in Power BI development is essential for creating dynamic dashboards, reports, and
embedded analytics that improve project visibility and resource planning. This role involves configuring
custom fields, security permissions and reporting periods while ensuring seamless integration with
SharePoint, Power BI, and other Microsoft tools. By combining SQL, .NET development, and Power BI
expertise, this role enhances PWA functionality, providing project stakeholders with actionable insights and
a scalable, data-driven decision-making platform.
5. Design and implement data models, data integration, and data transformation processes to ensure accurate,
reliable data analysis for business users.
6. Lead Power BI and Microsoft Project development and enhancements to meet evolving business
requirements, investigating and resolving complex production issues within the BI ecosystem.
7. Collaborate with project teams and external IT business partners to design new technical solutions, ensuring
smooth resolution of any issues that arise.
8. Serve as the Power BI expert, guiding the development of dashboards and reports, and providing directions
to ensure alignment with project goals.
9. Work closely with Microsoft Project resources to gather requirements, design, develop, and test solutions,
while preparing comprehensive documentation, including Business
10. Requirements Documents (BRD), Technical Design Specifications (TDS), and Source -to-Target Mapping
(STM).
11. Facilitate User Acceptance Testing (UAT), Integration Testing, and Regression Testing,ensuring the
accuracy and completeness of all BI development efforts.
12. Integrate data from multiple sources into Power BI reports, including pulling Project
13. Online data, optimizing SQL Server performance, and leveraging SSRS if needed.
14. Optimize existing reports, including program metrics, statistical, and demographic reports,while identifying
opportunities for performance improvements.
15. Collaborate with (PC) clients to support Extract, Transform, Load (ETL) reporting,production support,
enhancements, and troubleshooting activities.
16. Work with the existing QuickBase application to develop and generate custom reports in Microsoft Project
using BI tools or SSRS.
17. Devise and execute a strategic vision for Power BI, aligning it with organizational goals and fostering a
culture of data-driven decision-making.
18. Lead the end-to-end implementation of Power BI solutions, from data acquisition and transformation to the
creation of dynamic and impactful dashboards.
19. Conduct regular code reviews, ensuring adherence to best practices in Power BI development.

20. Implement and enforce data governance policies specific to Power BI solutions.
21. Connect Project Online to ensure data quality, compliance, and the secure handling of sensitive information.

BE STAFFING SOLUTIONS, LLC

Latest Jobs

Sr. SQL / .NET / Power BI SME Developer