Data Engineer II

Responsibilities:
- The data engineer designs and builds platforms, tools, and solutions that help the bank manage, secure, and generate value from its data.
- The person in this role creates scalable and reusable solutions for gathering, collecting, storing, processing, and serving data on both small and very large (i.e. Big Data) scales. These solutions can include on-premises and cloud-based data platforms, and solutions in any of the following domains ETL, business intelligence, analytics, persistence (relational, NoSQL, data lakes), search, messaging, data warehousing, stream processing, and machine learning.
- Responsible and accountable for risk by openly exchanging ideas and opinions, elevating concerns, and personally following policies and procedures as defined.
- Accountable for always doing the right thing for customers and colleagues and ensures that actions and behaviors drive a positive customer experience. While operating within the Bank's risk appetite, achieves results by consistently identifying, assessing, managing, monitoring, and reporting risks of all types.

Qualifications:
- Bachelor's degree in Computer Science/Information Systems or equivalent combination of education and experience with 3 years + of experience communicating ideas both verbally and in writing to management, business and IT sponsors, and technical resources in the appropriate language for each group.

Essential Skills:
- Fundamental understanding of distributed computing principles & knowledge of application and data security concepts, best practices, and common vulnerabilities.
- Conceptual understanding of one or more of the following: Big Data technologies, distributions, metadata management products, commercial ETL tools, BI and reporting tools, messaging systems, data warehousing, Java (language and run time environment), major version control systems, continuous integration/delivery tools, infrastructure automation and virtualization tools, major cloud, or rest API design and development.

Required:
- Strong SQL skills
- Experience building ETL Pipelines (specifically migrating DB2 to Snowflake)
- Experience using cloud technology - AWS/Snowflake/S3
- Experience with at least 1 RDBMS
- Experience using/contributing to data cataloging/data dictionary (Alation preferred)
- Passion for quality and testing practices
- Ability to research and solve problems independently
- Strong written and verbal communication skills

Nice to have:
- Financial industry knowledge / prior work experience in the finance industry
- Experience with NiFi/Kafka
- Experience tracking data lineage (IGC preferred)
- Experience with Python
- Experience with virtualization (Denodo preferred)