Data Engineer

JOB DESCRIPTION

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

As a Data Engineer, you will be responsible for the end-to-end management of data across the organization, including its design, implementation, maintenance, discovery, and governance. The role involves close collaboration with various teams, including stakeholders, business intelligence teams, report builders, and developers, to ensure that data is consumed efficiently at all levels. For success in this position, meticulous attention to detail and a commitment to delivering top-quality data are essential. The ideal candidate will possess expertise in developing data relationships, deriving meaningful insights from datasets, and mastering Power Bi's advanced functionalities. Continuous learning and innovation are essential to providing the business with effective data solutions. You will be at the forefront of exploring the latest technologies and methodologies in business intelligence to keep us ahead of the curve.

In this role, career progression is structured into three steps (I, II, Senior). Step I is the entry level, ideal of individuals who meet the minimum requirements of this position, offering a chance to build on foundational skills and knowledge. Step II is for individuals that have at least three years of experience in this role and have enhanced their skills through solving complex problems. The Senior step is for those with over six years of experience that have exceptional proficiency and the ability to independently handle complex projects. These steps will provide a road map for professional growth and increased responsibilities.

Key Responsibilities

1. Build and maintain databases to store data for integrations and custom in-house developed applications

2. Build metadata repository to track data flow throughout the organization to determine system of record and allow for business self-discovery

3. Design, develop, and implement data pipelines to ensure high quality data is delivered on time

4. Develop and maintain data warehousing systems to be used for reporting and analysis

5. Develop and maintain documentation, including data models, data pipelines, database schemas, and data quality checks

6. Educate and support teams in fully leveraging data resources, ensuring high data quality and security standards across the company.

7. Manage and enhance Power Bl deployments, overseeing tenant and premium instances for optimal performance.

8. Manage data platforms to ensure correct configuration and performance optimization

9. Manage data privacy, security, compliance while enforcing data classification and protection requirements

10. Masterfully utilize Power Bl for creating datasets, writing DAX measures, and understanding data modeling with star schema.

11. Stay up to date with emerging technologies and best practices

Minimum Job Requirements

1. 1 years of Databricks, including Spark SOL experience strongly preferred

2. 3 years of SOL experience strongly preferred

3. Ability to adapt to changing priorities and manage multiple tasks.

4. Bachelor's Degree, 4 years relevant experience, or a combination of college education and relevant experience equivalent to 4 years

5. Exceptional verbal and written communication skills

6. Other preferred qualifications : Azure Data Factory, Azure DevOps, GIT repos, Python / Scala, SSIS, Cl / CD pipelines, Azure LogicApps, Power Bl, RedGate toolbelt, & XML

7. Proficiency in Power Bl, TSQL / Spark SQL, DAX, and GIT.

8. Proficient use of all Microsoft Office Suite programs

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 501bs 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