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:
- 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. Builds working knowledge of all applicable laws and regulations.
- 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:
- 3+ years managing data / ETL development, experience must include C#, GitHub (or similar), Azure DevOps, CI/CD Pipeline development.
- 3+ years hands on in analyzing, designing which involve Data pre-processing , Data Extraction , Data Ingestion , Data Quality ,Data Normalization/Anonymizing & Data Loading
- 3 + years data analysis, Ad hoc reports, and visualization; Cognos, Tableau
- 3+ years data migration and validation projects
- 3+ years of Snowflake Management
- 3+ years implementation and support of on-prem and cloud DBs
- 3+ years' experience with system process mapping
Additional Qualifications and Skills- Preferred:
- Prior work within the financial industry.
- Lean/Six Sigma
- Process analysis and design
- Systems architecture
Necessary competencies:
- Critical thinking
- Accountability
- Initiative
- Creativity
- Adaptable
- Communication
- Organizational Skills
- Resourcefulness
- Interpersonal Awareness
- 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.
