Note: The job is a remote job and is open to candidates in USA. Arvest Bank is a financial services organization focused on helping people find financial solutions for life. The Principal Data Engineer leads the design and development of enterprise data platform solutions, oversees data architecture, mentors data engineers, and provides technical leadership across agile teams. The role focuses on resilient data pipelines, data quality, integration, governance, scalability, and compliance.
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
Skills
- 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
- Certified Informatica Data Management Cloud: Foundational Series: MDM SaaS, Cloud Data Governance, Data Engineering
- 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
- Position is Monday through Friday from 8 am to 5 pm Central with the ability to work additional hours as project needs demand
- Incumbent should be located anywhere within the Arvest 4 State Footprint (AR, KS, MO, OK)
- 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
- 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
- Reasonable accommodations may be made to enable qualified individuals with disabilities to perform the essential functions
- 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
Benefits
- A comprehensive suite of benefits, including a full range of health and life, financial, and wellness benefits.
- Remote work options may be available outside of the 4-state footprint upon further review during the interview process.
- Significant professional growth.
- Associates are encouraged to grow professionally and personally.
Company Overview
Company H1B Sponsorship