Power BI Developer

About the role

The successful candidate will be responsible for designing, developing, and deploying interactive Power BI reports, dashboards, and scorecards. They will gather business requirements and translate them into effective BI solutions, develop and optimize data models, and implement Row-Level Security (RLS) and ensure data governance compliance.

Responsibilities

• Design, develop, and deploy interactive Power BI reports, dashboards, and scorecards.
• Gather business requirements and translate them into effective BI solutions.
• Create and optimize data models using star and snowflake schemas.
• Develop and optimize complex DAX calculations, measures, KPIs, and business metrics.
• Create and maintain Power Query (M Language) transformations.
• Connect Power BI to multiple data sources including SQL Server, Azure, Oracle, SAP, Excel, APIs, and cloud platforms.
• Optimize report performance and troubleshoot data-related issues.
• Build and manage data refresh schedules, gateways, and security models.
• Implement Row-Level Security (RLS) and ensure data governance compliance.
• Collaborate with business users, data engineers, analysts, and project teams.
• Maintain documentation, data dictionaries, and technical specifications.
• Support production deployments and provide ongoing enhancements.

Requirements

• Strong experience with Microsoft Power BI Desktop and Power BI Service.
• Proficiency in DAX (Data Analysis Expressions).
• Strong knowledge of Power Query (M Language).
• Experience with SQL and relational databases.
• Expertise in data modeling and dimensional modeling concepts.
• Understanding of ETL/ELT processes.
• Experience with Azure Data Factory, Azure Synapse, Databricks, or Fabric is preferred.
• Knowledge of data warehousing concepts.
• Familiarity with REST APIs and cloud data sources.
• Experience with Power BI Premium and deployment pipelines is a plus.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Business Analytics, or related field.
• Minimum 5 years of experience in data analysis, BI, or related fields.
• Proven track record of delivering high-quality BI solutions.
• Ability to work independently and collaboratively with cross-functional teams.
• Strong problem-solving and analytical skills.
• Excellent communication and presentation skills.

Skills

• Microsoft Power BI Desktop and Power BI Service.
• DAX (Data Analysis Expressions).
• Power Query (M Language).
• SQL and relational databases.
• Data modeling and dimensional modeling concepts.
• ETL/ELT processes.
• Azure Data Factory, Azure Synapse, Databricks, or Fabric.
• Data warehousing concepts.
• REST APIs and cloud data sources.
• Power BI Premium and deployment pipelines.

Benefits

Capgemini offers a comprehensive benefits package including flexible work arrangements, healthcare, financial well-being programs, paid time off, and more. Employees are also eligible for a 401(k) plan and Employee Share Ownership Plan.

Pay

The gross annual base salary range for this role is $80,420 to $106,050 for a full-time position. This range covers base pay only; we will discuss any bonuses, incentives, and benefits during the hiring process.

Schedule

This role is based in Whippany, NJ and requires a Day One Onsite - Hybrid schedule.