At Texas Capital Bank, we are driven by a single-minded and unwavering mission: to serve business and the individuals who run them. We use a consultative approach and innovative technologies to develop new ideas that give the bank and our clients a competitive advantage. We partner with our customers to push the boundaries of what is possible—together.

Headquartered in Dallas, Texas Capital Bank has offices in Austin, Fort Worth, Houston, Richardson, Plano and San Antonio, and we serve clients in a variety of industries from coast-to-coast.

We are on the Forbes Best Banks in America list and were named a top place to work by The Dallas Morning News, Houston Chronicle and San Antonio Express-News. For further information, please visit us at www.texascapitalbank.com.

• Partner with business stakeholders and senior Engineers to gather requirements and translate them into technical specifications and process documentation for IT counterparts (onshore and offshore)
• Skilled experience in writing and troubleshooting Python/PySpark scripts to generate extracts, cleanse, conform and deliver data for consumption
• Expert level of understanding and implementing ETL architecture; data profiling, process flow, metric logging, and error handling
• Support continuous improvement by investigating and presenting alternatives to processes and technologies to an architectural review board
• Develop and ensure adherence to published system architectural decisions and development standards
• Multi-task across several ongoing projects and daily duties of varying priorities as required
• Interact with global technical teams to communicate business requirements and collaboratively build data solutions

Education

Bachelor’s degree in computer science or MIS related area required or equivalent experience (industry experience substitutable)

Job experience

• 2-5 years of total experience in data engineering/Cloud development activity.
• 1+ years of experience in Banking and financial domain

Technical Requirement

• Must be cognizant in Data Warehouse ETL Design/Architecture, dimensional/relational data modelling.
• Experience in atleast one ETL development project, writing/analyzing complex stored procedures.
• Should have entry level/intermediate experience in Python/PySpark – working knowledge on spark/pandas dataframe, spark multi-threading, exception handling, familiarity with different boto3 libraries, data transformation and ingestion methods, ability to write UDF.
• Snowflake – Familiarity with stages and external tables, commands in snowflake like copy, unload data to/from S3, working knowledge of variant data type, flattening nested structure thru SQL, familiarity with marketplace integrations, role-based masking, pipes, data cloning, logs, user and role management is nice to have.
• Familiarity with Coalesce is an added advantage for this job
• Collibra integration experience for Data Quality and Governance in ETL pipeline development is nice to have.
• AWS – Should have hands-on experience with S3, Glue (jobs, triggers, workflow, catalog, connectors, crawlers), CloudWatch, RDS and secrets manager.
• AWS - VPC, IAM, Lambda, SNS, SQS, MWAA and Athena is nice to have.

• Should have hands-on experience with version controlling tools like github, working knowledge on configuring, setting up CI/CD pipelines using yaml, pip files.
• Streaming Services – Familiarity with Confluent Kafka or spark streaming or Kinesis (or equivalent) is nice to have.
• Data Vault 2.0 (hubs satellite links) experience will be a

Interpersonal

• Highly proficient in Publisher, PowerPoint, SharePoint, Visio, Confluence and Azure DevOps
• Working knowledge of best practices in value-driven development (requirements management, prototyping, hypothesis-driven development, usability testing)
• Good communicator with problem solving mindset and focus on process improvement
• Consistently demonstrates clear and concise written and verbal communication skills
• Good interpersonal skills, ability to interact with Senior Management
• Highly self-motivated with a strong sense of initiative

• Excellent multitasking skills and task management strategies

• Ability to work well in a team environment, meet deadlines, demonstrate good time management, and multi-task in a fast-paced project environment.