AlloBaas - Data Engineer II

First Mutual Holding Company; Lakewood (OH); Hybrid; USD 85,000 - 115,000; Full time

Job summary

First Mutual Holding Company is seeking a Data Engineer II to play a crucial role in their data transformation initiatives. This role focuses on data management, data integrations, and ensuring data accuracy across platforms.

The ideal candidate will have significant experience in data analysis and pipeline development, especially within the financial sector. An understanding of Snowflake and tools like Cognos and Tableau is essential.

Qualifications

• 3+ years managing data / ETL development.
• 3+ years hands-on in analyzing and designing data processes.
• 3+ years of Snowflake management.

Responsibilities

• Develop understanding of current data landscape.
• Administer Snowflake and data platforms for performance.
• Collaborate with IT stakeholders for data usability.

Skills

Data management

C#

GitHub

Azure DevOps

Data migration

Snowflake management

Data analysis

Cognos

Tableau

Job description

Job Type

Full-time

Description

Position Summary:

This position is under the AlloBaas subsidiary of FMHC.

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 Awareness
10. Decisiveness

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.