Job Location - Whippany NJ (Day One Onsite - Hybrid)
Key Responsibilities
- Design, develop, and deploy interactive Power BI reports, dashboards, and scorecards.
- Gather business requirements and translate them into effective BI solutions.
- Develop and optimize data models using star and snowflake schemas.
- Create complex DAX calculations, measures, KPIs, and business metrics.
- Develop 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.
- 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
Salary Transparency
The primary focus is to help organizations design, develop, and optimize their data infrastructure and systems. They help organizations enhance data processes, and leverage data effe
Capgemini discloses salary range information in compliance with state and local pay transparency obligations. The disclosed range represents the lowest to highest salary we, in good faith, believe we would pay for this role at the time of this posting, although we may ultimately pay more or less than the disclosed range, and the range may be modified in the future. The disclosed range takes into account the wide range of factors that are considered in making compensation decisions including, but not limited to, geographic location, relevant education, qualifications, certifications, experience, skills, seniority, performance, sales or revenue-based metrics, and business or organizational needs. At Capgemini, it is not typical for an individual to be hired at or near the top of the range for their role. The base salary range for the tagged location is $80420 to $106050 /yearly.
This role may be eligible for other compensation including variable compensation, bonus, or commission. Full time regular employees are eligible for paid time off, medical/dental/vision insurance, 401(k), and any other benefits to eligible employees.
Note: No amount of pay is considered to be wages or compensation until such amount is earned, vested, and determinable. The amount and availability of any bonus, commission, or any other form of compensation that are allocable to a particular employee remains in the Company's sole discretion unless and until paid and may be modified at the Company's sole discretion, consistent with the law.
ctively to drive business outcomes.
For this role, the gross annual base salary range is $80420 to $106050 for a full-time position. This range covers base pay only; we will discuss any bonuses, incentives, and benefits during the hiring process. Your exact offer will depend on objective, job-related factors - like your experience, skills, and qualifications - in line with our fair pay principles. If a collective labour agreement applies to this role, we will share the relevant pay scale details with you. Note: We never ask about your current or past salary during our recruitment process.
