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 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.
Requirements
- 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.
- 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.
Nice-to-haves
- Other combinations of skills and experience may be considered.
Benefits
- Health care
- Retirement savings plans
- Paid time off
