What are the responsibilities and job description for the Sr. SQL / .NET / Power BI Developer for Project Web Application (PWA) environment position at DataPlus Technologies, Inc?
Job Details
Our team seeks qualified candidates to provide Sr. SQL Developer / .NET Developer / Power BI Developer services in Project Web Application (PWA) environment. We will consider both onsite and remote candidates for this position.
Requirements:
- Sr. SQL Developer & .NET Developer with Power BI/DAX experience resources will play a crucial role in optimizing PWA functionality.
- They are responsible for database management, including SQL Server development (T-SQL), stored procedures, performance tuning, 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.
- 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.
Duties:
- 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. Los Angeles Unified School District Master Services Agreement.
- 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.
Please be sure to fill out provided questionnaire. Applications with incomplete questionnaires will not be considered. Further, when filling out the questionnaire, please refrain from using terms such as negotiable, open, market, etc..., we have limited time to fill this position and may not be able to follow-up/ consider all applications that are not specific.
Please click "Apply Now" button, below, to apply for this job.
We will contact qualified candidates after review.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
