Power BI Developer

Weekday AI; Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Weekday AI is seeking a Power BI specialist to develop comprehensive BI solutions for client projects in Bengaluru and other cities. You will design data models, dashboards and KPI scorecards, while implementing robust security and data governance policies.

The role requires strong SQL, DAX and MS BI Stack expertise, with 2-3 years in data-focused roles, and excellent client communication skills.

Qualifications

• Mandatory Power BI report development.
• Experience building Analysis Services models (SSAS).
• Developing visual reports, KPI scorecards and dashboards in Power BI desktop.
• Connecting data sources, importing and transforming data for BI.
• Strong analytical thinking to translate data into reports and visuals.
• Knowledge of row-level security and security models in Power BI.
• Proficiency in writing advanced DAX queries.
• Design methodology and project documentation experience.
• Develop tabular and multidimensional models compatible with DW standards.
• Excellent communication with client teams and internal stakeholders.
• Experience with MS BI Stack: Power BI, SSAS, SSRS, SSIS.
• Experience with BI tools including Power BI, Tableau, SAP.
• 2-3 years in data-focused roles.
• Knowledge of relational and multidimensional database design.

Responsibilities

• Develop Power BI reports and data models for client projects.
• Create dashboards, KPI scorecards and visuals.
• Connect, transform and model data for BI solutions.
• Implement data security including row-level security.
• Collaborate with clients to translate requirements into analytics solutions.
• Optimize performance of dashboards and reports.
• Engage with UX/UI teams for visualization best practices.

Skills

Power BI development

DAX

SQL

Data visualization

SSAS/SSRS/SSIS

Tableau

SAP

Azure/Azure Synapse

Data governance

Client communication

Tools

Power BI

Tableau

SAP

Job description

This role is for one of Weekday’s clients

Min Experience: 4+ years
Location: Bengaluru, Pune, Gurgaon, Haryana, India
JobType: full-time

Mandatory:

• Power BI Report development.
• Building Analysis Services reporting models.
• Developing visual reports, KPI scorecards, and dashboards using Power BI desktop.
• Connecting data sources, importing data, and transforming data for Business intelligence.
• Analytical thinking for translating data into informative reports and visuals.
• Capable of implementing row-level security on data along with an understanding of application security layer models in Power BI.
• Should have an edge over making DAX queries in Power BI desktop.
• Expert in using advanced-level calculations on the data set.
• Responsible for design methodology and project documentaries.
• Should be able to develop tabular and multidimensional models that are compatible with data warehouse standards.
• Very good communication skills must be able to discuss the requirements effectively with the client teams, and with internal teams.
• Experience working with Microsoft Business Intelligence Stack having Power BI, SSAS, SSRS, and SSIS
• Mandate to have experience with BI tools and systems such as Power BI, Tableau, and SAP.
• Must have 2-3years of experience in data-specific roles.
• Have knowledge of database fundamentals such as multidimensional database design, relational database design, and more
• Knowledge of all the Power BI products (Power Bi premium, Power BI server, Power BI services, Powerquery etc)
• Grip over data analytics
• Interact with customers to understand their business problems and provide best-in-class analytics solutions
• Proficient in SQL and Query performance tuning skills
• Understand data governance, quality and security and integrate analytics with these corporate platforms
• Attention to detail and ability to deliver accurate client outputs
• Experience of working with large and multiple datasets / data warehouses
• Ability to derive insights from data and analysis and create presentations for client teams
• Experience with performance optimization of the dashboards
• Interact with UX/UI global functions and design best in class visualization for customers harnessing all product capabilities
• Resilience under pressure and against deadlines.
• Proactive attitude and an open outlook.
• Strong analytical problem-solving skills
• Skill in identifying data issues and anomalies during the analysis
• Strong business acumen demonstrated an aptitude for analytics that incite action
• Ability to execute on design requirements defined by business
• Ability to understand required Power BI functionality from wireframes/ requirement documents
• Ability to architect and design reporting solutions based on client needs.
• Being able to communicate with internal/external customers, desire to develop communication and client-facing skills.
• Ability to seamlessly work with MS Excel working knowledge of pivot table and related functions

Good to have:

• Experience in working with Azure and connecting synapse with Tableau
• Demonstrate strength in data modelling, ETL development, and data warehousing
• Knowledge of leading large-scale data warehousing and analytics projects using Azure, Synapse, MS SQL DB
• Good knowledge of building/operating highly available, distributed systems of data extraction, ingestion, and processing of large data sets

Must-have skills

Power BI, Fabric, DAX

Good-to-have skills

sql, etl, Data Warehousing