SE - PowerBI

Role Overview: As an SE specializing in PowerBI, your role will involve designing, developing, and deploying interactive dashboards and reports using Power BI. You will be responsible for optimizing Power BI reports to enhance usability, performance, and scalability. Additionally, you will be involved in integrating Power BI reports into other applications, developing robust data models, and implementing ETL workflows using SQL Server Integration Services (SSIS). Key Responsibilities: - Design, develop, and deploy interactive dashboards and reports in Power BI. - Optimize Power BI reports for usability, performance, and scalability. - Integrate Power BI reports into other applications using embedded analytics or APIs. - Develop and maintain robust data models to support reporting and analytics. - Implement ETL workflows using SQL Server Integration Services (SSIS) for data extraction, transformation, and loading. - Write, optimize, and maintain complex SQL queries, views, stored procedures, and functions. - Manage and maintain databases to ensure data integrity, security, and availability. - Design and maintain paginated reports using SQL Server Reporting Services (SSRS). Qualification Required: - Proficiency in SQL Server, including T-SQL programming. - Experience with SSIS for ETL processes and SSRS for report creation. - Strong understanding of data modeling concepts such as star schema and snowflake schema. - Familiarity with Power BI service for publishing, sharing, and scheduling reports. - Knowledge of data warehousing concepts and best practices. - Experience with DAX (Data Analysis Expressions) and M Query in Power BI. - Familiarity with Power BI embedded analytics and APIs. - Exposure to cloud-based data platforms like Azure SQL, Azure Data Factory, or similar.,