Consultant, Technical(Power BI With Finance Domain)
Job Description
We are seeking an experienced Power BI 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 BI's 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.
Qualifications
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 reportsDevelop datasets, measures (DAX), and visuals to support business insightsMaintain data accuracy, integrity, and security within the Power BI environmentOptimise performance of reports and dashboards for a seamless user experienceImplement Power ON configurations, including workspaces, security, and sharing policiesEffort Estimation & Project Delivery
Estimate project effort, timeline, and resource requirements for Power ON implementationsDefine project milestones and collaborate with project managers to ensure timely deliveryDevelop prototypes and proof-of-concepts to validate solutions before full implementationSupport UAT (User Acceptance Testing) and gather feedback for refinementsClient Training & Support
Conduct training sessions for end-users to drive adoption of Power ON solutionsProvide post-implementation support, troubleshooting, and performance tuningAct as a trusted advisor to clients on Power ON strategies and future enhancementsPreferred Qualifications & Experience :
Bachelor’s degree in computer science, Data Analytics, Business Intelligence, or a related field.Experience in Power BI development and business intelligence consultingExperience in the finance industryMicrosoft 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 BIProficiency in SQL for querying and transforming data from various sourcesUnderstanding of Azure services (e.g., Azure Synapse, Azure Data Factory, Azure SQL)Knowledge of Power Automate and Power Apps integration with Power BIExperience with non-Microsoft data sources (Snowflake, Oracle, PostgreSQL, MySQL, Synapse, Big Query) is advantageousRow Level Security (Analysis Services, Power BI.com, 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 solutionsUnderstanding of financial reporting, planning, and analysis.Ability to work with stakeholders at all levels, including senior executivesExcellent communication and presentation skills for client-facing interactionsProven track record of delivering end-to-end Power BI solutions in a consulting or business setting.Strong organizational skills, proactive, and confident.Enough Project management and business analysis experience to allow scoping of small to mid-sized projects and defining project scopesExcellent written and spoken English, for frequent communications with customers' and partners' multinational teamsGreat presentation skills, ability to deliver showcase / demonstration of Power ON functionality.Is a true team player, but able to work autonomously as well.Confident, motivated personalityProactive and success-oriented.High standards of quality of his / her workHas a thorough analytical approach, thinks about the consequences of his / her actions.Availability to work Eastern Standard Time hours.Ability to handle workload with a sense of urgency.Reliability.The patience to work with customers who will require guidance / coaching.Additional Information
All your information will be kept confidential according to EEO guidelines.
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 .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 .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.