Business Intelligence Analyst - Business Development & Marketing Analytics

DPR Construction • Austin, NC

87d

About The Position

DPR Construction is seeking a Business Intelligence Analyst to serve as the lead Data Analyst working closely with cross-functional teams in our Get Work Integrated Workgroup to build relationships, identify pain points, create and drive data strategy, and deliver actionable insights. The Get Work Integrated Workgroup is composed 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 Business Development, Sales, Marketing, Content Operations, Brand & Design, and Internal and External Communications. This 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.

Requirements

• Master’s degree in Business Analytics, Data Analytics, Engineering, Architecture, Construction Management or related, plus five (5) years of experience in the application of data to solve problems, or Bachelor’s degree in one of the above plus seven (7) years of experience.
• Construction Experience including industry trends, terminology, and typical processes is strongly preferred.
• Construction Sales, Business Development, and Marketing experience strongly preferred.
• Experience with and first-hand knowledge of CRM Tools, strongly preferred.
• Passion for the use of data and business intelligence principles and their ability to optimize business outcomes.
• Proven track record of translating business pain points into data requirements and identifying and solving complex problems with data.
• Proven analytic skills, including data mining, evaluation, analysis, and visualization.
• Ability to create data models and understand dependencies between source systems.
• Experience in data visualization/BI tools – Power BI required - including creating and maintaining dataflows.
• Experience with consuming APIs from the client side including REST and GraphQL.
• Experience with SQL scripting required.
• 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.

Responsibilities

• Develop and maintain Strategic Partnerships with business stakeholders and a deep understanding of their people, processes, tools, and goals.
• Drive strategic conversations with stakeholders to fully understand and document pain points and business requirements, define the key insights and metrics required to improve business processes, and develop appropriate business intelligence datasets and analytics.
• Create, maintain, and execute on data analytics roadmap for stakeholder groups in alignment with overall goals and objectives.
• Participate in and collaborate with the Integrated Workgroup and functional teams to align Data Analytics (DA) efforts and resources with business goals and objectives.
• Identify opportunities for business process optimization and technical optimization and collaborate with stakeholders, as required, for implementation.
• Translate business problems into technical requirements and communicate technical solutions in business terms.
• Be responsible for taking data analysis and insights capability to the next level by working with data infrastructure to ensure the data is accessible; working with stakeholders to understand and align on business requirements; and recommending and developing new reporting and actionable insights to improve business processes and inform strategic conversations.
• 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 and/or potential new integrations between source systems and the Data Warehouse.
• Work with Technical Data Analysts to build requirements for views in data modeling tool (dbt) and the data warehouse (Snowflake).
• Create and maintain dashboards and apps and perform ad-hoc analyses as required.
• Identify root cause of data integrity issues (report, DFL, data warehouse, source system).
• Complete impact analysis on reports when changes are made to source systems or tables upstream.
• Identify, quantify, and communicate impacts to stakeholders and customers.
• Follow, implement, and enhance data security and governance guidelines.
• Identify opportunities for data collaboration and integration between disciplines.
• Coordinate alignment, as applicable, across other Technology and innovation (T&I) groups.
• Identify opportunities for AI/ML/Data Science efforts and work with those teams on project delivery.
• Train end-users on how to use and interpret information/insights on deployed dashboards/reports.
• Identify opportunities to improve data literacy throughout DPR.
• Operate as the Subject Matter Expert (SME) for the Get Work business across data availability, quality, processes, and technology for all Get Work functions.
• Maintain understanding of our data pipeline architecture to be able to articulate why we use it and its benefits/limitations for end users.

Benefits

• Employee-owned company
• Opportunities for growth and innovation
• Recognition as a great place to work by leading news organizations

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Master's degree
• Number of Employees: 5,001-10,000 employees