1-3 year Exp Junior Power BI Developer/Analyst

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 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 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.