Junior Power BI Developer/Analyst

Key ResponsibilitiesData Modeling & Power BI DevelopmentDesign, 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 calculationsOptimize existing reports and data models for speed, efficiency, and scalability.Advanced Data Extraction & TransformationWrite, 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 & QualificationsMust-Haves (Non-Negotiable)Power BI & DAX: Minimum of 1–3 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 CompetenciesProblem-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.