Position SummarySeeking 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 ResponsibilitiesEnterprise 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 EnvironmentCloud Data PlatformData TransformationDatabases- Relational Databases
- Non-Relational Databases
Analytics & ReportingArchitecture- Enterprise Data Modeling
- Data Warehousing
- Data Governance
Additional TechnologiesWhat 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 QualificationsTechnical 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 ProfileThe 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
