Data Engineer Architect

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