Data Engineer / Architect III - Finance Domain

Position Summary

Seeking a Data Engineer / Architect III to support a large-scale Merger & Acquisition (M&A) initiative within a complex financial services environment. This role focuses on enterprise data architecture, cloud data engineering, scalable ELT/ETL pipelines, and regulatory-grade data integration. The ideal candidate will possess strong expertise in Snowflake, DBT, Advanced SQL, Data Warehousing, and Enterprise Data Modeling.

This is a highly visible role requiring both hands-on engineering execution and architectural leadership while partnering with business stakeholders, enterprise architects, analysts, and reporting teams.

Employment Type : W2 – Full Time

Location : Cincinnati, Ohio (Onsite)

Industry : Financial Services / Banking

Contract Type : Long-Term Contract

Submission Deadline :June 2, 2026

Required Skills

• Snowflake

• DBT

• Advanced SQL

• Data Warehousing

• ELT / ETL Engineering

• Enterprise Data Modeling

• Data Architecture

• Cloud Data Platforms

• Data Integration

• Data Transformation Frameworks

Preferred Skills

• Financial Services / Banking Experience

• Regulatory Reporting

• Power BI

• Data Governance

• M&A Integration Projects

• Java / J2EE

• Backend Engineering Experience

Key Responsibilities

Enterprise Data Engineering & Architecture

• Design and implement scalable enterprise data architectures.

• Build and optimize cloud-native ELT/ETL pipelines using Snowflake and DBT.

• Develop reusable transformation frameworks and enterprise data models.

• Design scalable solutions supporting analytics, reporting, and operational data needs.

• Create high-performance analytical and operational data structures.

M&A Data Integration

• Support enterprise merger and acquisition data integration initiatives.

• Analyze and consolidate disparate data sources from acquired organizations.

• Standardize enterprise data definitions, mappings, and transformation logic.

• Ensure accurate migration and reconciliation of financial and operational data.

• Support enterprise-wide data consolidation efforts.

Data Quality & Governance

• Implement data validation and reconciliation processes.

• Support:

  • Data Lineage

  • Governance

  • Auditability

  • Regulatory Reporting Requirements

• Improve platform reliability, scalability, and maintainability.

• Assist with disaster recovery and operational resiliency planning.

Leadership & Collaboration

• Partner with:

  • Enterprise Architects

  • Data Engineers

  • Business Analysts

  • Reporting Teams

  • Data Scientists

  • Business Stakeholders

• Translate business requirements into scalable technical solutions.

• Participate in:

  • Architecture Reviews

  • Agile Ceremonies

  • Technical Planning Sessions

• Evaluate emerging technologies and engineering best practices.

Technical Environment

Cloud Data Platform

• Snowflake

Data Transformation

• DBT

• ELT / ETL Frameworks

Databases

• Relational Databases

• Non-Relational Databases

Analytics & Reporting

• SQL

• Power BI (Preferred)

Architecture

• Enterprise Data Modeling

• Data Warehousing

• Data Governance

Additional Technologies

• Java / J2EE (Preferred)
  

What Success Looks Like

• Deliver scalable and reliable enterprise data solutions.

• Successfully integrate data across M&A initiatives.

• Build optimized Snowflake and DBT transformation frameworks.

• Improve enterprise reporting, analytics, and governance capabilities.

• Ensure regulatory-quality data management and operational excellence.

Required Qualifications

Technical Requirements

• 6+ years of Data Engineering or Data Architecture experience.

• Strong hands-on Snowflake experience.

• Advanced SQL development and performance optimization expertise.

• Experience building DBT transformation frameworks.

• Strong understanding of Data Warehousing concepts.

• Experience designing scalable ELT/ETL pipelines.

• Experience with relational and non-relational databases.

• Strong knowledge of enterprise data modeling and analytics architecture.
  

Preferred Qualifications

• Financial Services or Banking industry experience.

• Regulatory reporting experience.

• Power BI or enterprise reporting platform experience.

• Exposure to Java, J2EE, or backend development technologies.

• Experience supporting large-scale M&A or enterprise integration initiatives.

Ideal Candidate Profile

The ideal candidate will:

• Be highly analytical and detail-oriented.

• Have experience working in regulated enterprise environments.

• Possess strong hands-on engineering and architecture skills.

• Excel at solving complex data integration challenges.

• Have expertise with modern cloud data platforms and transformation tools.

• Balance technical execution with business objectives.

• Collaborate effectively with technical and non-technical stakeholders.

Compensation & Benefits

• Medical, Dental & Vision Insurance

• 401(k)

• Paid Time Off

• Professional Development Opportunities

• Additional Benefits Package

Important Notes

✔ W2 Full-Time Opportunity

✔ Onsite Role – Cincinnati, Ohio

✔ Strong Snowflake Experience Required

✔ DBT & Advanced SQL Expertise Required

✔ Financial Services Experience Preferred

✔ Enterprise Data Architecture & M&A Integration Focus