Associated Bank - Corp
Senior Snowflake Engineer
Associated Bank - Corp, Charleston, West Virginia, United States,
At Associated Bank we strive to create an inclusive culture where different perspectives are valued and recognized as strengths critical to our success. If you thrive in an environment where your growth and development are encouraged and supported, then Associated Bank may be the right place for you.The Data Engineer Senior will have a strong background in data engineering, with extensive experience in designing, building, and maintaining scalable data pipelines and architectures. As a Data Engineer Senior, you will play a critical role in shaping our data infrastructure, ensuring the availability, reliability, and performance of our data systems. The Data Engineer Senior will be responsible for mentoring and teaching existing colleagues. As such, the ideal candidate must have experience clearly explaining solutions to complex problems and demonstrate the ability to lead and impact knowledge effectively to junior resources.THIS POSITION IS NOT ELIGIBLE FOR VISA SPONSORSHIP.We invite you to view the opportunity below.As a Senior Snowflake Engineer, you will:
Design, develop, test, and deploy streaming and batch ingestion methods and pipelines across a variety of data domains leveraging programming languages, application integration software, messaging technologies, REST APIs and ETL/ELT tools.Ensure that high-throughput, low-latency, and fault-tolerant data pipelines are developed by applying best practices to the data mapping, code development, error handling and automation.As part of an agile team, design, develop and maintain an optimal data pipeline architecture using both structured data sources and big data for both on-premises and cloud-based environments.Develop and automate ETL/ELT code using scripting languages and ETL tools to support all reporting and analytical data needs.Following DataOps best practices, enable orchestration of data, tools, environments, and code.Design and build dimensional data models to support the data warehouse initiatives.Identify, design, and implement internal process improvements: automating manual processes, optimizing data pipeline performance, re-designing infrastructure for greater scalability and access to information.Participate in requirements gathering sessions to distill technical requirements from business requests.Collaborate with business partners to productionize, optimize, and scale enterprise analytics.Education
Bachelor's Degree or equivalent combination of education and experience in Computer Science, Information Technology, Engineering, or related field.
RequiredMaster's Degree preferred in Computer Science, Information Technology, Engineering, or related field.
PreferredExperience
5-6 years data engineering focused on using ETL or ELT patterns to build automated data pipelines or related technologies.
Required3-5 years' experience Cloud platforms (AWS, Azure, GCP, Snowflake) Snowflake preferred and Python programming or advanced SQL coding and performance tuning skills.
RequiredThorough understanding of relational, columnar and NoSQL database architectures and industry best practices for development.
PreferredUnderstanding of dimensional data modeling for designing and building data warehouses.
PreferredExperience with Infrastructure as Code (IAC) tools such as Terraform.
PreferredExperience with big data streaming technologies such as Kafka.
PreferredExperience with parsing data formats such as XML/JSON and leveraging external APIs.
PreferredAdditional Skills
Strong problem-solving and analytical skills.Excellent communication and collaboration skills.Ability to work in a fast-paced, dynamic environment.Attention to detail and commitment to data quality.Associated Bank serves more than 120 communities throughout Wisconsin, Illinois and Minnesota and we consider our colleagues critical to our continued success. See why our colleagues continually vote us a best place to work in the Midwest.Compliance StatementAssociated Bank is an equal opportunity employer committed to creating a diverse workforce. We support a work environment where colleagues are respected and given the opportunity to perform to their fullest potential. We consider all qualified applicants without regard to race, religion, color, sex, national origin, age, sexual orientation, gender identity, disability or veteran status, among other factors.Fully complies with all applicable enterprise policies and procedures. Acts in compliance with all applicable laws and regulations as outlined in training materials, including but not limited to Bank Secrecy Act. Responsible for reporting suspicious activity to Financial Intelligence.
#J-18808-Ljbffr
Design, develop, test, and deploy streaming and batch ingestion methods and pipelines across a variety of data domains leveraging programming languages, application integration software, messaging technologies, REST APIs and ETL/ELT tools.Ensure that high-throughput, low-latency, and fault-tolerant data pipelines are developed by applying best practices to the data mapping, code development, error handling and automation.As part of an agile team, design, develop and maintain an optimal data pipeline architecture using both structured data sources and big data for both on-premises and cloud-based environments.Develop and automate ETL/ELT code using scripting languages and ETL tools to support all reporting and analytical data needs.Following DataOps best practices, enable orchestration of data, tools, environments, and code.Design and build dimensional data models to support the data warehouse initiatives.Identify, design, and implement internal process improvements: automating manual processes, optimizing data pipeline performance, re-designing infrastructure for greater scalability and access to information.Participate in requirements gathering sessions to distill technical requirements from business requests.Collaborate with business partners to productionize, optimize, and scale enterprise analytics.Education
Bachelor's Degree or equivalent combination of education and experience in Computer Science, Information Technology, Engineering, or related field.
RequiredMaster's Degree preferred in Computer Science, Information Technology, Engineering, or related field.
PreferredExperience
5-6 years data engineering focused on using ETL or ELT patterns to build automated data pipelines or related technologies.
Required3-5 years' experience Cloud platforms (AWS, Azure, GCP, Snowflake) Snowflake preferred and Python programming or advanced SQL coding and performance tuning skills.
RequiredThorough understanding of relational, columnar and NoSQL database architectures and industry best practices for development.
PreferredUnderstanding of dimensional data modeling for designing and building data warehouses.
PreferredExperience with Infrastructure as Code (IAC) tools such as Terraform.
PreferredExperience with big data streaming technologies such as Kafka.
PreferredExperience with parsing data formats such as XML/JSON and leveraging external APIs.
PreferredAdditional Skills
Strong problem-solving and analytical skills.Excellent communication and collaboration skills.Ability to work in a fast-paced, dynamic environment.Attention to detail and commitment to data quality.Associated Bank serves more than 120 communities throughout Wisconsin, Illinois and Minnesota and we consider our colleagues critical to our continued success. See why our colleagues continually vote us a best place to work in the Midwest.Compliance StatementAssociated Bank is an equal opportunity employer committed to creating a diverse workforce. We support a work environment where colleagues are respected and given the opportunity to perform to their fullest potential. We consider all qualified applicants without regard to race, religion, color, sex, national origin, age, sexual orientation, gender identity, disability or veteran status, among other factors.Fully complies with all applicable enterprise policies and procedures. Acts in compliance with all applicable laws and regulations as outlined in training materials, including but not limited to Bank Secrecy Act. Responsible for reporting suspicious activity to Financial Intelligence.
#J-18808-Ljbffr