Data Engineer Architect

Hudson IT and Manpower

Cincinnati, Ohio, United States

Cincinnati, Ohio, United States

À propos

Position Summary 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.
Employment Type : W2 – Full Time Location : Cincinnati, Ohio (Onsite) Industry : Financial Services / Banking Contract Type : Long-Term Contract Submission Deadline :June 2, 2026
Required Skills
Snowflake DBT Advanced SQL Data Warehousing ELT / ETL Engineering Enterprise Data Modeling Data Architecture Cloud Data Platforms Data Integration Data Transformation Frameworks
Preferred Skills
Financial Services / Banking Experience Regulatory Reporting Power BI Data Governance M&A Integration Projects Java / J2EE Backend Engineering Experience
Key Responsibilities Enterprise Data Engineering & Architecture
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.
M&A Data Integration
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.
Data Quality & Governance
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.
Leadership & Collaboration
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.
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)
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.
Required Qualifications Technical 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.
Preferred Qualifications
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.
Ideal Candidate Profile 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.
Compensation & Benefits
Medical, Dental & Vision Insurance 401(k) Paid Time Off Professional Development Opportunities Additional Benefits Package
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

Cincinnati, Ohio, United States

Compétences linguistiques

English

Avis aux utilisateurs

Cette offre a été publiée par l’un de nos partenaires. Vous pouvez consulter l’offre originale ici.

Trouver des emplois similaires