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 bend, on an occasional basis 2. Must be able to comply with all safety standards and procedures 3. Required to use hands to grasp, lift, handle, carry or feel objects on a frequent basis 4. Will interact with people and technology frequently during a shift/work day 5. Will lift, push or pull objects up to 50Ibs on an occasional basis. 6. Will sit, stand or walk short distances for up to the entire duration of a shift/work day. 7. Will use telephone, computer system, email, and other electronic devices on a frequent basis to communicate with internal and external customers or vendors Safety Level Non-Safety Sensitive Note:Jobs with the Safety-Sensitive designation are those that include tasks or duties that the employer reasonably believes could affect the safety and health of the employee performing the task or others such as operating a vehicle, operating equipment, operating machinery or power tools, repairing/maintaining the operation of any vehicle/equipment, the handling/disposal/transport of hazardous materials, or the handling/treatment/disposal of potentially flammable/combustible materials. Equal Opportunity Employer Statement: Sundt is committed to the equal treatment of all employees, and/or applicants for employment, and prohibits discrimination based on race, religion, sex (including pregnancy), sexual orientation, gender identity, color, age, disability, national origin, covered veteran status, genetic information; or any other classification protected by applicable Federal, state, or local laws. Benefit list: Market Competitive Salary (paid weekly) Bonus Eligibility based on company, group, and individual performance Employee Stock Ownership Plan & 401K Industry Leading Health Coverage Starting Your First Day Flexible Time Off (FTO) Medical, Health Savings, and Wellness credits Flexible Spending Accounts Employee Assistance Program Workplace Wellness Programs Mental Health Program Life and Disability Insurance Employee-Owner Perks Educational Assistance Sundt Foundation - Charitable Employee-Owner's program