Senior Snowflake Engineer

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.

We can hire candidates located within the Associated Bank footprint.
This includes the states of Arizona, Connecticut, Florida, Illinois, Iowa, Indiana, Massachusetts, Maine, Michigan, Minnesota, Missouri, Nebraska, New Hampshire, New Jersey, New York, Nevada, Ohio, Pennsylvania, Rhode Island, South Carolina, Texas, and Wisconsin.

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 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-premise and cloud-based environments.
  
• Develop and automate ETL code using scripting languages, ETL tools and job scheduling software to support all reporting and analytical data needs.
  
• 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.
  
• Collaborate with data architects and modelers on data store designs and best practices

Education

• Bachelor's Degree or equivalent combination of education and experience Mathematics, Computer Science, Management Information Systems, Data Science, Analytics.
  Required

Experience

• 5-7 years with a broad portfolio of AWS infrastructure tools (EBS, S3, EC2, Elastic IP, Route 53, VPC) and with cloud infrastructure management and automation technologies.
  Required
• 5-7 years working with basic structured, semi-structured, and unstructured data.
  Basic SQL knowledge proficiency and analytical skills.
  Required
• Exposure to modern data/analytics architecture (Big Data, Cloud, etc.) Required
• Exposure to advanced analytics tools (Python, R, etc).
  Scripting (shell, python, ruby) skills for monitoring and automation.
  Required
• 2 years of experience with Python programming.
  Preferred
• 3 years data engineering experience on the Microsoft Azure, AWS, GCP and/or Snowflake platforms.
  Preferred

Other Technical Skills

• Thorough understanding of relational, columnar and NoSQL database architectures and industry best practices for development
• Understanding of dimensional data modeling for designing and building data warehouses
• Excellent advanced SQL coding and performance tuning skills
• Experience with Infrastructure as Code (IAC) tools such as Terraform
• Experience with big data streaming technologies such as Kafka
• Experience with parsing data formats such as XML/JSON and leveraging external APIs.
  

In addition to core traditional benefits, we take pride in offering benefits for every stage of life.

• Retirement savings including both 401(k) and Pension plans.
  

• Paid time off to volunteer in your community.
  

• Opportunities to connect with others through our diversity-focusedColleague Resource Groups.
  

• Competitive salaries with professional development and advancement opportunities.
  

• Bonus benefits including well-being programs and incentives, parental leave,anemployee stock purchase plan, military benefits and much more.
  

• Personal banking, loan, investmentand insurance benefits.
  

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.Join our community onFacebook,LinkedInandX.

Compliance Statement

Associated 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.
Responsible to report all customer complaints as prescribed and procedure violations to management or HR.

Responsible to report ethical concerns as needed to Associated Bank's anonymous Ethics Hotline.

Associated Bank provides additional assistance to individuals with disabilities throughout the application & interview process.
Please ***if you need an accommodation at any time during the interview process.

Associated Banc-Corp is an Affirmative Action andEqual Opportunity Employer.
Associated Banc-Corp participates in the E-Verify Program.
E-Verify NoticeEnglish or Spanish.
Know Your Right to WorkEnglishorSpanish.

Associated Bank isPay Transparencycompliant.