Power Bi Developer

KRole & responsibilities

Power BI Developer JD

Power BI developer: Proficient in designing, building, and deploying Power BI & business intelligence solutions, with advanced skills in DAX for complex calculations, data modeling for efficient report structures, and the Power BI Service for report management and collaboration

Experience: 3 + years (relevant exp in Power BI)

Required skills and experience

• Technical skills: Proficiency in Power BI Desktop and Service, Power Query (M), DAX, leveraging sources Azure Data warehouse, Databricks, SQL
• Data modeling: Strong understanding of data warehousing concepts and relational databases (like SQL Server or Azure SQL).
• Power BI security implementation (RLS/CLS/OLS)
• Communication: Excellent verbal and written communication skills to work with both technical and non-technical teams.
• Problem-solving: Strong analytical and problem-solving skills.

*Experience in MicroStrategy report development or MicroStrategy to Power BI migration is a plus

Key responsibilities

• Data analysis and modeling: Connect to and integrate data from various sources, perform data cleaning and transformation using Power Query, and design robust data models with star or snowflake schemas.
• DAX expertise: Write complex DAX expressions to create measures, calculated columns, and KPIs for advanced analytics and reporting.
• Report and dashboard development: Design, develop, and implement interactive and visually appealing dashboards and reports tailored to business needs.
• Power BI Service management: Deploy, manage, and optimize reports and dashboards in the Power BI Service, including setting up security, access control, and data refresh schedules.
• Stakeholder collaboration: Work with business stakeholders to understand their data needs, gather requirements, and provide training and support.
• Performance optimization: Tune and optimize Power BI solutions to ensure high performance and efficiency.
• Troubleshooting and support: Troubleshoot issues, ensure data accuracy and integrity, and provide ongoing maintenance and enhancements.

Power BI Sr. Developer JD

Design, development, and implementation of robust and scalable Power BI solutions, with a strong focus on data modeling, advanced DAX and M-code, secure portal integration, and comprehensive security implementations (CMK, RLS, OLS) leveraging Microsoft Fabric Warehouse and Azure Databricks as primary data sources.

Experience: 6 + years (relevant exp in Power BI)

Required Skills and Experience:

• Expert-level proficiency in Power BI Desktop and Power BI Service.
• Deep understanding and extensive experience with data modeling principles and best practices.
• Advanced proficiency in DAX for complex calculations and business logic.
• Strong command of M-code (Power Query) for data transformation and manipulation.
• In-depth knowledge and hands-on experience implementing Power BI security features, including CMK, RLS, and OLS.
• Extensive experience working with Microsoft Fabric Warehouse & Azure Databricks as a data source
• Support in Power BI integration with portal and establish security implementation
• Strong understanding of data warehousing concepts and ETL processes.
• Excellent analytical, problem-solving, and communication skills.
• Ability to lead, mentor, and collaborate effectively within a team environment

*Experience in MicroStrategy development or MicroStrategy to Power BI migration is plus

ey Responsibilities:

• Lead the end-to-end development of Power BI solutions, from data source integration to report deployment and portal embedding.
• Design and implement complex data models within Power BI, ensuring optimal performance and scalability, connecting to Microsoft Fabric Warehouse and Azure Databricks.
• Develop and optimize advanced DAX calculations and M-code transformations for complex business logic and data manipulation.
• Oversee the secure integration of Power BI reports and dashboards into various portals, ensuring a seamless user experience while maintaining data security.
• Implement and manage advanced security features within Power BI, including Customer Managed Keys (CMK), Row-Level Security (RLS), and Object-Level Security (OLS).
• Collaborate with data engineers, architects, and business stakeholders to understand requirements, define data strategies, and deliver impactful BI solutions.
• Ensure data quality, accuracy, and consistency across all Power BI reports and dashboards.
• Provide technical leadership, mentorship, and guidance to a team of Power BI developers.
• Troubleshoot and resolve complex issues related to Power BI performance, data integration, and security.