Required Knowledge, Skills, and Abilities
Design, develop, and maintain BI solutions, including reports, dashboards, and data models, using Microsoft SQL Server, Power BI, SSRS, SSIS, and related tools.
Build and maintain the DataMart to support business data needs.
Collaborate with stakeholders to gather, document, and translate business requirements into technical specifications and BI solutions.
Perform data extraction, transformation, and loading (ETL) tasks to ensure accurate and timely data availability.
Provide first- and second-line technical support to internal users and vendors, ensuring data accuracy and resolving BI issues efficiently.
Optimize SQL queries, stored procedures, and database performance.
Develop and maintain Power BI dashboards, PowerApps, and automated workflows to streamline reporting and operations.
Participate in the full software development life cycle: analysis, design, development, testing, deployment, and user acceptance testing.
Document BI processes, solutions, data models, and user manuals.
Ensure compliance with data governance and security standards relevant to secure power and data environments.
Provide timely updates and escalate issues appropriately to ensure seamless delivery and support.
