Data Engineer / Architect III - Finance Domain

Hudson Manpower•Cincinnati, OH

20h•Onsite

About The Position

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.

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.

Nice To Haves

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.

Responsibilities

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.