Job Description :
Key Responsibilities :
Power BI Report Development (Prime Focus) :
- Lead the end-to-end development of high-quality, interactive Power BI reports, dashboards, and KPI scorecards that meet diverse business needs.
Data Modeling & Transformation :
Connect to various data sources, efficiently import and transform raw data, and prepare it for optimal Business Intelligence consumption using Power Query.Develop tabular and multidimensional data models that are compatible with data warehouse standards and best practices.Build robust Analysis Services reporting models to support complex analytical requirements.DAX & Advanced Calculations :
Demonstrate expert proficiency in writing advanced DAX (Data Analysis Expressions) queries and implementing complex calculations within Power BI Desktop to derive meaningful insights.Security Implementation :
Implement robust Row-Level Security (RLS) on data within Power BI models to ensure data confidentiality and compliance.Possess a strong understanding of application security layer models in Power BI and configure data access restrictions for users based on their managed portfolios or roles.Requirements Gathering & Analysis :
Collaborate closely with business stakeholders to thoroughly understand their requirements and translate them into precise functional specifications for reporting applications.Apply strong analytical thinking to translate complex data into informative, clear, and visually compelling reports and dashboards.Stakeholder & User Support :
Utilize outstanding interpersonal, presentation, and communication skills to effectively discuss requirements with client teams and internal stakeholders.Provide prompt and effective resolution to queries from end-users facing challenges in accessing, understanding, or utilizing Power BI reports.Continuous Improvement :
Contribute to the continuous improvement of reporting processes, data quality, and BI solutions.Required Skills & Qualifications :
Experience : 8-10 years of hands-on experience in data-specific roles, with a proven grip over data analytics concepts and practices.
Power BI Expertise (Mandatory) :
1. Extensive hands-on experience in reporting and visualization using Power BI (Power BI Desktop, Power BI Service).
2. Expertise in developing visual reports, KPI scorecards, and interactive dashboards.
3. Demonstrated ability to connect data sources, import data, and perform complex data transformations.
4. Strong proficiency in writing and optimizing DAX queries and implementing advanced-level calculations.
5. Proven experience in implementing Row-Level Security (RLS) and understanding application security layer models in Power BI.
SQL Server (Mandatory) : Strong proficiency in SQL Server for data extraction, manipulation, and query optimization.Data Modeling : Experience in building Analysis Services reporting models (tabular and / or multidimensional) and ensuring compatibility with data warehouse standards.Analytical Thinking : Demonstrated analytical thinking capabilities for translating business requirements into effective reports and visuals.Communication Skills (Mandatory) : Outstanding interpersonal, presentation, and verbal / written communication skills. Ability to effectively discuss requirements and provide support to diverse audiences (client teams, internal teams, end-users).Bonus Points if You Have :
MS Excel Macro programming skills.Experience with other BI tools or cloud data platforms (e.g., Azure Synapse, AWS Redshift, Google BigQuery).ref : hirist.tech)