at ASSOCIATED BANK NATIONAL ASSOC in Chicago, Illinois, United States
Job Description
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 Senior Snowflake Engineer works with application developers to automate and accelerate the testing, release and deployment of applications into a runtime environment quickly and reliably. They will also have experience programming in a high-level language such as Ruby, Python, Java, C# or other language to script installation, configuration and provisioning. They will be providing continuous delivery solutions in a cloud environment and have experience with the core suite of tools used to manage different cloud providers.
The Senior Snowflake Engineer may also be responsible for building and maintaining optimized and highly available data pipelines that facilitate deeper analysis and reporting by the Data and Analytics department.
The Senior Snowflake Engineer will be responsible for mentoring and teaching existing team members. As such, the ideal candidate must have experience clearly explaining solutions to complex problems and demonstrate the ability to lead and impart knowledge effectively to junior resources.
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... For full info follow application link.
The employment policy of Associated Banc-Corp, and its subsidiaries and affiliates ("Associated") provides equal opportunity to all persons. We support a diverse and inclusive work environment where colleagues are respected, treated fairly, and given equal opportunities to perform to their fullest potential. We believe it is only with a diverse and inclusive workplace that the organization can truly perform at its best, carry out its vision, and make a difference for the communities we serve.