Data Engineer III

SAIF Corporation is dedicated to workplace safety and helping injured workers get back on their feet. They are seeking a Data Engineer III to design and support data pipelines, collaborate with data analysts and scientists, and enhance the organization's data infrastructure to meet its needs.

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

Requirements:

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