Data Modeler

Texas Capital Bancshares Inc

Richardson, TX

JOB DETAILS
SKILLS
Agile Programming Methodologies, Analysis Skills, Artificial Intelligence (AI), Banking Services, Best Practices, Borland ObjectWindows Library (OWL) Programming Libraries, Business Analysis, Business Model, Business Writing, Communication Skills, Computer Science, Cross-Functional, Data Analysis, Data Lake, Data Mart, Data Modeling, Data Profiling, Data Quality, Database Administration, Database Architecture, Database Design, Database Extract Transform and Load (ETL), DevOps, Dimensional Modeling, Documentation Models, Enterprise Architecture, Establish Priorities, Finance, Internet Technology, Kanban, Management Strategy, Management of Information Systems/Technology (MIS), Market Development, Mathematics, Metadata, Microsoft Excel, Microsoft Office, Model Review, Multitasking, Needs Assessment, Ontology, Organizational Skills, Problem Solving Skills, Process Improvement, RDF (Resource Description Framework), Reporting Skills, Requirements Management, SPARQL, SQL (Structured Query Language), Scrum Project Management and Software Development, Semantic Reasoner, Snowflake Schema, Software Development Lifecycle (SDLC), Statistics, Taxonomies, Team Player, Time Management, Writing Skills
LOCATION
Richardson, TX
POSTED
30+ days ago

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

• Solid understanding of relational, dimensional data modeling, Data Vault Modeling and ER-Modeling • Understand business needs and translate them into effective data models (conceptual, logical, and physical), considering data relationships and constraints • Design and maintain ontologies, taxonomies, and semantic models for enterprise data domains - Utilize ontology management tools (e.g., Protégé, TopBraid, RDF/OWL editors) and semantic web technologies (SPARQL, RDF, OWL) • Work closely with data architects, database administrators, data analysts, and business stakeholders to align data models with overall enterprise data architecture, strategy and roadmap • Analyzing and translating business needs into long-term solution data models. Consider Exact, Transform and Load (ETL) and Reporting challenges in designing data models • Support AI/ML enablement by providing structured semantic frameworks for knowledge graphs and reasoning engines • Analyze structural requirements for new datamarts and presentation/semantic layers • Evaluate existing data systems and reviewing modifications of existing systems for cross-compatibility • Interpret data, analyze results using statistical techniques and provide ongoing reports • Review the data model with both technical and business audiences as well as Data Governance • Develop best practices for data coding to ensure consistency within the system • Excellent communication skills with the ability to facilitate interaction between developers, analysts, and business users • Conduct moderately complex data profiling and analysis to evaluate data sources to determine the best source for business information • Extensive knowledge of/experience with data integration, data quality, multi-dimensional design, and ETL tools, processes, and methodology • Adhere to established data governance standards and best practices for data modeling • Document, maintain and optimize metadata related to data models, including data definitions and usage guidelines • Work with management to prioritize business and information needs

Qualifications

Bachelors degree or equivalent in Math, Computer Science, or MIS related area required.

Minimum 5 years demonstrated experience with engineering, building, and/or designing data models

Minimum 2 years in Banking and Finance domain preferred

Ability to design and implement Lob and/or enterprise Data Domains using Snowflake and using a Data Lake, Data Vault and ELT approach

Proven analytic skills, including mining, evaluation, analysis, and visualization

Strong SQL or Excel skills with the ability to learn other analytic tools

Prior experience with database and model design and segmentation techniques

Excellent understand of the SDLC process and familiar with the various Agile delivery methods (Scrum, Kanban, DevOps)

Ability to design, integrate complex data ingestions and implement data solutions to deliver results for an Enterprise Data Program

Demonstrated application of skills and knowledge across various business domains and technologies

Ability to obtain, analyze and synthesize information from multiple sources

Proven success in a collaborative, team-oriented environment

Strong consultative skills at a cross-functional level

Ability to participate in working groups and collaborate with Product | Domain Owners, Ops teams and a working group of technology SMEs

Good communicator with problem solving mindset and focus on process improvement

Effective time management skills and a proven track record of meeting various deadlines

Good interpersonal skills, ability to interact with Senior Management

Highly self-motivated with a strong sense of initiative

Excellent multitasking skills, task management strategies, organizational and analytical abilities

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

Ability to manage competing priorities on concurrent large, complex projects, initiatives, and deliverables

Strong formal business writing skills

Strong technical proficiency in the use of MS Office products for reporting, analytics, and presentations.

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.

About the Company

T

Texas Capital Bancshares Inc