Senior Developer - Power BI

The Senior Power BI Developer is responsible for designing, developing, and maintaining business intelligence solutions using Power BI. The role involves gathering requirements from stakeholders, creating data models, developing interactive dashboards, and optimizing report performance.

data analysis, DAX, SQL, and Power BI best practices

Responsibilities:

• Gather and analyze business requirements for reporting and data visualization needs.
• Design and develop Power BI dashboards, reports, and data models to provide actionable insights.
• Create and optimize DAX calculations for performance and accuracy.
• Develop and maintain SQL queries to extract, transform, and load data.
• Ensure data accuracy, consistency, and security within Power BI reports.
• Collaborate with business users to refine dashboards and improve usability.
• Optimize report performance by managing data sources, relationships, and query efficiency.
• Conduct testing and validation to ensure reports meet business needs.
• Provide documentation and training for end-users on Power BI solutions.
• Stay updated on Power BI features and best practices to enhance reporting capabilities.
• Configure and manage workspaces, data refresh schedules, row-level security (RLS), and permissions in Power BI Service
• Collaborate with Data Engineers and Architects to build scalable data models and reporting solutions
• Strong proficiency in efficient data modeling, ensuring optimized performance and scalability using techniques like Aggregations, Indexing and Partitioning
• Ability to use Power BI APIs for scheduled refreshes, subscriptions, and monitoring usage analytics
• Advanced data transformations using Power Query
• Real-time reporting using DirectQuery and Composite models
• Knowledge of AI & ML features in Power BI would be a bonus
• Familiarity with Azure DevOps, Git and CI/CD for PowerBI version control and deployment pipelines

Essential Functions of the Role**:

• Flexibility in work schedule, off-hours for project implementation.
• Travel via plane or automobile both locally and internationally

Work Experience Requirements

• Number of Overall Years Necessary: 5-8
• A minimum of 3 years of experience in Microsoft Power BI
• A minimum or 3 years of experience business process analysis and design

Education Requirements

• BS/BA , or equivalent business experience in a business related discipline

Specialized Skills/Technical Knowledge:

• In-depth Power BI expertise, including report development, data modeling, DAX calculations, and performance optimization.
• Strong knowledge of SQL, including querying, data transformation, and performance tuning for Power BI datasets.
• Understanding of enterprise-wide data structures, integrations, and key business processes relevant to reporting needs.
• Experience working with various data sources such as SQL databases, Excel, APIs, and cloud-based data platforms.
• Ability to analyze and translate business requirements into technical solutions using Power BI.
• Familiarity with data governance, security, and compliance best practices within Power BI and related tools.
• Proficiency in Microsoft Excel, including advanced formulas, pivot tables, and data visualization techniques.
• Strong analytical and problem-solving skills to assess data quality, identify trends, and provide meaningful insights.
• Effective communication skills to work with stakeholders, explain technical concepts in business terms, and document reporting solutions.
• Ability to stay updated on Power BI advancements and apply new features to improve reporting efficiency.

Local Specifications (English and Local Language):

•      Fluency in English is required

Mode - Hybrid

Location- Gurugram