Power BI Specialist

(Internal Title: Business System Configuration / Development III)

• Liaise with all department leads to understand dashboard requirements
• Works 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
• Identifies duplication of reporting info between department/delivery managers and drives optimization and consistencies between groups
• Contributing towards the goal of reducing data re-entry, single-pane-of-glass concept, paperless execution, efficient automated workflow, easy access to information by close interaction with the reporting team
• Identifying 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
• Designing the layout of dashboards/reports/forms
• Designing the process flow using Microsoft Power Automate
• Developing input methods in Microsoft Power apps or Microsoft forms to store data in SharePoint, Teams, individual apps, or other Common data environments (CDE)
• Embedding ArcGIS information into various dashboards
• Interacting with users to understand ways to display the data in dashboards and reports
• Developing dashboards for various departments with creative graphic user interface
• Having expert-level knowledge in Microsoft Power BI, Power Apps, and Forms to generate dashboards, reports, and forms
• Integrating in the environment of Teams, SharePoint, or independent webpage
• Interacting 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
• Responsible for creating 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
• Responsible for 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

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