Source description
About the role
Key Responsibilities Data Modeling & Power BI Development Design, develop, and maintain high-performance Power BI dashboards and reports. Build robust, scalable data models using advanced DAX (Data Analysis Expressions) to implement complex business logic, time-intelligence calculations Optimize existing reports and data models for speed, efficiency, and scalability. Advanced Data Extraction & Transformation Write, optimize, and debug complex SQL queries (including subqueries, CTEs, window functions, and advanced joins) to extract data from various enterprise data warehouses. Ensure data integrity and consistency between source systems and front-end reports. Required Technical Skills & Qualifications Must-Haves (Non-Negotiable) Power BI & DAX: Minimum of 13 years of hands-on experience building Power BI solutions. Deep understanding of evaluation contexts (Filter Context vs. Row Context) and complex DAX functions (CALCULATE, FILTER, ALL, EARLIER, and time-intelligence). Expert SQL Skills: High proficiency in writing complex, optimized SQL queries. Must be comfortable handling large datasets, writing Common Table Expressions (CTEs), utilizing window functions (RANK, LEAD/LAG, PARTITION BY), and analyzing query performance. Nice-to-Haves Data Modeling: Strong understanding of relational database concepts, star/snowflake schemas, and data normalization/denormalization. Familiarity with cloud data platforms like Snowflake, Azure Synapse, or AWS Redshift. Basic knowledge of Python for data manipulation. Soft Skills & Core Competencies Problem-Solving: A natural curiosity to dig into data anomalies and find the root cause of discrepancies. Communication: Ability to explain complex technical data constraints to non-technical business users clearly. Attention to Detail: Precision in data validation to ensure business decisions are made on 100% accurate reporting. Key Responsibilities Data Modeling & Power BI Development Design, develop, and maintain high-performance Power BI dashboards and reports. Build robust, scalable data models using advanced DAX (Data Analysis Expressions) to implement complex business logic, time-intelligence calculations Optimize existing reports and data models for speed, efficiency, and scalability. Advanced Data Extraction & Transformation Write, optimize, and debug complex SQL queries (including subqueries, CTEs, window functions, and advanced joins) to extract data from various enterprise data warehouses. Ensure data integrity and consistency between source systems and front-end reports. Required Technical Skills & Qualifications Must-Haves (Non-Negotiable) Power BI & DAX: Minimum of 13 years of hands-on experience building Power BI solutions. Deep understanding of evaluation contexts (Filter Context vs. Row Context) and complex DAX functions (CALCULATE, FILTER, ALL, EARLIER, and time-intelligence). Expert SQL Skills: High proficiency in writing complex, optimized SQL queries. Must be comfortable handling large datasets, writing Common Table Expressions (CTEs), utilizing window functions (RANK, LEAD/LAG, PARTITION BY), and analyzing query performance. Nice-to-Haves Data Modeling: Strong understanding of relational database concepts, star/snowflake schemas, and data normalization/denormalization. Familiarity with cloud data platforms like Snowflake, Azure Synapse, or AWS Redshift. Basic knowledge of Python for data manipulation. Soft Skills & Core Competencies Problem-Solving: A natural curiosity to dig into data anomalies and find the root cause of discrepancies. Communication: Ability to explain complex technical data constraints to non-technical business users clearly. Attention to Detail: Precision in data validation to ensure business decisions are made on 100% accurate reporting.