Data Analyst

About Texascapitalbank

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.

Job Summary

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

Key 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.
• Work 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.

Required Qualifications

• Bachelor’s degree or equivalent in Computer Science, Information Systems, Technology, or related field.
• 3 years in Data/Business Analyst/QA field.
• Knowledge of business process maps, SQL queries, reports, and presentations.
• Knowledge of database and data segmentation techniques.
• Knowledge of best practices in value-driven development (requirements management).