Data Engineer Architect

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