What are the responsibilities and job description for the Sr. SQL Developer / .NET Developer / Power BI SME position at Estrada Consulting Incorporated?
Sr. SQL Developer / .NET Developer / Power BI SME
Hybrid onsite-LA
Submission requires Degree copy and references
Resource that is a SQL Developer, .NET Developer, and a Power BI skilled person. Someone that can do SQL Dev and database management, but also is .NET application Developer and Power Bi Developer.
C. 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.
- 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.
About Estrada Consulting Incorporated :
Estrada Consulting, Inc. (ECI) delivers technology-enabled services and solutions to clients all over the USA and British Columbia. We provide system integration, custom application development, data warehouse and business intelligence, project management, custom reporting solutions and consulting services to mid-size and large enterprises in all major industries. The Company headquarters is in Sacramento, California, and was established in year 2000. Visit http : / / www.estradaci.com / to learn about our projects, managed services, awards and certifications delivering value for a range of businesses and government agencies.
