Key Responsibilities :
- Develop and optimize T-SQL queries for performance, efficiency, and scalability in a high-volume transactional environment.
- Design and implement SQL-based ETL processes to extract, transform, and load data into data warehouses and other databases.
- Develop and maintain Power BI dashboards, reports, and data visualizations to facilitate business analysis and decision-making.
- Work with business analysts and stakeholders to understand reporting requirements and design custom BI solutions.
- Perform data validation, troubleshooting, and debugging to ensure the accuracy and consistency of reports and data models.
- Monitor and optimize database performance, query performance, and Power BI report performance.
- Collaborate with other team members to implement data integration solutions and ensure proper data flow.
- Maintain and manage Power BI workspaces, ensuring data security, user access, and version control.
- Stay up-to-date with the latest Power BI features and best practices, implementing them to continuously improve reporting solutions.
- Create documentation for reports, dashboards, and SQL processes to ensure maintainability and ease of understanding.
Skills Required
Power Bi, Data Visualization, Data Modeling, Sql, T-sql, Etl