Roles and Responsibilities
Design, build, and maintain data pipelines using Azure Data Factory and other Azure services.
Develop and optimize SQL queries for data extraction, transformation, and loading (ETL).
Implement data integration solutions across multiple sources and ensure data quality and consistency.
Analyze and understand business logic embedded in stored procedures and assist in rewriting or optimizing them for better performance and maintainability.
Design and implement robust data models (star/snowflake schemas), optimizing relationships, cardinality, and performance.
Develop advanced and high-performance DAX measures (time intelligence, complex calculations, optimization techniques).
Implement Row-Level Security (RLS) and role-based access to ensure secure, governed data consumption.
Build scalable, interactive Power BI reports and dashboards, following best practices for usability and performance.
Configure report scheduling, refresh, and delivery using Power BI Service, gateways, subscriptions, and alerts.
What is the expectation from the candidate’s current role/profile?