T-Sql Lead

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.