What are the responsibilities and job description for the Sr. SQL / .NET / Power BI SME Developer position at California Creative Solutions Inc.?
Minimum Qualifications:
- 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.
