Data Analyst Master
Texas Capital Bank
Texas Capital is built to help businesses and their leaders. Our depth of knowledge and expertise allows us to bring the best of the big firms at a scale that works for our clients, with highly experienced bankers who truly invest in people’s success — today and tomorrow.
While we are rooted in core financial products, we are differentiated by our approach. Our bankers are seasoned financial experts who possess deep experience across a multitude of industries. Equally important, they bring commitment — investing the time and resources to understand our clients’ immediate needs, identify market opportunities and meet long-term objectives. At Texas Capital, we do more than build business success. We build long-lasting relationships.
Texas Capital provides a variety of benefits to colleagues, including health insurance coverage, wellness program, fertility and family building aids, life and disability insurance, retirement savings plans with a generous 401K match, paid leave programs, paid holidays, and paid time off (PTO).
Headquartered in Dallas with offices in Austin, Fort Worth, Houston, Richardson, Plano and San Antonio, Texas Capital was recently named Best Regional Bank in 2024 by Bankrate and was named to The Dallas Morning News’ Dallas-Fort Worth metroplex Top Workplaces 2023 and GoBankingRate’s 2023 list of Best Regional Banks. For more information about joining our team, please visit us at www.texascapitalbank.com.
Responsibilities
Conduct moderately complex data profiling and analysis to evaluate data sources to determine the best source for business information
Collaborate with data engineers to perform data validation and testing activities as appropriate
Works directly with internal customers to refine requirements and validate output to ensure solutions will meet expectations and deliver actionable insights through data analysis
Advanced database knowledge; creating/optimizing SQL queries, stored procedures, functions, partitioning data, indexing, and reading execution plans
Utilize programming languages such as Python and VBA for data manipulation and analysis tasks
Participate in project management activities using Agile methodologies to ensure timely delivery of projects
Expert level of understanding and implementing ETL architecture; data profiling, process flow, metric logging, and error handling
Document processes, workflows, and system designs using Visio to facilitate understanding across teams.
Multi-task across several ongoing projects and daily duties of varying priorities as required
Qualifications
Minimum of 7 years of total experience in Data Analysis field.
Experience in Banking and financial domain preferred.
Proficient in analytics programming languages (SQL/R/Python) and automation tasks is essential
Demonstrated understanding of data profiling, statistical analysis and data modeling concepts
Proficient in extracting and leveraging data out of data warehouse, transactional databases, object stores & API based environments
Demonstrated ability to translate business needs into technical solutions
Ability to embrace change, adapt to the unexpected, and focus energies, people, and solutions on practical and positive results
Demonstrated problem solving skills
Strong communications skills with the ability to influence others using data and logic
Ability to effectively mentor others
Aptitude and drive to learn new technologies and analysis techniques
Strong team player; able to work effectively within a team and more broadly with people from a variety of backgrounds and areas across the organization.
Must be extremely proficient in Data Warehouse ETL Design/Architecture, dimensional/relational data modelling.
Prior experience with database and model design and segmentation techniques
Data warehouse experience with knowledge of SQL and the ability to query cloud relational databases like Snowflake or Redshift is a MUST.
Familiarity with Coalesce/dbt is an added advantage for this job.
Data Vault 2.0 (hubs satellite links) experience will be a PLUS.
The duties listed above are the essential functions, or fundamental duties within the job classification. The essential functions of individual positions within the classification may differ. Texas Capital Bank may assign reasonably related additional duties to individual employees consistent with standard departmental policy.Texas Capital is an Equal Opportunity Employer.