Data Analyst Master

Posted 8 Days Ago
Northeast Dallas, TX
7+ Years Experience
Fintech
The Role
As a Data Analyst Master, you will conduct complex data profiling, collaborate with data engineers, and validate solutions to create actionable insights. You will utilize SQL and programming in Python and VBA, implement ETL architecture, and manage multiple projects while documenting processes for team understanding.
Summary Generated by Built In

 

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 8 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. 

Top Skills

Python
R
SQL
VBA
The Company
HQ: Dallas, TX
2,100 Employees
On-site Workplace
Year Founded: 1998

What We Do

Our expert bankers are committed to helping your business build and grow. Equipped with experience-based insights and a proven record of implementing custom solutions for clients, we can help you with a suite of business lending, investing and financial management services that see you through every step of the way.

Our client-centric culture thrives because we attract, develop and engage the most experienced and diverse experts in their fields. Over the years, we've developed a supportive culture that values collaboration, rewards performance and respects the well-being of its team members. We know our people are our greatest asset, so we give them the resources and support they need to be successful. Our personal approach has enabled us to deliver exceptional value for our clients for more than two decades — an achievement we’re proud to continue.

Explore a career at Texas Capital Bank: https://www.texascapitalbank.com/who-we-are/careers

Texas Capital Bank is a wholly owned subsidiary of Texas Capital Bancshares, Inc. (NASDAQ®: TCBI). For more information, please visit www.texascapitalbank.com. Member FDIC. NASDAQ®: TCBI. Equal Housing Lender.

Texas Capital Bank and its subsidiaries are equal opportunity employers and do not discriminate on the basis of any protected trait including sex, sexual orientation, gender identity, race, ethnicity, disability, or veteran status. Please view our EEO Policy to learn more: https://www.texascapitalbank.com/equal-employment-opportunity-policy

Jobs at Similar Companies

MassMutual India Logo MassMutual India

Associate, Technology Operations

Big Data • Fintech • Information Technology • Insurance • Financial Services
Hyderabad, Telangana, IND

MyBambu Logo MyBambu

Training, Onboarding, and Development Specialist

Fintech • Mobile • Other • Payments • Social Impact • Financial Services • App development
West Palm Beach, FL, USA
120 Employees

Bectran, Inc Logo Bectran, Inc

UX/UI Designer

Artificial Intelligence • Fintech • Information Technology • Machine Learning • Software • Automation
Schaumburg, IL, USA
51 Employees

Similar Companies Hiring

MyBambu Thumbnail
Social Impact • Payments • Other • Mobile • Fintech • Financial Services • App development
West Palm Beach, Florida
120 Employees
Bectran, Inc Thumbnail
Software • Machine Learning • Information Technology • Fintech • Automation • Artificial Intelligence
Schaumburg, IL
51 Employees
MassMutual India Thumbnail
Insurance • Information Technology • Fintech • Financial Services • Big Data
Hyderabad, Telangana

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account