Construction Management Data Analyst

Job Description

DPR Construction is seeking a Business Intelligence Analyst to support our Self Perform Work entity within DPR. The Self Perform Work (SPW) division of DPR directly hires and manages craft work forces to perform certain scopes of work. These scopes of work include Concrete, Drywall, Electrical, Interiors, Waterproofing, and more. This role will be the primary data analyst, supporting our SPW division.

As such, you will be responsible for engaging with stakeholders throughout our SPW group, including front‑line field supervisors, craft foreman, project managers, project executives, and corporate leadership. This role is responsible for working closely with cross‑functional teams, building relationships, identifying pain points, creating and driving data strategies, and delivering actionable insights. This role is part of the Data Analytics (DA) team and will ensure DPR is moving towards data‑driven decisions based on insights derived from integrated business processes, systems, and analytics.

• Be a collaborative partner with both our direct SPW business partners, as well as the many other parts of the business that SPW touches, to align DA efforts with business objectives and goals
• Create, maintain, and execute on the data analytics roadmap for SPW in alignment with overall goals and objectives
• Drive conversations with stakeholders to fully understand and document pain points. Drive strategic conversations focusing on successful outcomes and actions they are trying to drive
• Develop and maintain relationships with business stakeholders and a deep understanding of their processes, tools, and goals.
• Apply your own knowledge of construction management and self‑perform work to provide guidance and leadership on the development of data driven insights with our SPW business leaders, and front‑line managers.
• Be a proactive leader in the development and implementation of solutions to current pain points. Listen to a variety of voices and comments, and develop best‑in‑class long‑term solutions, not just quick fixes.

• Work with stakeholders to understand and align on business requirements
• Create and maintain dashboards and Apps, as required
• Deliver actionable insights to improve business processes and drive strategic conversations
• Track and monitor usage metrics to understand and measure adoption/impact of analytics
• Complete Ad‑Hoc Analysis as required

• Identify root source of data integrity issues (report, DFL, data warehouse, source system)
• Troubleshoot and solution data integrity issues in visualization tool

• Create complex data models in visualization tools, and make transformations as needed
• Query Data Warehouse using SQL to quickly analyze datasets
• Clean data, as required
• Identify potential new datasets to add to the Data Warehouse
• Identify potential new integrations between source systems and the Data Warehouse
• Work with Technical Analysts to build requirements for views in DBT and the data warehouse

• Work with Data Engineering in the development and maintenance of the data catalog
• Create and maintain documentation of queries, transformations, and refreshes for reports

• Follow, implement, and enhance data security and governance guidelines
• Create, maintain, and implement security for DFLs
• Review requests and grant access to DFLs, Reports, and Apps, as needed
• Create and maintain RLS in visualization tool, where needed Change Management
  • Complete impact analysis on reports when changes are made to source systems or tables upstream
  • Identify, quantify, and communicate impacts to stakeholders and customers
  Coordination / Collaboration / Prioritization
  • Identify opportunities for data collaboration and integration between disciplines
  • Coordinate alignment, as applicable, across other T&I groups
  • Identify opportunities for AI/ML/Data Science efforts and work with those teams on project delivery
  • Work with stakeholders to prioritize requests and initiatives based on business impact and resourcing
  • Participate in Integrated Workgroup meetings to align…