Job Description
The Project Planning & Execution Data Analytics Lead is responsible for working closely with crossfunctional 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) DesigntoBuild and other related workgroups. This Business Intelligence Analyst Lead role is part of the Data Analytics team and will ensure DPR is moving towards datadriven 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 customers 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 AdHoc 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 endusers on how to use and interpret information/insights on deployed dashboards/reports
- Train endusers on how to build reports themselves
- Provide onthejob 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 stakeholders through targeted trainings and conversations
- Identify opportunities to improve data literacy throughout DPR
Data SME
- Operate as the Subject Matter Expert for the PP&E business across data availability quality processes and technology for all workgroups within the PP&E Integrated Workgroup
- Maintain understanding of our data pipeline architecture to be able to articulate why we use it and its benefits/limitations for end users
- Ensure source of truth system(s) are identified and operational
Qualifications
- Masters degree in Business Analytics Data Analytics Engineering Architecture Construction Management or related plus three (3) years of experience in the application of data to solve problems or Bachelors degree in one of the above plus five (5) years of experience.
- Construction Project Controls experience including industry trends terminology and typical processes is strongly preferred.
- Scheduling preconstruction and/or VDC experience strongly preferred.
- Experience in data visualization/BI tools Power BI strongly preferred including creating and maintaining dataflows.
- Proven analytic skills including data mining evaluation analysis and visualization.
- Skilled at analysis and providing relevant information people need to succeed in their roles to formulate accurate decisions and take appropriate action.
- Ability to create data models and understand dependencies between source systems.
- Experience with consuming APIs from the client side including REST and GraphQL.
- Basic knowledge of SQL scripting required.
- Knowledge of statistics and ability to translate this into nontechnical laymans terms.
- Proven track record of translating business pain points into data requirements.
- Proven track record of identifying and solving complex problems with data.
- Passion for the use of data and business intelligence principles and their ability to optimize business outcomes.
- Understanding of how business decisions are evaluated across operations finance risk and people practices and ability to apply this understanding to identify opportunities for improved decision making.
- Advanced business acumen and working knowledge of typical company operations including how business decisions are evaluated and the ability to apply this understanding to identify opportunities for improved decision making.
- Excellent organizational leadership interpersonal communication (written verbal and visual) and analytical skills are needed.
- Demonstrated success in building trusted relationships with internal/external clients and customers.
- A drive to do what it takes to get the job done including taking on different roles and responsibilities and adapting to changing environments.
- Ability to navigate ambiguity and work independently to identify and execute on IWG priorities without constant direction.
DPR Construction is a forwardthinking selfperforming general contractor specializing in technically complex and sustainable projects for the advanced technology life sciences healthcare higher education and commercial markets. Founded in 1990 DPR is a great story of entrepreneurial success as a private employeeowned company that has grown into a multibilliondollar family of companies with offices around the world.
Working at DPR youll have the chance to try new things explore unique paths and shape your future. Here we build opportunity togetherby harnessing our talents enabling curiosity and pursuing our collective ambition to make the best ideas happen. We are proud to be recognized as a great place to work by our talented teammates and leading news organizations like U.S. News and World Report Forbes Fast Company and Newsweek.
Explore our open opportunities at