A dynamic and highly motivated Power BI Analyst is essential for designing and delivering scalable executive-ready dashboards that empower decision-makers with self-service analytics. This role involves crafting trusted reporting solutions for digital innovation project teams translating complex financial contractual resource management and other critical metrics into clear actionable insights. The result: informed decision-making optimized costs and support for strategic organizational goals.
Key Responsibilities:
- Design build and enhance Power BI dashboards and semantic models that are user-friendly well-governed and easy to maintain.
- Partner with stakeholders to understand business requirements and translate them into intuitive actionable Power BI dashboards and reporting solutions.
- Proactively identify manual reporting workflows and develop automated Power BI dashboards that reduce manual effort improve data quality and provide timely reporting for decision-making.
- Perform rigorous data validation reconciliation and quality monitoring to ensure financial and resource data is accurate complete and fully aligned between source systems and reporting outputs.
- Actively investigate and resolve data discrepancies clearly communicate root cause and implement sustainable fixes to prevent recurrence.
- Document dashboards semantic models and business logic-including data definitions KPI logic and usage guidance-and deliver user training to support scalable self-service reporting.
Required Qualifications:
- Advanced proficiency in Microsoft Power BI including report development and semantic modeling.
- Strong expertise in DAX and Power Query (M).
- Experience with dimensional data modeling (star/snowflake schemas).
- Proficiency in SQL for data extraction transformation and validation.
- Experience integrating data from multiple sources (e.g. SQL Excel cloud platforms).
- Hands-on experience implementing row-level security (RLS).
- Experience optimizing Power BI performance and refresh strategies.
- Strong data validation and reconciliation skills.
- Bachelors degree in Business Analytics Information Systems Finance Computer Science or a related analytical field required. An equivalent combination of education and relevant experience may be considered.
- 3 5 years of hands-on Power BI experience with a proven track record delivering scalable high-impact reporting solutions.
Benefits:
- 401(k).
- Dental Insurance.
- Health insurance.
- Vision insurance.
- We are an equal-opportunity employer and value diversity equality inclusion and respect for people.
- The salary will be determined based on several factors including but not limited to location relevant education qualifications experience technical skills and business needs.
Additional Responsibilities:
- Participate in OP monthly team meetings and participate in team-building efforts.
- Contribute to OP technical discussions peer reviews etc.
- Contribute content and collaborate via the OP-Wiki/Knowledge Base.
- Provide status reports to OP Account Management as requested.
About us:
At OP we help you harness the power of technology for maximum impact. A technology consulting and solutions company we offer advisory and managed services innovative platforms and staffing solutions across a wide range of fields including AI cyber security enterprise architecture and beyond. For nearly two decades weve been challenging the status quo of the consulting industry serving up fresh ingenious thinking through a radically lean structure. Together this strategy delivers unprecedented performance at an unparalleled pace for faster results that propel your business forward.
A dynamic and highly motivated Power BI Analyst is essential for designing and delivering scalable executive-ready dashboards that empower decision-makers with self-service analytics. This role involves crafting trusted reporting solutions for digital innovation project teams translating complex f...
A dynamic and highly motivated Power BI Analyst is essential for designing and delivering scalable executive-ready dashboards that empower decision-makers with self-service analytics. This role involves crafting trusted reporting solutions for digital innovation project teams translating complex financial contractual resource management and other critical metrics into clear actionable insights. The result: informed decision-making optimized costs and support for strategic organizational goals.
Key Responsibilities:
- Design build and enhance Power BI dashboards and semantic models that are user-friendly well-governed and easy to maintain.
- Partner with stakeholders to understand business requirements and translate them into intuitive actionable Power BI dashboards and reporting solutions.
- Proactively identify manual reporting workflows and develop automated Power BI dashboards that reduce manual effort improve data quality and provide timely reporting for decision-making.
- Perform rigorous data validation reconciliation and quality monitoring to ensure financial and resource data is accurate complete and fully aligned between source systems and reporting outputs.
- Actively investigate and resolve data discrepancies clearly communicate root cause and implement sustainable fixes to prevent recurrence.
- Document dashboards semantic models and business logic-including data definitions KPI logic and usage guidance-and deliver user training to support scalable self-service reporting.
Required Qualifications:
- Advanced proficiency in Microsoft Power BI including report development and semantic modeling.
- Strong expertise in DAX and Power Query (M).
- Experience with dimensional data modeling (star/snowflake schemas).
- Proficiency in SQL for data extraction transformation and validation.
- Experience integrating data from multiple sources (e.g. SQL Excel cloud platforms).
- Hands-on experience implementing row-level security (RLS).
- Experience optimizing Power BI performance and refresh strategies.
- Strong data validation and reconciliation skills.
- Bachelors degree in Business Analytics Information Systems Finance Computer Science or a related analytical field required. An equivalent combination of education and relevant experience may be considered.
- 3 5 years of hands-on Power BI experience with a proven track record delivering scalable high-impact reporting solutions.
Benefits:
- 401(k).
- Dental Insurance.
- Health insurance.
- Vision insurance.
- We are an equal-opportunity employer and value diversity equality inclusion and respect for people.
- The salary will be determined based on several factors including but not limited to location relevant education qualifications experience technical skills and business needs.
Additional Responsibilities:
- Participate in OP monthly team meetings and participate in team-building efforts.
- Contribute to OP technical discussions peer reviews etc.
- Contribute content and collaborate via the OP-Wiki/Knowledge Base.
- Provide status reports to OP Account Management as requested.
About us:
At OP we help you harness the power of technology for maximum impact. A technology consulting and solutions company we offer advisory and managed services innovative platforms and staffing solutions across a wide range of fields including AI cyber security enterprise architecture and beyond. For nearly two decades weve been challenging the status quo of the consulting industry serving up fresh ingenious thinking through a radically lean structure. Together this strategy delivers unprecedented performance at an unparalleled pace for faster results that propel your business forward.
View more
View less