Data Engineer II

Socket.dev; Lakewood (OH); Hybrid; USD 90,000 - 140,000; Full time

Job summary

First Mutual Holding Company in Lakewood, OH is seeking a Data Engineer II to drive our data transformation. You will manage data pipelines, oversee Snowflake, and ensure data is secure and accessible in real time for decision makers.

The role collaborates with IT and business stakeholders, supports data governance, and contributes to platform modernization with on‑prem and cloud databases, CI/CD pipelines, and analytics tools.

Qualifications

• 3+ years managing data/ETL development with C#, GitHub, Azure DevOps and CI/CD pipelines.
• 3+ years in data pre-processing, extraction, ingestion, quality, normalization/ anonymizing & loading.
• 3+ years data analysis, ad hoc reports, and visualization using Cognos and Tableau.
• 3+ years data migration and validation projects.
• 3+ years Snowflake management.
• 3+ years implementing and supporting on‑prem and cloud databases.
• 3+ years working with system process mapping.

Responsibilities

• Develop understanding of the current data landscape and align with business goals.
• Administer and optimize Snowflake and other data platforms for performance and cost.
• Manage operations of Data Warehouse, ESB, Cognos, and related analytics tools.
• Provide secondary support for data integration and platform engineering tasks.
• Collaborate with IT and business stakeholders to improve data access and usability.
• Design and develop pipelines for additional data vendors and ensure data accuracy.
• Enforce data governance, security, and regulatory compliance in data systems.

Skills

Data ETL development

C#

GitHub

Azure DevOps

CI/CD Pipelines

Data pre-processing

Data ingestion

Data quality

Snowflake management

On-prem & cloud DBs

System process mapping

Cognos

Tableau

Tools

Cognos

Tableau

Job description

Description

This position is not eligible for employer immigration sponsorship or participation in employment-based student training programs, including completion or execution of Form I-983 for STEM OPT.

Position Summary:

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:

1. Develop an understanding of our current data landscape
2. 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.
3. Manage operations of the Data Warehouse, Middleware/Azure Enterprise Service Bus (ESB), Cognos, and related analytics tools.
4. Provide secondary support for Data Integration & Platform Engineering responsibilities, including assisting with system maintenance, data pipeline operations, and platform enhancements.
5. Stay informed on emerging data technologies and trends, sharing insights to help identify opportunities for innovation and improved data use.
6. Help implement scalable and efficient data solutions that improve business insights and operational performance.
7. Collaborate with IT and business stakeholders to support data access, usability, and consistency across departments.
8. Participate in the integration of new tools and systems, ensuring seamless functionality and data accuracy.
9. Provide advanced support by resolving escalated issues from Data Engineer I, ensuring timely and effective resolution of complex technical challenges.
10. Contribute to a collaborative, high-performing team culture by supporting peers and sharing knowledge.
11. Enforce data governance policies, ensuring data is secure, consistent, and compliant with regulations.
12. Support efforts to meet financial regulations and cybersecurity standards in all data-related systems.
13. Administrator and/or deliver configuration requests in our Azure ESB environment to Banking Core System through APIs.
14. Design and develop pipelines for additional data vendors
15. Recommend, implement and maintain best practices for the environment
16. Ability to illustrate and maintain the enterprise’s data systems architecture
17. 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. Builds working knowledge of all applicable laws and regulations.
18. Other duties as assigned

The duties outlined above are a summary and may not be an exhaustive or comprehensive list of all possible responsibilities, tasks, and duties. All job descriptions may be amended at any time at the sole discretion of First Mutual Holding Company.

Requirements

Qualifications and Skills- Required:

1. 3+ years managing data / ETL development, experience must include C#, GitHub (or similar), Azure DevOps, CI/CD Pipeline development.
2. 3+ years hands on in analyzing, designing which involve Data pre-processing , Data Extraction , Data Ingestion , Data Quality ,Data Normalization/Anonymizing & Data Loading
3. 3 + years data analysis, Ad hoc reports, and visualization; Cognos, Tableau
4. 3+ years data migration and validation projects
5. 3+ years of Snowflake Management
6. 3+ years implementation and support of on-prem and cloud DBs
7. 3+ years’ experience with system process mapping

Additional Qualifications and Skills- Preferred:

1. Prior work within the financial industry.
2. Lean/Six Sigma
3. Process analysis and design
4. Systems architecture

Necessary competencies:

1. Critical thinking
2. Accountability
3. Initiative
4. Creativity
5. Adaptable
6. Communication
7. Organizational Skills
8. Resourcefulness
9. Interpersonal AwarenessDecisiveness

Physical Environment:

• This position is performed in a corporate office (Lakewood, OH), hybrid, or remote setting: If fully remote, must be willing to travel
• This position will require the ability to work flexible days/times including occasionally working beyond normal business hours on an “as needed” basis.
• While performing the duties of this job, the employee is regularly required to lift, walk, stand, sit, bend, reach with hands and arms, climb, push/pull, use hands, and see, hear and speak.
• The employee must occasionally lift and/or move up to 25 pounds.
• The noise level in the work environment is usually quiet to moderate.

First Mutual Holding Co. and First Federal Lakewood is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment.