Power BI Developer

Job Description

Job Description

Power BI Developer – Job Description (JD)Job Title

Power BI Developer

Job Summary

We are looking for a talented Power BI Developer to design, develop, and maintain interactive dashboards, reports, and business intelligence solutions using Microsoft Power BI. The ideal candidate should have strong expertise in data modeling, DAX, Power Query, SQL, ETL processes, and data visualization. You will collaborate with business stakeholders to transform data into meaningful insights that support strategic decision-making.

Key Responsibilities

• Design, develop, and maintain Power BI dashboards and reports.
• Gather business requirements and translate them into BI solutions.
• Create interactive visualizations, KPIs, scorecards, and executive dashboards.
• Develop efficient data models and optimize report performance.
• Write DAX measures, calculated columns, and calculated tables.
• Perform data extraction, transformation, and loading (ETL).
• Connect Power BI to multiple data sources.
• Schedule data refreshes and manage report deployment.
• Implement Row-Level Security (RLS) and data governance.
• Optimize Power BI datasets and queries for performance.
• Collaborate with business analysts, data engineers, and developers.
• Maintain technical documentation and BI standards.

Required SkillsPower BI

• Power BI Desktop
• Power BI Service
• Power BI Report Server
• Power BI Gateway
• Dataflows
• Workspaces
• Dashboards
• Reports
• Paginated Reports
• Deployment Pipelines

Data Modeling

• Star Schema
• Snowflake Schema
• Fact & Dimension Tables
• Relationships
• Hierarchies
• Measures
• Calculated Columns
• Composite Models

DAX (Data Analysis Expressions)

• Measures
• Calculated Columns
• Calculated Tables
• Variables
• Time Intelligence
• Filter Context
• Row Context
• Ranking Functions
• Aggregations

Common DAX Functions:

• CALCULATE()
• FILTER()
• SUMX()
• AVERAGEX()
• ALL()
• RELATED()
• LOOKUPVALUE()
• RANKX()
• DATEADD()
• TOTALYTD()

Power Query (M Language)

• Data Cleaning
• Data Transformation
• Merge Queries
• Append Queries
• Pivot & Unpivot
• Custom Columns
• Parameters
• Data Profiling

SQL

• SELECT
• JOINs
• GROUP BY
• HAVING
• CTEs
• Window Functions
• Stored Procedures
• Views
• Performance Optimization

Databases:

• SQL Server
• Oracle
• MySQL
• PostgreSQL
• Snowflake
• Azure SQL Database

ETL Tools

• SQL Server Integration Services (SSIS)
• Azure Data Factory
• Power Query
• Informatica (Preferred)
• Talend (Preferred)

Cloud & Microsoft Technologies

• Microsoft Azure
• Azure Synapse Analytics
• Azure Data Lake Storage
• Azure SQL Database
• Microsoft Fabric (preferred)
• Microsoft Excel

Reporting & Visualization

• KPI Dashboards
• Executive Reports
• Drill-through Reports
• Drill-down Reports
• Bookmarks
• Tooltips
• Conditional Formatting
• Custom Visuals
• Maps
• Charts
• Slicers

Version Control & DevOps

• Git
• Azure DevOps
• GitHub
• CI/CD for Power BI (Preferred)

Preferred Qualifications

• Bachelor's degree in Computer Science, Information Technology, Data Analytics, or a related field.
• 2–6 years of experience in Power BI development.
• Strong knowledge of SQL and relational databases.
• Experience with Azure data services and cloud-based BI solutions.
• Familiarity with Agile/Scrum methodologies.

Preferred Certifications

• Microsoft Certified: Power BI Data Analyst Associate (PL-300)
• Microsoft Certified: Azure Data Fundamentals (DP-900)
• Microsoft Certified: Azure Data Engineer Associate (DP-203)
• Microsoft Certified: Fabric Analytics Engineer Associate (DP-600)

Soft Skills

• Strong analytical and problem-solving skills.
• Excellent communication and presentation abilities.
• Ability to gather and interpret business requirements.
• Attention to detail.
• Time management and organizational skills.
• Team collaboration.