Data Engineer II

The Data Engineer II will play a vital role in our Data transformation journey — helping move the organization toward a future state where decision-makers have the right data, in real time, when they need it. This role is responsible for driving the execution of key data projects, including data management, data conversions, ongoing ingestion pipelines, and data platform engineering and operations. The ideal candidate will work across systems and teams to ensure data flows seamlessly, reliably, and securely throughout the enterprise, supporting both strategic initiatives and day-to-day operations.
Duties and Responsibilities:
Develop an understanding of our current data landscape Administer and optimize Snowflake and other data platforms to ensure performance and alignment with business goals including role/permission management performance tuning, cost optimization, and capacity planning. Manage operations of the Data Warehouse, Middleware/Azure Enterprise Service Bus (ESB), Cognos, and related analytics tools. Provide secondary support for Data Integration & Platform Engineering responsibilities, including assisting with system maintenance, data pipeline operations, and platform enhancements. Stay informed on emerging data technologies and trends, sharing insights to help identify opportunities for innovation and improved data use. Help implement scalable and efficient data solutions that improve business insights and operational performance. Collaborate with IT and business stakeholders to support data access, usability, and consistency across departments. Participate in the integration of new tools and systems, ensuring seamless functionality and data accuracy. Provide advanced support by resolving escalated issues from Data Engineer I, ensuring timely and effective resolution of complex technical challenges. Contribute to a collaborative, high-performing team culture by supporting peers and sharing knowledge. Enforce data governance policies, ensuring data is secure, consistent, and compliant with regulations. Support efforts to meet financial regulations and cybersecurity standards in all data-related systems. Administrator and/or deliver configuration requests in our Azure ESB environment to Banking Core System through APIs. Design and develop pipelines for additional data vendors Recommend, implement and maintain best practices for the environment Ability to illustrate and maintain the enterprise’s data systems architecture Complies with all applicable banking laws and regulations, including, but not limited to the Bank Secrecy Act, must be eligible to work in the U.S. Patriot Act, and related anti-money laundering statutes, and federal consumer protection legislation and regulations. Builds working knowledge of all applicable laws and regulations. Other duties as assigned

Requirements

Python, ETL - Extract Transform Load, Snowflake, Microsoft SQL, Power BI, Cognos, Tableau