Develop, optimize, and maintain complex SQL queries, stored procedures, and database structures to support reporting and analytics needs.
Design and implement interactive dashboards and reports in Power BI, ensuring clarity and usability for stakeholders.
Collaborate with data engineers, analysts, and business teams to understand data requirements and translate them into efficient SQL queries and Power BI solutions.
Perform ETL (Extract, Transform, Load) processes to prepare data for reporting and analysis.
Create robust data models in Power BI, using DAX and Power Query (M Code) for advanced analytics and calculations.
Ensure data accuracy and integrity in all reports and dashboards by conducting thorough testing and validation.
Monitor and improve query performance and database efficiency, ensuring scalability and reliability.
Provide ongoing support and training for Power BI users to empower self-service reporting.
Document data pipelines, queries, and reporting processes to ensure clarity and maintainability.