Power BI Developer - Data Analytics

Job Description

About the Job : We are seeking a highly skilled and experienced Power BI Developer to join our dynamic team. In this role, you will be instrumental in transforming raw data into insightful and actionable visualizations that drive business decisions. You will be responsible for the entire lifecycle of dashboard development, from understanding business needs and designing user-friendly interfaces in Figma to building robust data models and implementing sophisticated DAX calculations in Power BI. Collaboration with stakeholders and cross-functional teams is crucial to ensure the delivery of high-quality, impactful BI solutions. Job Summary : As a Power BI Developer, you will leverage your deep expertise in data visualization, SQL/DAX, and UI/UX design principles using Figma to create interactive and visually compelling dashboards. You will work closely with business users to gather requirements, design intuitive interfaces, develop efficient data models, and implement robust reporting solutions within the Power BI ecosystem. Your ability to translate business needs into technical specifications and effectively communicate analytical findings will be key to your success in this role. Key Responsibilities : - Dashboard Design and Development : Design, develop, and deploy interactive dashboards and visual reports using Power BI Desktop and Power BI Service. - UI/UX Prototyping with Figma : Collaborate with business users to understand their reporting needs and translate them into user-friendly wireframes, mockups, and prototypes using Figma. - Figma to Power BI Implementation : Convert Figma designs into fully functional and aesthetically pleasing Power BI dashboards, ensuring adherence to UI/UX best practices. - DAX Development : Write and optimize complex DAX (Data Analysis Expressions) calculations to derive meaningful insights and implement business logic within Power BI. - SQL Querying and Optimization : Develop and optimize complex SQL queries to extract, transform, and load data from various data sources. This includes writing joins, window functions, Common Table Expressions (CTEs), and stored procedures. - Data Modeling : Design and implement efficient and scalable data models within Power BI, adhering to data warehousing best practices (e.g., star schema, snowflake schema). - Security Implementation : Implement and manage row-level security (RLS) and other security measures within Power BI to ensure data privacy and appropriate access control. - Performance Tuning : Identify and implement performance optimization techniques within Power BI reports and data models to ensure optimal responsiveness and efficiency. - Data Source Integration : Integrate Power BI with diverse data sources, including databases (e.g., SQL Server, Azure Synapse), cloud platforms, APIs, and other relevant systems. - Stakeholder Communication : Present analytical findings, dashboard designs, and technical solutions to stakeholders in a clear, concise, and compelling manner. - Requirements Gathering : Actively participate in gathering business requirements through user interviews, workshops, and documentation analysis. - Agile Collaboration : Work effectively within Agile/Scrum teams, contributing to sprint planning, daily stand-ups, and retrospectives, ensuring timely delivery of assigned tasks. - Documentation : Create and maintain comprehensive documentation for developed dashboards, data models, and processes. - Continuous Improvement : Stay updated with the latest Power BI features, Figma updates, and industry best practices to continuously improve the quality and efficiency of BI solutions. Required Skills : - Experience : Minimum of 7 years of demonstrable experience in Business Intelligence and Data Analytics, with a strong focus on Power BI development. - Power BI Expertise : Proven hands-on expertise in Power BI Desktop and Power BI Service, including advanced DAX capabilities (e.g., CALCULATE, measures, calculated columns, time intelligence functions). - Figma Proficiency : Strong practical experience using Figma for UI/UX prototyping, wireframing, and creating visually appealing dashboard designs. Ability to translate design specifications into functional Power BI reports. - SQL Proficiency : Deep understanding and proficiency in SQL, with the ability to write complex queries involving multiple joins, window functions, CTEs, and stored procedures across various database systems. - Data Warehousing and Modeling : Solid understanding of data warehousing concepts, dimensional modeling (star and snowflake schemas), and ETL/ELT processes. - Cloud Data Experience (Preferred) : Experience working with cloud-based data sources such as Azure Synapse Analytics, SQL Server on Azure, or other cloud data platforms is a significant plus. - Requirements Elicitation : Demonstrated ability to effectively gather business requirements, conduct user interviews, and translate them into clear and actionable BI solutions. - Communication Skills : Excellent written and verbal communication skills, with the ability to effectively communicate technical concepts to both technical and non-technical audiences. - Problem-Solving : Strong analytical and problem-solving skills with the ability to troubleshoot issues and propose effective solutions. - Teamwork : Ability to work collaboratively within cross-functional teams and contribute positively to a team environment. - Agile Methodology : Experience working in Agile/Scrum development methodologies. Education : - Bachelor's degree in Computer Science, Information Systems, Data Science, or a related quantitative field.