Senior Data Solutions Engineer

US-TX-Richardson Operations Center
ID
2017-3077
2350 Lakeside Blvd
Category
Information Technology

Overview

At Texas Capital Bank, we are driven by a single-minded and unwavering mission: to serve business and the individuals who run them. We use a consultative approach and innovative technologies to develop new ideas that give the bank and our clients a competitive advantage. We partner with our customers to push the boundaries of what’s possible—together.

Headquartered in Dallas, Texas Capital Bank has offices in Austin, Fort Worth, Houston, Richardson, Plano and San Antonio, and we serve clients in a variety of industries from coast-to-coast.

We are on the Forbes Best Banks in America list, and were named a top place to work by The Dallas Morning News, Houston Chronicle and San Antonio Express-News. For further information, please visit us at www.texascapitalbank.com.

Position Summary

Reporting to the Vice President of Data Management, the Senior Data Solution Engineer acts as the subject matter expert in the area of data architecture with the Data Management team.  Specifically, this role will support data modeling, data integration and data consumption of Texas Capital Bank’s Enterprise Data Strategy.

 

This role requires a willingness to evaluate and learn new tools and technologies. The Senior Data Solution Engineer must possess a collaborative attitude, strong oral/written presentation skills, excellent problem solving skills and solid analytical/critical thinking skills.

Responsibilities

  • Position functions as a thought leader with the Data Management Team in the areas of data modeling, data access, data quality, data integration, data analytics, data visualization, data discovery, and database design/implementation
  • Develop and maintain enterprise data development and architectural standards/policies in support of TCB’s data strategy following data management best practices
  • Liaison between vendors and service providers selecting products or services that best meet data strategy goals in conjunction with the enterprise architecture team, IT management, and other internal stakeholders
  • Partner with TCB’s data governance team to ensure implementations meet enterprise data requirements and quality standards
  • Partner with TCB’s information security and privacy teams to ensure implementations meet internal policies and external regulations
  • Work closely with Data Management team to monitor and execute development and architectural standards including data models and data integration solutions (ETL)
  • Foster and execute industry best practices for advanced analytic/business intelligence implementations, such as SSAS tabular/multidimensional models and Azure Analysis Services
  • Ensure TCB’s data strategy links to other architecture models and reference architectures
  • Ensure technical metadata and data dictionaries are properly managed and correlated with business metadata and glossaries
  • Ensures TCB’s master data is properly integrated into the data platform and distributed appropriately to consumers

Qualifications

  • Bachelor’s degree in Computer Science or MIS related area and/or 10+ years of experience designing solutions for large scale data warehouses in both on premise and cloud environments; Financial services experience preferred
  • Certifications in Microsoft SQL Server and Azure preferred
  • Proven technical production environment experience including:
    • Required
      • Database: SQL Server 2008R2/2012/2014/2016, including T-SQL, SSIS, SSRS and SSAS
      • TFS, Team Services, or similar source control and work tracking systems
    • Preferred
      • Microsoft Azure: HDInsight, SQL, Data Warehouse, Data Lake, Analysis Services, Machine Learning, other Big Data tools (Hive, U-SQL, Spark, Pig), and Azure storage
    • Required
      • Data modeling tools such as ER/Studio or ERWin
    • Preferred:
      • Business intelligence/analytics tools such as Power BI, Tableau, and Alteryx
  • Strong data warehouse experience including:
    • Solid hands on experience with data modeling principles, methods, and techniques for data consolidation and processing optimization
    • Deep understanding of data integration methods and database design principles
    • Data management, quality, governance, and security
    • Methodologies such as Kimball and Inmon
  • Experience in a complex environment required including:
    • Master Data Management inclusive of knowledge of how to develop information taxonomies
    • Metadata management and associated processes required
  • Strong discipline in full life cycle development required
  • General knowledge of or exposure to privacy/regulatory/compliance in a highly-regulated environment
  • Knowledge of different software development methodologies desired (e.g. Agile, Waterfall)
  • Ability to present ideas in user-friendly language
  • Ability to obtain, analyze and synthesize information from multiple sources

 

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Connect With Us!

Don’t see the perfect opportunity? Connect with us and we will reach out if a new job opening matches your background and interests.