Compensation Grade:‏‏‎ ‎157

Job Description

When it comes to city development, city engineers are essential in designing and building stable, efficient, and effective roads and infrastructure to meet the needs of the people who use them.

From helping to design, develop, and support data pipelines to extracting, cleaning, and loading data into the data warehouse, our data engineers are like the city engineers of SAIF’s data program. Our new data engineer will work closely with data analysts and data scientists, as well as other key stakeholders throughout the company, to ensure our data systems are designed to meet the organization’s needs.

A qualified candidate has 5+ years’ experience working with various programming languages and data management tools, such as SQL, Python, Informatica, Databricks and cloud-based data processing platforms like AWS or Azure. If you’d enjoy the opportunity to use cutting-edge technologies to work with large and complex datasets, and to join a collaborative and supportive team to build and design our enterprise Data Lake from the ground-up, we encourage you to apply.  

Please note: Remote workers may be required to occasionally travel to SAIF’s offices in Salem, Oregon.

Responsibilities:

• Design, develop, and support data pipelines, including scripts required to extract, transform, clean, and load data into a data warehouse or data lake.
• Design and build analytics solutions that utilize the data repository to provide actionable insights that will enable data driven decision-making.
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, automating data validation, etc.
• Create data solutions for analytics and data teams to assist them in building and optimizing our data assets to be innovative industry leaders.
• Lead and coordinate the work of other less experienced decision support team members.
• Conduct research into new technologies and determine viability for adoption.
• Develop best practices on installing, configuring, and using BI and analytics solutions to enhance productivity.
• Create and document data warehouse development standards.
• Work with stakeholders and data analysts throughout the organization to assist with data-related technical issues and support their data infrastructure needs.
• Incorporate new and existing subject areas into an enterprise model.
• Design and develop multidimensional OLAP cubes for end users.
• Provide direction for data verification and testing methods.
• Review data loaded into the data warehouse and data lake for accuracy.
• Troubleshoot, maintain, revise, and test existing data warehouse solutions, and tune for performance.
• Design, develop, and support semantic data layers for ingest by BI applications.
• Troubleshoot data issues for power users and other stakeholders who develop self-service data analysis on behalf of their divisions.
• Explore diverse perspectives and consistently behave sensitively toward differences in cultural norms, expectations, and ways of communicating. Work effectively with others who have different perspectives, backgrounds, and/or work styles.
• Continually sustain the Inclusive Leadership Competencies (ILC) through the Explorer level on an annual basis.

Recommended qualifications:

• Five or more years of experience in Data Warehousing concepts in relational databases like SQL Server, Oracle and Snowflake. Five or more years of experience working with ETL technologies like SSIS, Informatica and Databricks.  Demonstrated experience supporting and working collaboratively in cross-functional teams, including conveying technical messages to non-technical stakeholders and team members.
• A bachelor’s degree in computer science, information technology, or a related field.

• Other combinations of skills and experience may be considered.

Next step

To receive consideration, please submit your resume with a cover letter by the close of this recruitment. We want your submission to count, so be sure it’s complete.

This recruitment will close on Friday, April 25, 2025.

If a sufficient number of qualified applications are received this recruitment may close early.

Compensation & Benefits

Typical hiring range:‏‏‎ ‎$116,008‏‏‎ ‎-‏‏‎ ‎$136,480.‏‏‎ ‎The pay range for this position is annually based on a full-time schedule. Actual compensation will be determined using factors such as experience, skills, training, certifications & education. 

SAIF provides a wide range of benefits to employees who work at least 20 hours per week, including health care, retirement savings plans, paid time off, and more. For additional information about SAIF's total rewards, visit our website at: Total rewards (saif.com)

*Note that eligibility and cost of benefits can vary depending on the number of regularly scheduled hours, and job status such as regular full-time, regular part-time, seasonal, or temporary employment.

Full salary range:‏‏‎‏‏‎ ‎$102,360‏‏‎ ‎-‏‏‎ ‎$170,600

Veterans

We provide preference to qualifying and disabled veterans. For more information please visit saif.com/veterans.

About us

Since 1914, SAIF has been taking care of injured workers, helping people get back to work, and keeping rates low by focusing on workplace safety. Together with our partners, we strive to make Oregon the safest and healthiest place to work.

SAIF is an Equal Opportunity Employer that values diversity in its workplace.