Data Engineer III

SAIF Corporation

2d • $118,329 - $139,210 • Remote

About The Position

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 3+ years’ experience working with various programming languages and data management tools, such as SQL, Python, Fivetran, dbt, 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: The selected candidate must reside in Oregon and may work remotely from their home office or from a SAIF office.

Requirements

• A qualified candidate has 3+ years’ experience working with various programming languages and data management tools, such as SQL, Python, Fivetran, dbt, Databricks and cloud-based data processing platforms like AWS or Azure.

Nice To Haves

• 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.

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.
• On-call support may be required on an as needed basis or part of a rotating schedule, including availability outside of business hours to support urgent IT issues or system implementations.
• 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.
• Perform other duties as assigned by management to support team objectives and organizational goals, demonstrating flexibility and adaptability in responding to evolving priorities and needs.

Benefits

• 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level