Data Engineer / Architect III - Finance Domain

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.

• Snowflake

• DBT

• Advanced SQL

• Data Warehousing

• ELT / ETL Engineering

• Enterprise Data Modeling

• Data Architecture

• Cloud Data Platforms

• Data Integration

• Data Transformation Frameworks

• Financial Services / Banking Experience

• Regulatory Reporting

• Power BI

• Data Governance

• M&A Integration Projects

• Java / J2EE

• Backend Engineering Experience

• 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.

• 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.

• 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.

• 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.

• Snowflake

• DBT

• ELT / ETL Frameworks

• Relational Databases

• Non-Relational Databases

• SQL

• Power BI (Preferred)

• Enterprise Data Modeling

• Data Warehousing

• Data Governance

• Java / J2EE (Preferred)
  

• 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.

• 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.
  

• 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.

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.

✔ 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