Job Description

The Project Planning & Execution Data Analytics Lead is responsible for working closely with cross-functional teams in our Project Planning and Execution (PP&E) Integrated Workgroup (IWG) to build relationships, identify pain points, create and drive data strategy, and deliver actionable insights. The PP&E Integrated Workgroup is comprised of leaders from the business and technology functions who support the strategic planning and delivery of critical technology and analytics to drive the business forward.  It includes Preconstruction, Scheduling, Virtual Design and Construction (VDC), Design-to-Build and other related workgroups.  This Business Intelligence Analyst Lead role is part of the Data Analytics team and will ensure DPR is moving towards data-driven decisions based on insights derived from integrated business processes, systems, and analytics.

Responsibilities

Strategic Partnership / Roadmap / Execution / Delivery

• Participate in and collaborate with the PP&E Integrated Workgroup and Functional teams to align Data Analytics (DA) efforts with business objectives and goals
• Create, maintain, and execute on data analytics roadmap for stakeholder groups in alignment with overall goals and objectives
• Identify business sponsors and create and manage business steering committees (or similar), as needed
• 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
• Translate business pain points into data requirements
• Maintain a deep understanding of the customer’s processes, tools, and goals
• Develop and maintain relationships with business stakeholders
• Coordinate and support Citizen Data Analysts within your function and/or region

Visualization / Storytelling:

• Work with stakeholders to understand and align on business requirements
• Create and maintain dashboards and reports to deliver key analytics
• 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 analyses as required

Troubleshoot Issues / Failures:

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

Data Modeling and ETL:

• Create complex data models in visualization tool, 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

Documentation

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

Security / Governance

• 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
• Work with business stakeholders to understand and set security requirements, with regards to build access and view access

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 support functions

Training / Data Literacy

• Train end-users on how to use and interpret information/insights on deployed dashboards/reports
• Train end-users on how to build reports themselves
• Provide “on-the-job’ training to business stakeholders when needed
• Work with Data Engineering and others to develop and maintain tool for Self Service Analytics
• Increase data literacy of business st