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 Now
Apply Now