Data Engineer / Architect III - Finance Domain

Location: Cincinnati, Ohio (onsite). Compensation: USD 50 - 55 per hour. Employment: W2, full-time on a long-term contract. This Finance domain opportunity from Hudson Manpower pairs hands-on engineering with architectural leadership to drive a large scale M&A data integration program, delivering scalable, governance-driven data platforms that support analytics, reporting, and regulatory compliance.

Benefits

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

Responsibilities

• Design and deploy scalable enterprise data architectures to support analytics and operations.
• Build and optimize cloud-native ELT/ETL pipelines using Snowflake and DBT.
• Develop reusable transformation frameworks and enterprise data models.
• Create scalable solutions for analytics, reporting, and operational data needs.
• Construct high-performance analytical and operational data structures.
• Support data integration initiatives related to mergers and acquisitions.
• Analyze and consolidate disparate data sources from acquired organizations.
• Standardize data definitions, mappings, and transformation logic across the enterprise.
• Ensure accurate migration and reconciliation of financial and operational data.
• Support enterprise-wide data consolidation efforts and data governance efforts.
• Implement data validation, reconciliation processes, and data lineage practices.
• Support governance, auditability, and regulatory reporting requirements.
• Improve platform reliability, scalability, and maintainability; assist with disaster recovery planning.
• Collaborate with Enterprise Architects, Data Engineers, Business Analysts, Reporting Teams, Data Scientists, and Business Stakeholders.
• Translate business requirements into scalable technical solutions and participate in architecture reviews and planning sessions.
• Evaluate emerging technologies and engineering best practices to inform roadmaps.

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

Technical Environment

• Cloud Data Platform: Snowflake
• Data Transformation: DBT; ELT / ETL Frameworks
• Databases: Relational and Non-Relational
• Analytics & Reporting: SQL; Power BI
• Architecture: Enterprise Data Modeling; Data Warehousing; Data Governance
• Additional Technologies: Java / J2EE

What success looks like

• Deliver scalable and reliable enterprise data solutions that support business needs
• Successfully integrate data across merger and acquisition initiatives
• Build optimized Snowflake and DBT transformation frameworks
• Enhance enterprise reporting, analytics, and governance capabilities
• Maintain regulatory-quality data management and strong operational excellence

Ideal Candidate Profile

• Highly analytical and detail-oriented with a disciplined approach
• Experience in regulated, enterprise environments
• Strong hands-on engineering and architectural capabilities
• Proven ability to solve complex data integration challenges
• Expertise with modern cloud data platforms and transformation tools
• Ability to balance technical execution with business aims
• Collaborates 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
• Submission Deadline: June 2, 2026