Data Engineer / Architect III - Finance Domain

Responsibilities

• Design and implement scalable enterprise data architectures to support analytics, reporting, 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 that meet analytics, reporting, and operational data needs
• Build 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
• Establish data lineage, governance, auditability, and regulatory reporting readiness
• 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, and business stakeholders
• Translate business requirements into scalable technical solutions
• Participate in architecture reviews, agile ceremonies, and technical planning sessions
• Evaluate emerging technologies and engineering best practices

Requirements

• Strong hands‑on Snowflake experience
• Proficiency with DBT
• Advanced SQL development and performance optimization
• Expertise in data warehousing concepts
• Experience building scalable ELT/ETL pipelines
• Enterprise data modeling and data architecture
• Cloud data platforms and data integration
• Experience with data transformation frameworks
• 6+ years of data engineering or data architecture experience
• Relational and non‑relational database experience
• Strong knowledge of analytics architecture and enterprise data modeling

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 and Non‑Relational Databases
• Analytics & Reporting: SQL; Power BI
• Architecture: Enterprise Data Modeling; Data Warehousing; Data Governance
• Additional Technologies: Java / J2EE

Ideal Candidate Profile

• Highly analytical and detail‑oriented
• Experience in regulated enterprise environments
• Strong hands‑on engineering and architecture capabilities
• Excels at solving complex data integration challenges
• Expertise with modern cloud data platforms and transformation tools
• Balances technical execution with business objectives
• Collaborates effectively with technical and non‑technical stakeholders

Important Notes

• W2 Full‑Time Opportunity
• Onsite Role – Cincinnati, Ohio
• Strong Snowflake Experience Required
• DBT and Advanced SQL Expertise Required
• Financial Services Experience Preferred
• Enterprise Data Architecture and M&A Integration Focus