Junior Power BI Developer/Analyst
Description
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.
Skills
Sign in to read and join the discussion.