Data Engineer 2

Korn Ferry; Lakewood (OH); Remote; USD 90,000 - 120,000; Full time

Job summary

A leading consulting firm is seeking a Data Engineer II to support their data transformation projects. In this role, you will manage data operations and optimize platforms like Snowflake, ensuring the flow and security of data across systems. The ideal candidate will have over 5 years of experience in data management, ETL development, and data analysis tools such as Cognos and Tableau. Prior experience in the financial industry is preferred, and this position is remote.

Qualifications

• 3+ years managing data / ETL development.
• 5+ years of Snowflake management.
• Prior work within the financial industry is preferred.

Responsibilities

• Manage operations of the Data Warehouse and related analytics tools.
• Administer and optimize Snowflake and other data platforms.
• Collaborate with IT and business stakeholders to support data access.

Skills

Data management

Data analysis

ETL development

Snowflake management

Cognos

Tableau

Education

Any degree

Tools

Snowflake

Cognos

Tableau

Job description

Overview

We have partnered with our client in their search for a Data Engineer 2.

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.

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, USA Patriot Act, and related anti-money laundering statutes, and federal consumer protection legislation and regulations

Qualifications

• 3+ years managing data / ETL development
• 3+ years hands on in analyzing and designing data processes including pre-processing, extraction, ingestion, quality, normalization/anonymizing, and loading
• 5+ years data analysis, ad hoc reporting, and visualization using Cognos, Tableau
• 5+ years data migration and validation projects
• 5+ years of Snowflake management
• 5+ years implementation and support of on-prem and cloud databases
• 5+ years of experience with system process mapping
• Prior work within the financial industry is preferred

Education & Work Experience

• Degree - Any
• Work Experience - 4-8 years of experience

Location: Remote