MS Power BI Developer

MS Power BI Developer Hyderabad / Vizag - Hybrid 1 -2 days a week from office Full time 8+ years Shift time : 2 pm - 11 pm IST Certifications: Microsoft Certified would be advantageous, but not necessary. XTG Panel: Rajesh Tatineni Job Summary:We are seeking a Mid -Level Power BI Developer to join our analytics team.The role involves developing robust reports and dashboards with financial data, working with advanced DAX calculations and SQL queries.You will have experience in building materialized views and integrating data from various sources, with expertise in Azure Synapse, PostgreSQL or similar data sources.Familiarity with Azure Databricks is a plus. Key Responsibilities: • Design, build, and maintain interactive Power BI reports and dashboards, focusing on financial data insights and performance metrics. • Perform functional testing of one's own as well as other reports done by peers in the same team. • Write complex SQL queries to retrieve, transform, and aggregate data, while building and managing materialized views in third -party applications to optimize reporting. • Implement and modify DAX functions for calculations and complex business logic in Power BI reports. • Pull data from multiple data sources such as Azure Synapse, PostgreSQL, Azure Databricks or similar ones. • Collaborate with business stakeholders to understand reporting requirements, define KPIs, and translate them into technical documentation. • Ensure scheduled schema, dataset refreshes, and Power BI report updates are completed successfully daily basis and on time. • Develop comprehensive documentation and test cases for reports and dashboards. Requirements Qualifications: • Bachelor's or Master's degree in a relevant field. • At least 5 years of experience with Power BI, with a proven track record of building reports and dashboards. • Strong proficiency in SQL and DAX. • Hands -on experience with Azure Synapse Analytics, PostgreSQL or similar data sources. • Experience working with Azure Databricks is an advantage. • Excellent communication skills for liaising with business stakeholders and gathering requirements. Benefits Skill AreaSkill DescriptionCandidate Self -Rating (1–5)Core BI Development  Power BI DevelopmentDesigning, building, and maintaining dashboards and reports in Microsoft Power BI DAX (Data Analysis Expressions)Writing advanced DAX queries for measures, calculated columns, and KPIs Power Query (M Language)Transforming and shaping data using Power Query Editor and M functions Data & SQL  SQLWriting queries, joins, stored procedures for data extraction and reporting Data ModelingDesigning star/snowflake schemas, relationships, and hierarchies for BI solutions Performance & Optimization  Report OptimizationOptimizing Power BI reports for performance, scalability, and usability Data Refresh & SchedulingManaging datasets, scheduled refreshes, and troubleshooting refresh failures Integration & Deployment  Power BI ServicePublishing, managing workspaces, row -level security, and sharing dashboards Integration with Excel / Other SourcesConnecting Power BI with Excel, APIs, and multiple external data sources Soft & General Skills  Communication & CollaborationAbility to gather reporting requirements and present insights to stakeholders Problem -SolvingAnalytical thinking to troubleshoot data/reporting issues Certifications (Optional)Microsoft Certified: Data Analyst Associate or equivalent