Key Responsibilities
- Design and develop interactive dashboards and reports in Power BI using DAX, Power Query (M), and data modeling best practices.
- Build and manage Power Automate flows to streamline business processes and automate recurring data operations.
- Use Python for advanced data wrangling, API integrations, and custom analytics not natively supported by Power BI.
- Develop ETL pipelines integrating diverse sources (SharePoint, Dataverse, SQL Server, Excel, APIs, etc.).
- Collaborate with stakeholders to translate business requirements into scalable technical solutions.
- Implement role-based access control (RBAC), dataset refresh schedules, and gateway configurations.
- Optimize query performance and data refresh reliability across Power BI and Fabric.
- (Nice-to-have) Work with Microsoft Fabric’s Lakehouse, Dataflows Gen2, and Notebooks for unified data and analytics development.
- Maintain documentation and ensure adherence to governance, compliance, and data security standards.
Required Skills & Experience
- 4–8 years of professional experience in Power BI (data modeling, DAX, report design, and performance tuning).
- 2+ years of experience with Power Automate / Power Apps (workflow design, approval processes, connectors, etc.).
- Strong proficiency in Python (Pandas, Requests, REST API handling, data transformations).
- Good understanding of SQL and relational data concepts.
- Experience integrating Power BI with Azure services (e.G., Synapse, Data Lake, Logic Apps) preferred.
- Excellent problem-solving, analytical, and communication skills.
Good-to-Have
- Experience with Microsoft Fabric, particularly with Lakehouse, Data Warehouse, Data Factory, and Notebooks.
- Exposure to Azure DevOps CI/CD pipelines for Power BI deployments.
- Familiarity with enterprise data governance frameworks and data lineage tools.
Education
- Bachelor’s or Master’s degree in Computer Science, Information Systems, Data Engineering, or a related field.
- Microsoft certifications such as PL-300 (Power BI Data Analyst) or PL-500 (Power Automate RPA Developer) are a plus.