Data Engineer / Architect III - Finance Domain

Hudson Manpower is seeking a Data Engineer / Architect III for the Finance domain to lead a large-scale M&A data initiative. The role emphasizes building scalable enterprise data architectures and cloud-native data pipelines, with a focus on regulatory-grade data integration and robust analytics support. This position blends hands-on engineering with architectural leadership, requiring expertise in Snowflake, DBT, advanced SQL, data warehousing, and enterprise data modeling.

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

Requirements

• Snowflake
• DBT
• Advanced SQL
• Data Warehousing
• ELT / ETL Engineering
• Enterprise Data Modeling
• Data Architecture
• Cloud Data Platforms
• Data Integration
• Data Transformation Frameworks
• 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

Technologies

• Snowflake
• DBT
• SQL
• Power BI
• Java / J2EE

Benefits

• Medical, Dental & Vision Insurance
• 401(k)
• Paid Time Off
• Professional Development Opportunities
• Additional Benefits Package

Employment Type

W2 – Full Time

Location

Cincinnati, Ohio (Onsite)

Industry

Financial Services / Banking

Contract Type

Long-Term Contract

Submission Deadline

June 2, 2026

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.

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)

Ideal Candidate Profile

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

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