Construction Management Data Analyst

Description

• Complete impact analysis on reports when changes are made to source systems or tables upstream
• 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.
• Deliver actionable insights to improve business processes and drive strategic conversations
• Identify opportunities to improve data literacy throughout DPR
• Work with business stakeholders to understand and set security requirements, with regards to build access and view access
• Train end-users on how to use and interpret information/insights on deployed dashboards/reports
• Create and maintain RLS in visualization tool, where needed
• Provide “on-the-job’ training to business stakeholders when needed
• Complete Ad-Hoc Analysis as required
• Work with Technical Analysts to build requirements for views in DBT and the data warehouse
• Maintain understanding of our data pipeline architecture to be able to articulate why we use it and its benefits/limitations for end users
• 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
• Query Data Warehouse using SQL to quickly analyze datasets
• Participate in Integrated Workgroup meetings to align support functions
• 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
• Ensure source of truth system(s) are identified and operational
• Identify, quantify, and communicate impacts to stakeholders and customers
• Work with Data Engineering in the development and maintenance of the data catalog
• Identify opportunities for AI/ML/Data Science efforts and work with those teams on project delivery
• Work with stakeholders to understand and align on business requirements
• Create complex data models in visualization tools, and make transformations as needed
• Create, maintain, and execute on the data analytics roadmap for SPW in alignment with overall goals and objectives
• Identify opportunities for data collaboration and integration between disciplines
• Work with stakeholders to prioritize requests and initiatives based on business impact and resourcing
• Work with Data Engineering and others to develop and maintain tool for Self Service Analytics
• Follow, implement, and enhance data security and governance guidelines
• Track and monitor usage metrics to understand and measure adoption/impact of analytics
• Coordinate alignment, as applicable, across other T&I groups
• Increase data literacy of business stakeholders through targeted trainings and conversations
• Create and maintain dashboards and Apps, as required
• Operate as the Subject Matter Expert for the business across data availability, quality, processes, and technology
• Develop and maintain relationships with business stakeholders and a deep understanding of their processes, tools, and goals.
• Create, maintain, and implement security for DFLs
• Create and maintain documentation of queries, transformations, and refreshes for reports
• Train end-users on how to build reports themselves
• Troubleshoot and solution data integrity issues in visualization tool
• Review requests and grant access to DFLs, Reports, and Apps, as needed
• 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.
• Identify root source of data integrity issues (report, DFL, data warehouse, source system)
• Identify potential new datasets to add to the Data Warehouse
• Identify potential new integrations between source systems and the Data Warehouse

Requirements

• Proven track record of translating business pain points into data requirements and identifying and solving complex problems with data.
• Passion for the use of data and business intelligence principles and their ability to optimize business outcomes.
• Proven analytic skills, including data mining, evaluation, analysis, and visualization.
• Experience in data visualization/BI tools – Power BI required - including creating and maintaining dataflows.
• Master’s 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 Bachelor’s degree in one of the above plus five (5) years of experience.
• Experience with construction project controls, including Earned Value Management, productivity management, schedule management, and cost management, is strongly preferred.
• Demonstrated success in building trusted relationships with internal/external clients and customers.
• Experience with consuming APIs from the client side including REST and GraphQL.
• 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.
• Experience with self-perform teams, including running or managing a craft workforce, is strongly preferred.
• Ability to create data models and understand dependencies between source systems.
• Excellent organizational, leadership, interpersonal, communication (written, verbal and visual), and analytical skills are needed.
• Experience with the construction industry, including knowledge of industry trends, terminology, and typical processes, is strongly preferred.
• Experience with SQL scripting required.

Benefits

Training + Development

Interview process

Visa Sponsorship

Security clearance