Data Engineer – Azure Pipelines & Modeling

Schweitzer Engineering Laboratories, Inc.; Pullman (WA); On-site; USD 98,000 - 144,000; Full time

Benefits offered by this job

ESOP

401(k)

Competitive health benefits

Paid holidays

Paid vacation

Sick leave

Family leave

Tuition assistance

Job summary

Schweitzer Engineering Laboratories, Inc. seeks a Data Engineer to join our growing data team in Pullman, WA.

You will design, develop, and maintain robust data pipelines using Azure Data Factory, Azure SQL, Azure Data Lake, Azure Stream Analytics, and Fabric, while working with SQL Server, SSIS, and SSAS on-premises. You will craft normalized data models for OLTP/OLAP and collaborate with stakeholders to build enterprise reporting models.

Qualifications

• Have hands-on experience with data services in a professional setting.
• Have a strong grasp of data modeling, SQL, and cloud-based data architecture.
• Thrive in collaborative environments and enjoy working closely with cross-functional teams.
• Are committed to continuous learning and staying up to date with evolving data technologies.
• Are genuinely passionate about data and driven to make a meaningful impact through your work.

Responsibilities

• Design, develop, and maintain robust data pipelines using Azure data tools and Fabric.
• Work with on-premises tools such as SQL Server, SSIS, and SSAS.
• Design normalized relational and/or dimensional data models for OLTP and OLAP systems.
• Collaborate with stakeholders to design and implement enterprise reporting models.
• Administer and optimize data solutions for performance, scalability and reliability.

Skills

Data pipelines

SQL

Cloud architecture

Data modeling

Collaboration

Learning mindset

Tools

Azure Data Factory

Azure SQL

Azure Data Lake

Azure Stream Analytics

Fabric

SQL Server

SSIS

SSAS

Job description

Schweitzer Engineering Laboratories, Inc. seeks a Data Engineer to join our growing data team in Pullman, WA.

You will design, develop, and maintain robust data pipelines using Azure Data Factory, Azure SQL, Azure Data Lake, Azure Stream Analytics, and Fabric, while working with SQL Server, SSIS, and SSAS on-premises. You will craft normalized data models for OLTP/OLAP and collaborate with stakeholders to build enterprise reporting models.