Job
Description
Candidate will be responsible for developing and managing BI solutions, building reports, and providing insights through data visualization by Microsoft Power BI. The role requires a basic understanding of financial data and the ability to translate complex business requirement into intuitive reports and dashboard. : Develop, design, and implement Power BI dashboards and reports that provide actionable insights into data. Develop, maintain, and optimize SSAS models (Tabular). Design and develop complex SQL queries, stored procedures, views, and functions. Write DAX queries and functions for advanced calculations and data manipulation. Optimize Power BI reports for performance and scalability. Ensure data accuracy and integrity by implementing best practices in data validation and error handling. Automate data refresh schedules and ensure real-time data availability. Collaborate with stakeholders to gather requirements and provide reporting solutions. Troubleshoot issues related to data sources, models, and reports. Maintain Power BI documentation and user guides. Keep up to date with the latest trends and features in Power BI and other related technologies to continuously improve reporting and analytics capabilities. Develop and manage Power BI Solution to meet business needs. Design and create interactive dashboard and reports. Build Data models and DAX formula. Connect to various data sources and extract data. Work with stakeholders to understand their Requirements and translate them into technical specifications. Troubleshoot and debug Power BI Solution. Optimize data models for performance and scalability. Should have knowledge and experience in prototyping, designing and requirement analysis. Strong understanding of data modelling and DAX. Ability to work independently and as a part of team. Excellent communication and presentation skills. Develop, test and operationalize Power BI semantic data models. Document data models, BI solutions, and development processes. Must have skills: Power BI Service, SQL, SSAS, DAX, Power Query (M Query), Data Modelling. Qualifications Qualifications B.E, B.Tech, M.Tech, MCA. 3+ years of experience as a Power BI Developer. Strong proficiency in Power BI, including dashboard design, data modeling, and report development. Experience working with Power Query. Expertise in DAX (Data Analysis Expressions) for advanced data calculations and transformations. Familiarity with SQL for data extraction, manipulation, and querying. Strong expertise in SSAS (Tabular) Proficiency in SQL Server, T-SQL, and database development. Experience working with financial datasets, ERP systems, and financial reporting. Knowledge of finance related KPIs, metrics, and reporting structures.
