Principal Data Engineer - Logic and Metadata Architecture

Arvest Bank is seeking a Principal Data Engineer specializing in Logic and Metadata Architecture. The role involves leading the design and development of enterprise data platform solutions, mentoring data engineers, and ensuring the quality and efficiency of data management strategies.

Responsibilities:

• Serve as an SME while mentoring and providing solution oversight through the development of resilient data pipeline solutions
• Lead cross-team root cause analysis, troubleshoot highly complex problems and perform impact analysis of proposed changes
• Ensure quality of work delivered by the team meets standards for reusability, security, and performance and that data is available, usable, and fit for purpose
• Streamline the development and growth of data environments while proactively seeking opportunities for improvement
• Collaborate across the Enterprise to design solutions that meet business requirements and prove to be robust, stable, scalable, and adaptable over time
• Build solutions that are easily automated and allow for quick identification of failures
• Evaluate and optimize new integration patterns, frameworks, and third-party solutions by conducting research and developing proof-of-concept models. Influence the current and future state of technology by advocating technical difficulties experienced by the team
• Be an active leader in cross-product teams while promoting the re-use of data across the Company
• Lead code reviews and set code quality standards
• Understand and comply with bank policy, laws, regulations, and the bank's BSA/AML Program, as applicable to your job duties. This includes but is not limited to; complete compliance training and adhere to internal procedures and controls; report any known violations of compliance policy, laws, or regulations and report any suspicious customer and/or account activity

Requirements:

• Integrating holistic data management strategies, including master/reference data, metadata management, and data lineage
• Hands-on experience with Enterprise Data Catalogs (EDC), ETL/ELT (CMI) pipelines, Cloud Data Integration, and AI-driven metadata crawlers
• Ability to design Semantic Schema Network Models featuring complex, many-to-many relationships
• Deliver data solutions that directly support Counterparty validation, Legal Entity Identifiers (LEI), Customer 360 (C360), and Householding initiatives
• MUST HAVE: Certified Informatica Data Management Cloud: Foundational Series: MDM SaaS, Cloud Data Governance, Data Engineering
• MUST HAVE: DCAM: Data Management Capability Assessment Model Certification
• Applied Agentic AI: Systems, Design & Impact
• Cloud Data Integration: Designing cloud mappings, managing API gateways, and using Informatica Cloud Mapping Designer
• Cloud Data Quality: Build data quality rules, profiles, and processes for cloud data migrations and integration projects
• Cloud Data Governance and Catalog (CDGC)
• Lean Six Sigma
• COBIT 2019 certification
• CDMC: Certification: Cloud Data Management Capabilities
• CIMP: Certified Information Management Professional
• Bachelor's Degree in Information Systems, Computer Science, Business Intelligence, or related field, or equivalent related work or military experience
• 8 years of experience in designing and developing data queries for ETL data movement, including merging large data sets for analysis
• 2 years of experience in designing, building, managing, and optimizing data environments for advanced analytics and data science
• Advanced knowledge in SQL (DBT required)
• Building complex data sets
• Feature engineering
• Data science lifecycle
• Enterprise ETL tools (DataFlow, Dataproc, Data Fusion, DataStage, Informatica, or similar)
• Fluency in Python, Java, Kafka, and C#
• Pipeline Orchestration of data workloads (Apache Airflow or Cloud Composer)
• Standardization, security, governance, and compliance
• Relevant military experience is considered for veterans and transitioning service members
• Cloud Technologies
• Data Visualization tools (Tableau, Looker, or PowerBI)
• Prior banking/financial services experience
• Certifications: AWS Certified Big Data – Specialty, Google Cloud Professional Data Engineer