Enterprise Business Data - Business Intelligence Analyst

Overview

Develop and manage enterprise-wide dashboards, KPI tracking, and analytics for DPR

Key Responsibilities

• data warehouse
• sql querying
• dashboard creation
• data governance
• stakeholder training
• ai/ml integration

Tasks

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

Requirements

• power bi
• sql
• rest api
• master's
• construction
• leadership

What You Bring

-Experience in data visualization/BI tools – Power BI required - including creating and maintaining dataflows. -Excellent organizational, leadership, interpersonal, communication (written, verbal and visual), and analytical skills are needed. -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. -Passion for the use of data and business intelligence principles and their ability to optimize business outcomes. -Analytic skills, including data mining, evaluation, analysis, and visualization. -Proven track record of translating business pain points into data requirements and identifying and solving complex problems with data. -Experience with consuming APIs from the client side including REST and GraphQL. -Demonstrated success in building trusted relationships with internal/external clients and customers. -Ability to create semantic data models and understand dependencies between source systems. -Construction Experience including knowledge of industry trends, terminology, and typical processes is strongly preferred. -Proven track record of managing large-scale analytics projects spanning multiple functional groups. -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. -Experience with SQL scripting required. -Experience guiding business partners (who may have limited experience with technology and data) through the process of KPI development.

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