Power BI Developer/Analyst

JOB DESCRIPTION Role Overview: We are seeking an experienced Power BI developer/Analyst to for one of our key accounts in the USA. The Developer will be responsible for transforming manual Excel reporting processes into a centralized, automated BI solution using Power BI. The role involves understanding existing Excel logic, building a robust data model, developing visually compelling dashboards, and ensuring reliable refresh and governance practices. Responsibilities: • Understand existing Excel reports, formulas, macros, pivot logic, and business rules. • Document reporting logic, KPIs, metrics, and data definitions. • Work with business stakeholders to clarify requirements and identify improvement areas. • Ingest data from Excel, SQL databases, or other source systems into Power BI. • Write DAX measures to replicate or improve current Excel calculations. • Design intuitive, interactive Power BI dashboards and paginated reports. • Apply best practices for UX, visual design, and performance. • Ensure business logic aligns with the original Excel reports • Publish reports to Power BI Service workspaces, manage access, and set up RLS if needed. • Ensure data pipelines eliminate manual effort currently required in Excel. • Conduct user training on new Power BI dashboards. Requirements: • 6-8 + years of experience with PowerBI • Expertise in SQL for data extraction, manipulation, and reporting • Experience with Azure • Good understanding of Excel logic, including formulas, pivots, and macros • Excellent analytical, problem-solving, debugging and communication skills • Ability to work independently and collaboratively within a team environment Good to Have: • Experience in Azure – Data Factory, Fabric • Setting up and management of Power BI Report Server • Exposure to Python or R for advanced analytics Apply tot his job