Power BI Specialist

(Internal Title: Business System Configuration / Development III)

• Liaise with all department leads to understand dashboard requirements.

• Work with the IPT Project Information and Innovation Manager (PIIM) and Digital Delivery Manager (DDM) to establish the dashboard requirements are considered within the CDE applications.

• Provide ongoing support to the department managers and field services managers to ensure the data being extracted from the CDE applications is complete and up to date.

• Identify duplication of reporting info between department/delivery managers and drive optimization and consistencies between groups.

• Contribute towards the goal of reducing data re-entry, single-pane-of-glass concept, paperless execution, efficient automated workflow, and easy access to information by close interaction with the reporting team.

• Identify input and output transaction pathways for individual applications (Primavera, Aconex, Ecosys, My Safety, Petra-eGIS, other enterprise systems, Sword RAM, etc.) either directly or through a Common Data Environment (CDE) by working together with the PIIM and DDM.

• Design the layout of dashboards/reports/forms.

• Design the process flow using Microsoft Power Automate.

• Develop input methods in Microsoft Power Apps or Microsoft Forms to store data in SharePoint, Teams, individual apps, or other Common Data Environments (CDE).

• Embed ArcGIS information into various dashboards.

• Interact with users to understand ways to display the data in dashboards and reports.

• Develop dashboards for various departments with a creative graphic user interface.

• Possess expert-level knowledge in Microsoft Power BI, Power Apps, and Forms to generate dashboards, reports, and forms.

• Integrate into the environment of Teams, SharePoint, or independent webpages.

• Interact with business process analysts for accurate representation in creating the User Guides for each form/report/dashboard.

• Integrate, develop, and configure the Project Management Information System tools including Primavera Unifier, P6, EcoSys, and Oracle EBS under the supervision of the Business Systems Configuration or Development IV or higher.

• Plan for and execute appropriate means and methods in Business Systems Configuration or Development to complete the assigned tasks and duties on medium-sized projects or elements on larger projects or programs from inception through to completion.

• Provide timely and daily robust end-user support including logging bugs and errors, and follow up until they are resolved.

• Create updated content and bug fixes for software applications.

• Conduct business analysis at varying levels of detail, appropriate to the project and phases of the project.

• Facilitate and document design decisions.

• Develop key project deliverables and artifacts such as business requirements, functional design documents, fit or gap analyses, proposed data models, etc.

• Collaborate with the data architecture and technical development team to ensure the creation of an efficient technical solution that meets all functional business needs.

• Document the business requirements, perform the requirement elicitation, and work with the development team to identify alternative technology and solutions for implementation.

• Perform product testing to ensure quality is maintained and that acceptance criteria of the provided solution are met.

• Report functional or operational gaps in the self-service products through competitive analysis, monitoring industry trends, and prioritizing customer requests.

• Manage integration solutions that fit the Business Users' specific requirements.

• Provide day-to-day support and proactive monitoring of assigned applications and interfaces.

• Ensure standard Systems Development Life Cycle (SDLC) process is applied to develop EPMIS applications and solutions in response to business requirements.

• Liaise with Solution Architects on architecture design and SME on the integration efforts to other systems.

• Prepare technical documentation for all development items and support analysis, development, and testing for enterprise solutions.

• Review and analyze software programs to gain a detailed understanding of the impact of implementation on underlying business functions.

• Follow established Information Technology Infrastructure Library (ITIL) processes in troubleshooting, fixing, configuring, upgrading, testing, implementing, or deploying fixes, patches, or upgrades to enterprise applications.

• Evaluate project effectiveness in Business Systems Configuration or Development by consulting with applicable staff.

• Consult with the assigned manager or higher to seek guidance and input during the key phases of a project.

• Complete any tasks assigned by the manager or higher in an efficient and timely manner.

Working Conditions:

• Onsite at Client site: this role's work location is onsite with our client and partners to enable delivery and cultivate our client relationships.

Experience:

• Minimum of 6 years of experience in PMIS Application, Configuration, or Development works.

• Minimum of 6 years of experience in Project Management and Business System Development with experience supporting EPC projects or management portfolios.

Education:

• Bachelor’s degree in Business Administration, Project Management, Software Engineering, Business Analyst, or equivalent.

Licenses OR Certifications:

• Holding recognized Project Management certification (PMP).

BONUS POINTS IF YOU HAVE:

• Demonstrated experience in Data and Digital Management of large capital programs.

• Competent in managing multiple concurrent system implementation or integration projects.

• In-depth knowledge of prevailing consulting means and methods in Business Systems Configuration or Development.

• Expert understanding and experience in Project Costing, Scheduling, Earned Value Performance Metrics, and Construction or Contract Administration.

• Fundamental skills in Project Management and Construction, Project Controls, and Contractor Management processes and application.

• Advanced skills in Microsoft Office.

• Proficient in Primavera Unifier, Primavera P6, and EcoSys.

• Thorough understanding of programming skills like DotNet, SQL, development, PL or SQL Packages, Java, and modern languages like Python, R, Web services, REST, SOAP, JSON, and PIF.

• Proven capability in leading, coaching, and mentoring a team of technical Business Systems professionals.

• Adept functional acumen to support applicable solutions and goals while addressing and maintaining industry best practices.

• Ability to arrange priorities and escalate competing risks to meet deadlines with minimum input from leadership.

• Keen eye for detail and adept problem-solving abilities.

• Must have demonstrated experience relaying and receiving information (written and verbal).

• Expert ability to work collaboratively and independently in a structured, disciplined, technology-driven environment.

• Ability to work creatively and analytically in a problem-solving environment by ensuring effective teamwork, promotion of innovation, and overall excellence.