Data Analyst II

As a 100% employee-owned contractor, when you work at Sundt, you’re not just hiring on at a company, you’re joining a culture. Because everyone at Sundt is part owner, you’ll join a team of people who are deeply invested in their work. From apprentices to managers, we’re passionate about the details and deliberate in everything we do.

At Sundt we focus on building long-term prosperity for our clients, communities, and employee-owners. We offer competitive pay, industry-leading benefits including a 401k and employee stock ownership plan, incentive programs for craft and administrative employees as well as training that focuses on your personal and professional growth. We’re driven by skill, grit and purpose. Join us as we strive to be the most skilled builder in America.

Job Summary

We are seeking a highly skilled (Business) Data Analyst with deep expertise in gathering and translating technical project requirements into actionable functional designs. This role is instrumental in the delivery of complex, data-driven initiatives across cross-functional teams, working closely with development engineers, project managers, business intelligence engineers, and QA/testing teams. The ideal candidate has a strong technical foundation, experience with modern data platforms like Databricks and Azure Data Factory (ADF), and a robust understanding of the ETL development lifecycle and data-oriented solutions.

This role requires the ability to work directly with business subject matter experts to understand and validate business requirements and then translate those into clear, technically sound specifications for engineering and testing teams. A solid understanding of business processes, especially within the construction industry, is a strong plus and will help the analyst ensure solutions are aligned with real-world operational needs.

Key Responsibilities

1.    Act as a liaison among business users, data engineers, analysts, and QA to ensure shared understanding and successful delivery of project outcomes.
2.    Analyze and document business requirements, ensuring alignment with technical feasibility and architectural standards.
3.    Collaborate with project managers and resource leadership to assist in project planning, milestone tracking, and resource coordination.
4.    Create and maintain functional design documents, source-to-target mappings, and data flow diagrams.
5.    Engage with business stakeholders and subject matter experts to understand business goals, processes, and data needs.
6.    Proactively identify risks, issues, and dependencies, ensuring transparent communication with stakeholders.
7.    Provide clear documentation to support development and test teams across the project lifecycle.
8.    Support User Acceptance Testing (UAT) by providing functional context and ensuring requirements traceability.
9.    Support development engineers by providing clear, well-documented requirements and assisting with data model and logic validation.
10.    Translate complex requirements into high-level and detailed functional specifications.

Minimum Job Requirements

1.    7+ years of experience as a data analyst or technical business analyst, including at least 2 years in a senior/lead capacity.
2.    Bachelor's or Master's degree in Data Science, Computer Science, Information Systems, Engineering, or related field.
3.    Excellent communication and documentation skills, with the ability to convey technical details to non-technical stakeholders.
4.    Experience in the construction industry or with data models relevant to construction operations and workflows preferred.
5.    Experience with Python or PySpark for data scripting and automation is a plus preferred.
6.    Experience working with large datasets and relational and non-relational databases.
7.    Exposure to cloud data architectures and data lakes (e.g., Azure Synapse, AWS Redshift, etc.) preferred.
8.    Familiarity with software development lifecycle (SDLC), Agile, and DevOps practices.
9.    Familiarity with tools such as Jira, Confluence, and Azure DevOps preferred.
10.    Hands-on experience with Databricks and Azure Data Factory (ADF) for building and managing scalable data solutions.
11.    Proficiency with Bl tools such as Power Bl, Tableau, or equivalent preferred.
12.    Proven experience with SQL Server including complex query development, stored procedures, and performance tuning.
13.    Strong analytical, organizational, and problem-solving skills.
14.    Strong understanding of the ETL development lifecycle, including data integration, transformation, and quality assurance.

Note: Job Description is subject to change at any time and may include other duties as assigned.

Physical Requirements

1.    May stoop, kneel, or