Business Intelligence (BI) and Asset Management Analyst II

At HDR, our employee-owners are fully engaged in creating a welcoming environment where each of us is valued and respected, a place where everyone is empowered to bring their authentic selves and novel ideas to work every day. As we work to weave diversity, equity, and inclusion into our work and foster a sense of belonging throughout the company and within our communities, we constantly ask ourselves: What is our impact on the world?Watch Our Story:' https://www.hdrinc.com/our-story'Each and every role throughout our organization makes a difference in our ability to change the world for the better. Read further to learn how you could help make great things possible not only in your community, but around the world.HDR is looking for a Business Intelligence (BI) and Asset Management Analyst II to join our Water Business Group in North Carolina. We are seeking a data-driven problem solver with expertise in Power BI, data modeling, and GIS analytics to support operational decision-making and performance tracking. This individual will be expected to build and maintain Power BI dashboards, perform data analysis, and integrate GIS data to enhance asset management, infrastructure planning, and operational workflows. They will also assist in implementing and optimizing CMMS asset management software to support work order management and maintenance tracking. On a day-to-day basis, they will also be expected to:• Design and develop interactive Power BI dashboards to support data-driven decision-making.• Build and optimize data models that consolidate information from GIS, asset management systems, financial records, and operational datasets.• Establish ETL processes (Extract, Transform, Load) to clean, transform, and integrate data from multiple sources.• Perform trend analysis, forecasting, and predictive modeling to optimize operations and asset performance.• Ensure data accuracy, validation, and governance best practices to maintain data integrity.• Automate reporting workflows and data model updates.• Support the implementation and ongoing administration of Cityworks AMS or similar enterprise asset management software.• Assist in integrating Cityworks with GIS (ArcGIS) and work activity processes.• Develop Cityworks reports and analytics to track maintenance history, work order efficiency, and asset lifecycle trends.• Customize workflows, reports, and dashboards to align with operational needs.• Train users on best practices for work order management, inspections, and reporting.• Provide training and support to staff on Power BI dashboards, GIS tools, and CMMS workflows.• Assist teams in interpreting analytics and reports for strategic decision-making.• Develop documentation and standard operating procedures for data visualization, analysis, and reporting.• Analyze maintenance, asset condition, and operational data to identify trends and recommend improvements.• Develop and track Key Performance Indicators (KPIs) for public infrastructure, utilities, and operational performance.• Work with stakeholders to establish best practices for data-driven decision-making across departments.• Perform spatial analysis and geoprocessing using ArcGIS Pro, ArcGIS Online, and ArcGIS Enterprise.• Develop and maintain GIS feature layers, web maps, and spatial dashboards.• Integrate GIS data with Power BI and other enterprise applications to enhance decision-making.• Conduct spatial analysis and automation to assist with utility infrastructure maintenance, management, and planning.Preferred Qualifications• Bachelor’s degree related fields include Data Science, GIS, Information Systems, Engineering• 5 years of experience in Power BI development, data modeling, and business intelligence analytics• 5 years of experience with GIS software (ArcGIS Pro, ArcGIS Online, ArcGIS Enterprise) for spatial analysis and data integration• Proficiency in SQL, DAX, and Power Query (M) for data transformation and analytics• Experience working with Cityworks, Cartegraph, Maximo, or similar CMMS/AMS software• Strong understanding of data governance, validation, and integration best practices• Excellent communication skills and experience providing technical training and user support• Experience with Python (ArcPy), R, or Power Automate for automation and advanced analytics• Familiarity with Azure, Power Apps, SharePoint, or other Microsoft cloud-based tools• Experience with predictive analytics, machine learning models, or statistical forecasting• Local candidates are preferredRequired Qualifications• Bachelor's degree in related field• A minimum of 5 years related experience• Efficient use of the internet and other electronic and hard copy media for research• Strong Microsoft PowerPoint, Word, Project and Visio skills• Expert Microsoft Access and Excel skills• Strong analytical skills with the ability to compile and present summary level information• Ability to obtain, cleanse, merge and analyze data from multiple sources• Excellent interpersonal skills and strong relationship, organizational and follow-up skills• Self-starter with proven track record of accomplishments• An attitude and commitment to being an active participant of our employee-owned culture is a mustWhat We BelieveHDR is our company. Together, we build on each other's life experiences and perspectives to make great things possible every day. This shapes our collaborative culture, encourages organizational trust and connects us closer to the clients and communities we serve.Our CommitmentAs employee owners, we all have a role in creating an inclusive environment where each of us is welcomed, valued, respected and empowered to bring our authentic selves to work every day.Our eight Employee Network Groups (Asian Pacific, Black, Hispanic/Latino(a), LGBTQ+, People with Disabilities, Veterans, Women, Young Professionals) help create a sense of belonging and foster a supportive environment where everyone is empowered to engage and contribute. Each group has an executive sponsor and is open to all employees.Primary Location:United States-North Carolina-Winston-SalemOther Locations:United States-North Carolina-Raleigh, United States-North Carolina-CharlotteIndustry:WaterSchedule:Full-timeEmployee Status:RegularBusinessClass:Utility Management ServicesJob Posting:Mar 12, 2025At HDR, we are committed to the principles of employment equity. We are an Affirmative Action and Equal Opportunity Employer (https://www.hdrinc.com/equal-employment-opportunity-employer). We consider all qualified applicants, regardless of criminal histories, arrest and conviction records.