Functional Consultant Power BI

We are seeking an experienced Power BI Functional Consultant to work closely with clients understanding their financial and business needs and translating them into use cases that can be implemented using Power ON. Power ON extends Power BIs functionality by providing write back capability. This role involves engaging with stakeholders to scope and define use cases estimate implementation efforts and deliver robust Power ON solutions that drive business insights and decision-making. The ideal candidate will have a strong mix of business acumen technical expertise and excellent communication skills. Key Responsibilities Client Engagement & Business Analysis Engage with business stakeholders to understand their reporting analytics and data visualization needs Conduct discovery workshops to gather requirements define use cases and assess data sources Translate business requirements into clear functional and technical specifications Provide recommendations on Power ON best practices governance and adoption strategies. Solution Design & Implementation Design scalable and efficient Power ON solutions including data models dashboards and reports Develop datasets measures (DAX) and visuals to support business insights Maintain data accuracy integrity and security within the Power BI environment Optimise performance of reports and dashboards for a seamless user experience Implement Power ON configurations including workspaces security and sharing policies Effort Estimation & Project Delivery Estimate project effort timeline and resource requirements for Power ON implementations Define project milestones and collaborate with project managers to ensure timely delivery Develop prototypes and proof-of-concepts to validate solutions before full implementation Support UAT (User Acceptance Testing) and gather feedback for refinements Client Training & Support Conduct training sessions for end-users to drive adoption of Power ON solutions Provide post-implementation support troubleshooting and performance tuning Act as a trusted advisor to clients on Power ON strategies and future enhancements Preferred Qualifications & Experience Bachelors or Masters degree in Mathematics Computer Science Data Analytics Business Intelligence or a related field Experience in Power BI development and business intelligence consulting Experience in the finance industry Microsoft Power BI certification (e.g. PL-300 : Power BI Data Analyst) Technical Skills Strong expertise in Power BI (Power Query Power BI Desktop Power BI Service DAX and M Query) Experience designing data models and ETL processes within Power BI Proficiency in SQL for querying and transforming data from various sources Understanding of Azure services (e.g. Azure Synapse Azure Data Factory Azure SQL) Knowledge of Power Automate and Power Apps integration with Power BI Experience with non-Microsoft data sources (Snowflake Oracle PostgreSQL MySQL Synapse Big Query) advantageous Row Level Security (Analysis Services SQL Server) Performance optimisation (Partitioning Understanding of columnar database concept SQL indexing) Troubleshooting (SQL Profiler or other profiler tools Tabular Editor DAX Studio Power BI datasets RLS security) Business & Consulting Skills Strong ability to gather requirements and translate them into technical solutions Understanding of financial reporting planning and anaysis. Experience in estimating implementation efforts and defining project scopes Ability to work with stakeholders at all levels including senior executives Excellent communication and presentation skills for client-facing interactions Proven track record of delivering end-to-end Power BI solutions in a consulting or business setting Willingness to travel to client sites as needed Additional Information : At this time insightsoftware is not able to offer sponsorship to candidates who are not eligible to work in the country where the position is located . Remote Work Yes Employment Type Remote Experience years Vacancy 1 Background checks are required for employment with insightsoftware where permitted by country state / province. At insightsoftware we are committed to equal employment opportunity regardless of race color ethnicity ancestry religion national origin gender sex gender identity or expression sexual orientation age citizenship marital or parental status disability veteran status or other class protected by applicable law. We are proud to be an equal opportunity workplace. #J-18808-Ljbffr