This position is no longer accepting applications
Closed on July 6, 2026.
This role is filled — get an email when new Data Processing roles open on EngineerJobs.io:
Data Engineer / Architect III - Finance Domain
Get alerted when similar jobs are posted — set up a New Data Processing jobs on EngineerJobs.io alert.
See other roles at Hudson Manpower.
Job Description
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