Business Intelligence Analyst - Business Development & Marketing Analytics

Overview

Lead BI analyst driving data strategy & insights for business development & marketing.

Key Responsibilities

• sql queries
• data governance
• dashboard development
• data integration
• stakeholder partnership
• ai/ml projects

Tasks

-Complete impact analysis on reports when changes are made to source systems or tables upstream. -Follow, implement, and enhance data security and governance guidelines. -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. -Maintain understanding of our data pipeline architecture to be able to articulate why we use it and its benefits/limitations for end users. -Query Data Warehouse using SQL to quickly analyze datasets; clean data as required. -Identify, quantify, and communicate impacts to stakeholders and customers. -Change leadership – Helps elevate how the Get Work team uses data, drives adoption of tools, improves data quality, and pushes DPR to be more disciplined and insight-driven. -Strategic thought partnership – Someone who isn’t just reporting numbers but helps the business think differently about how we win work. They should connect dots across sales, CRM, marketing, and communications to influence strategy. -Identify opportunities for data collaboration and integration between disciplines. -Data integration & insight creation – Can pull together data from multiple systems (CRM, marketing engagement, customer feedback, pipeline) and turn it into meaningful insights — market trends, hit rates, portfolio health, customer intelligence. -Translate business problems into technical requirements and communicate technical solutions in business terms. -Identify potential new datasets to add to the Data Warehouse and/or potential new integrations between source systems and the Data Warehouse. -Create and maintain dashboards and apps and perform ad-hoc analyses as required. -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, maintain, and execute on data analytics roadmap for stakeholder groups in alignment with overall goals and objectives. -Train end-users on how to use and interpret information/insights on deployed dashboards/reports. -Participate in and collaborate with the Integrated Workgroup and functional teams to align Data Analytics (DA) efforts and resources with business goals and objectives. -Develop and maintain Strategic Partnerships with business stakeholders and a deep understanding of their people, processes, tools, and goals. -Trusted advisor – Builds relationships with BD, Marketing, Sales, and Comms so people proactively seek their input on strategy and pursuits. -Identify root cause of data integrity issues (report, DFL, data warehouse, source system). -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. -Clear storytelling & influence – Takes complex data and makes it actionable for leaders; creates visuals, dashboards, and narratives that drive decision making. -Coordinate alignment, as applicable, across other Technology and innovation (T&I) groups. -Identify opportunities for business process optimization and technical optimization and collaborate with stakeholders, as required, for implementation. -Work with Technical Data Analysts to build requirements for views in data modeling tool (dbt) and the data warehouse (Snowflake). -Create complex data models in visualization tool, and make transformations as needed. -Identify opportunities for AI/ML/Data Science efforts and work with those teams on project delivery.

Requirements

• master’s
• sql
• power bi
• rest api
• crm
• construction

What You Bring

-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. -Proven analytic skills, including data mining, evaluation, analysis, and visualization. -Excellent organizational, leadership, interpersonal, communication (written, verbal and visual), and analytical skills are needed. -Experience with SQL scripting required. -Ability to create data models and understand dependencies between source systems. -Market & customer perspective – Brings a sales mindset and understands how customers buy; can surface patterns to help prioritize where to focus our efforts. -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. -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. -Construction Experience including industry trends, terminology, and typical processes is strongly preferred. -Demonstrated success in building trusted relationships with internal/external clients and customers. -Sales & Marketing Insight: Deep understanding of sales cycles, marketing funnels, and customer experience metrics; proven ability to connect data to revenue impact. -Experience with and first-hand knowledge of CRM Tools, strongly preferred. -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. -Construction Sales, Business Development, and Marketing experience strongly preferred.

People Also Searched For

About Dpr Construction

-A forward-thinking construction company that has grown from a small operation to a nationwide leader in the industry. -Focuses on complex, large-scale projects and is known for its expertise in delivering innovative, high-quality construction solutions. -Successfully completed projects across a range of sectors, including commercial, healthcare, education, and data centers, standing out for its ability to manage large budgets and tight schedules. -Notably completed several landmark projects, including high-tech facilities and cutting-edge educational buildings, often involving collaboration with some of the largest tech and medical organizations in the world. -Strong track record in renewable energy, particularly in solar and energy-efficient construction, positioning them as a leader in sustainable building practices. -Approach to construction is driven by technology and innovation, consistently pushing boundaries to ensure maximum efficiency and quality in its operations. -Commitment to performance and safety has earned a reputation for delivering projects that meet and exceed client expectations. -From healthcare campuses to advanced research labs, the company’s dedication to excellence ensures each project is tailored to the unique needs of the client and the community.

Sector Specialisms