Data Architect

ConsultNet
  • Chambersburg, PA
  • Quick Apply
8 days ago

Job Description

Role Overview
Lead the design of a modern, governed data foundation for a community bank moving from siloed systems toward an enterprise architecture that can support AI. You will own the current-state assessment, target-state architecture, warehouse and integration design, and data governance across core banking, wealth, and CRM systems, and Client the data groundwork for downstream use cases such as a relationship-manager copilot, Customer 360, and automated loan decisioning. This is a hands-on, client-facing architect role, not a purely advisory one.
Key Responsibilities
  • Assess the current state. Inventory data sources, flows, and gaps across FIS IBS core, InfoBanc/MaUI wealth, Salesforce FSC and Marketing Cloud, and the commercial, consumer, and mortgage LOS.
  • Define the target architecture. Design a warehouse or lake approach on SQL, Snowflake, or Databricks, sized to ~80,000 accounts and scalable well beyond, with a clear migration path off Salesforce-as-warehouse.
  • Design integration and pipelines. Specify ETL and vector-ETL and MuleSoft integration to de-silo and reconcile fragmented data into clean, governed inputs for analytics and AI.
  • Model Customer 360. Design the data model that unifies retail, commercial, and wealth relationships into a single, trusted customer view.
  • Stand up governance and quality. Establish data governance, modeling, lineage, and quality standards that extend the client's existing AI governance committee and satisfy examiner expectations for audit logging and documentation.
  • Enable downstream AI. Prepare the foundation for RAG and LLM use cases, including fair-lending and adverse-action data considerations for any model touching a credit decision.
  • Advise and mentor. Produce architecture briefs, data strategy, and roadmaps for leadership and budget planning, and coach the client's Salesforce-focused team toward permanent in-house data capability.
Required Qualifications
  • 8+ years in data architecture / engineering, including enterprise warehouse and lake design.
  • Cloud data platforms hands-on Snowflake, Databricks, Azure or AWS, and SQL Server.
  • ETL/ELT and integration experience; MuleSoft or a comparable iPaaS.
  • Data modeling (dimensional and/or data vault), governance, lineage, and quality frameworks.
  • Financial services experience, ideally banking across core, wealth, and lending, with regulatory and data-privacy context.
  • Salesforce data model familiarity; Financial Services Cloud a strong plus.
  • AI/ML data preparation experience readying data for ML and LLM/RAG use cases, including vector stores.
  • Client-facing communication able to translate architecture into decisions executives can fund.
Preferred

FIS IBS or comparable core exposure and wealth-platform familiarity Snowflake, Databricks, or Azure/AWS data certifications prior consulting or advisory delivery experience de-siloing a CRM-as-warehouse into a purpose-built data platform.


Welcome to ConsultNet, a premier national provider of technology talent and solutions. Our expertise spans across project services, contract-to-hire, direct search, and managed services onshore, nearshore, and hybrid. For over 25 years, we have connected thousands of consultants with meaningful roles through a personal, communication-driven approach, partnering with a diverse client base to build high-performing teams and create lasting impact. Our comprehensive service offerings cover a wide range of technology and engineering positions across key markets nationwide. Learn more at www.consultnet.com .

We champion equality and inclusivity, proudly supporting an Equal Opportunity Employer policy. We welcome applicants regardless of Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other status protected by law.




Numbers & Facts

LocationChambersburg, PA

Skills

  • Amazon Web Services (AWS)unmatched
  • Architectural Designunmatched
  • Artificial Intelligence (AI)unmatched
  • Banking Servicesunmatched
  • Budget Managementunmatched
  • Cloud Computingunmatched
  • Coachingunmatched
  • Communication Skillsunmatched
  • Community Bankingunmatched
  • Consultingunmatched
  • Customer Relationsunmatched
  • Customer Relationship Management (CRM)unmatched
  • Customer Relationship Management (CRM) Systemsunmatched
  • Data Cleaningunmatched
  • Data Modelingunmatched
  • DataArchitect Data Modeling Toolunmatched
  • Database Extract Transform and Load (ETL)unmatched
  • Documentationunmatched
  • Enterprise Architectureunmatched
  • Fair Lendingunmatched
  • Financial Servicesunmatched
  • Leadershipunmatched
  • Loan Regulationsunmatched
  • Marketingunmatched
  • Mentoringunmatched
  • Microsoft SQL Serverunmatched
  • Microsoft Windows Azureunmatched
  • Mortgageunmatched
  • Quality Metricsunmatched
  • Reconciliationunmatched
  • Retailunmatched
  • SQL (Structured Query Language)unmatched
  • Salesforce.comunmatched
  • Snowflake Schemaunmatched
  • Use Casesunmatched
  • Warehousingunmatched

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder