Data modeler [h1.location_city]

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

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.

Analyze structural requirements for new datamarts and presentation / semantic layers.

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

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