Business Intelligence Analyst

McGough is a respected partner that brings six generations of experience to high profile, unique and complex construction projects. We take great pride in our people and their extraordinary expertise in planning, development, construction and facility management. McGough employee tenure reflects the commitment and pride we share in our work. Ask anyone who knows us - the caliber of our people sets us apart.

BUSINESS INTELLIGENCE ANALYST I

The Business Intelligence Analyst plays a hands-on role in delivering reliable, business-ready analytics across McGough. This position is responsible for transforming data from multiple application sources into clear, high-performing dashboards and reports that support day-to-day decision-making throughout the organization.

This role partners closely with business stakeholders to understand reporting needs, define requirements, and translate complex questions into actionable KPIs and visualizations. The Business Intelligence Analyst owns data preparation, dashboard development, and ongoing enhancement of analytics assets-ensuring accuracy, usability, performance, and alignment with established data governance standards.

Reporting to the Analytics Manager, this is an execution-focused role centered on delivering high-quality work with speed and precision. The goal is to build analytics solutions the business trusts and actively uses. Over time, the role offers opportunities to deepen expertise within specific business domains.

Qualifications:

Required:

• Bachelor's degree or equivalent experience in a data, analytics, or technical field.
• 2-5 years of experience delivering business intelligence or analytics solutions.
• Demonstrated hands-on experience building dashboards and reports in Tableau.
• Experience working directly with business stakeholders to gather requirements and clarify analytical needs.
• Strong analytical, problem-solving, and communication skills.

Preferred:

• Experience in the construction industry or project-based operational environments.
• Experience optimizing Tableau dashboards for performance, usability, and scalability.
• Familiarity with data governance, data quality, and access-control practices.
• Experience with Python for data analysis or automation.
• Experience with Snowflake or other Enterprise data warehouse solutions (AWS, Biq Query, etc)

Skills:

• Advanced Tableau development, including dashboard design, performance tuning, and data source management.
• Strong proficiency for querying, joining, and analyzing data in Snowflake.
• Ability to prepare and shape data for analytical use.
• Clear written and verbal communication with technical and non-technical audiences.
• Ability to translate business questions into effective visualizations and metrics.
• Attention to detail with a strong commitment to data accuracy and quality.
• Comfortable working across multiple business functions and priorities.
• Ability to learn new domains, datasets, and tools quickly.

Office and Travel:

• Position can be remote or based in McGough's Roseville MN or Raleigh, NC Offices.
• Travel is expected to be approximately 15% consisting of quarterly trips to McGough's headquarters for various training or team building activities. Additional travel to various national office locations may be required as determined by the individual and their manager.

Responsibilities and Tasks:

Analytics Delivery & Dashboard Development

• Design, build, and maintain Tableau dashboards, reports, and visualizations.
• Optimize Tableau workbooks for performance, usability, and scalability.
• Manage Tableau data sources, extracts, and refresh schedules.
• Ensure dashboards are accurate, consistent, and aligned with business definitions.

Data Analysis & Preparation

• Perform data preparation and validation to ensure analytical integrity.
• Identify data quality issues and partner with analytics and data engineering teams to resolve them.
• Apply consistent logic and definitions across analytical outputs.

Business Partnership & Requirements Gathering

• Meet with business users to understand reporting needs and analytical questions.
• Clarify requirements, assumptions, and success criteria before building dashboards.
• Iterate on analytics solutions based on feedback and evolving business needs.
• Help business users interpret dashboards and understand insights.

Governance & Operational Excellence

• Follow established analytics standards, data governance practices, and documentation guidelines.
• Ensure appropriate use of governed data and adherence to access controls.
• Contribute to continuous improvement by identifying opportunities to improve dashboards, processes, or documentation.
• Support consistent, repeatable analytics delivery across the BI team.

Additional Responsibilities

• Actively participate as a member of the HR and Talent Acquisition teams
• Attend relevant HR and company meetings, training sessions, and company-sponsored events
• Support standard work practices and participate in Lean initiatives
• Perform additional responsibilities as assigned

Physical Requirements:

The physical requirements…