What are the responsibilities and job description for the Sr. SQL / .NET / Power BI SME Developer position at CCS Global Tech?
Job Details
CCS Global Tech is a rapidly growing Information Technology company with a diverse portfolio of technology products and services and a large network of industry partnerships. With over 22 years of being a successful business with a global talent pool and presence, CCS is a certified Microsoft Gold Partner and specializes in delivering expert Microsoft based solutions for technical and business needs. We have been recognized by Inc. 500 Magazine as one of the fastest growing small companies in the Unites States.
we are a Tier 1 vendor for the City and County of San Francisco for Cloud Services, Staffing Services and Training Services. For this multi-year opportunity with a diverse set of needs to address, we are currently focusing on establishing partnerships with individuals as well as companies who can help us enhance our overall service portfolio, cut lead times, and ultimately help us deliver successfully. We currently hold sizable Government accounts in the San Francisco bay area including City and County of San Francisco, San Mateo County, and Santa Clara County.
We take great pride in our global reach and local influence. Your experience alongside our highly skilled and talented internal team who guide you along the way, offers key insights into what helps you stand out in a competitive job market.
If you are a partner company, please submit resumes with contact information of your own W2 Consultants only. Submitted consultants are expected to have excellent communication skills.
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.
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.
