Skip to content
TriState Capital Bank
  • Our People
  • Lending
    • Our Lending Solutions
      • Commercial Real Estate
      • Equipment Finance
      • Financial Advisor Solutions
      • Fund Finance
      • Insurance-Based Lending
      • Middle Market Solutions
      • Securities-Based Lending
  • Liquidity Solutions
    • Our Liquidity Solutions
      • Family Offices
      • Financial Institutions
      • Treasury Management
  • About
    • Our Story
    • Management Team
    • Board of Directors
    • Investor Relations
  • Careers
  • Contact Us
What can we help you find?
Login
Select a service for login
  • Our People
  • Lending
    • Commercial Real Estate
    • Equipment Finance
    • Financial Advisor Solutions
    • Fund Finance
    • Insurance-Based Lending
    • Middle Market Solutions
    • Securities-Based Lending
  • Liquidity Solutions
    • Family Offices
    • Financial Institutions
    • Treasury Management
  • About
    • Our Story
    • Management Team
    • Board of Directors
    • Investor Relations
  • Careers
  • Contact Us
  • Logins
    • Financial Advisors – Digital Lending Platform
    • Personal Banking – Loan & Deposit Clients
    • Treasury Management – AdvantageTSC Direct
    • Treasury Management – Escrow Services
    • eStatements (only)

You are about to leave the TriState Capital Bank website.

By clicking CONTINUE, you’ll be leaving the TriState Capital Bank website and be directed to a third-party site. If you’d like to return to the previous page,  just click CANCEL.

Note: If you are accessing your deposit statement via this link DO NOT use your TSC Online Banking user name and password. You will need to create a new user ID and password that will be specific to eStatements. (If you have online banking access, you can always log on directly through online banking via the homepage to also obtain your eStatements.)

Reach out with questions anytime, Monday through Friday, 8am to 5pm ET at 1-866-680-8722, option 2, or email us directly at [email protected].

Continue

Data Architect

Department: Information Technology

Location: Pittsburgh, PA

Job Title: Data Architect

Department: Information Technology

Location:         Pittsburgh, PA

 

Summary of the Position:

The Data Architect will leverage their business and expert technical knowledge to act as Lead Architect on major data programs and Enterprise Data initiatives. The Data Architect will develop production ready data models by integrating multiple sources of data while also working with business and technical teams to understand business strategy and objectives, gather information, and ensure business requirements are being fulfilled throughout the entire data & analytics lifecycle.

Primary Functions of the Position:

  • Drives project knowledge back to the enterprise data model and ensures that it evolves correctly
  • Leads the design, development, implementation and maintenance of complex data systems and solutions
  • Develops conceptual, logical, and physical data models to support data analysis and business intelligence
  • Creates and maintains current- and target-state data architectures
  • Defines and manages standards, guidelines, and processes to ensure data quality
  • Ensures technology solutions are in alignment with data architecture principles and target state
  • Oversees end-to-end data life cycle management activities
  • Works with IT teams, business analysts and data analytics teams to understand data consumers’ needs and develop solutions
  • Evaluates and recommends emerging technologies for data management, storage, and analytics
  • Collects and understands business requirements and translate those requirements into an actionable data warehouse plan.
  • Utilizes knowledge of multi-dimensional and tabular design patterns and identifies solutions that leverage these modeling techniques.
  • Works within the SDLC framework in multiple environments and understands the complexities and dependencies of the data warehouse build within those constraints.
  • Leads the data design of solutions for large projects and programs; through expert knowledge translates high-level business requirements into data models and appropriate metadata, test data, and data quality standards
  • Directs and controls large specialist teams to undertake the delivery of a comprehensive data-centric project
  • Manages senior business stakeholders to secure strong engagement for the solution and ensure that the delivery of the project aligns to longer-term strategic roadmaps
  • Works closely with external suppliers to ensure the solution makes best use of technology and meets requirements
  • Simplifies the existing data architecture, delivering reusable services and cost saving opportunities in line with the policies and standards of the group
  • Responsible throughout the entire project lifecycle for the end-to-end solution of the project and compliance with enterprise data model and logical data groups
  • Provides clear, continuous, and consistent data architecture leadership at a detailed level within the project

Education and Experience Requirements:

  • Bachelor’s degree in Computer Science, Engineering or related field
  • 5+ years of experience in data warehousing, data modeling and/or data analysis
  • 5+ years of experience in BI/Data Warehousing
  • 5+ years of experience with data pipelines and architecture/engineering. 5+ years of experience in SQL/ coding
  • Cloud based project implementation.
  • Experience with database technologies (e.g., SQL, NoSQL, Oracle, Hadoop, Teradata)
  • SnowflakeDB experience a plus.
  • Experience in banking and/or financial services would be highly beneficial

Essential Skills and Abilities:

  • Good knowledge of data management, data integration, and database development techniques
  • Ability to relate architectural decisions and recommendations to business needs
  • Ability to regularly learn and adopt new technology
  • Strong analytical and problem-solving skills
  • Ability to communicate across all levels of the organization and work with diverse projects teams
  • Able to respond, when needed, 24/7 if system issues arise
  • Effectively work in a highly dynamic and fast-paced environment
  • Strong organizational skills
  • Troubleshoot issues quickly and provide fixes in a timely manner
  • Adapt quickly to changing priorities and manage multiple deadlines

TriState Capital Bank provides equal employment opportunity and advance in employment to qualified persons regardless of race, color, sex, religion, national origin, age, sexual orientation, gender identity, disability, veteran status, or other categories protected by law.

TriState Capital Bank is an Equal Opportunity Employer.

APPLY NOW

TriState Capital Bank provides equal employment opportunity and advance in employment to qualified persons regardless of race, color, sex, religion, national origin, age, sexual orientation, gender identity, disability, veteran status, or other categories protected by law.

TriState Capital Bank is an Equal Opportunity Employer.

About TSC
  • Careers
  • Resources
  • Investor Relations
  • News & Media
  • Media Relations
  • The TSC Advantage
Security, Terms & Legal
  • Privacy & Security
  • Education Center
  • Fraud Prevention Center
TriState Capital Bank
Member FDIC Equal Housing Lender

© 2022 TriState Capital Bank. All Rights Reserved.

You are about to leave the TriState Capital Bank website.

By clicking CONTINUE, you’ll be directed to investors.tristatecapitalbank.com. If you’d like to return to the previous page, just click CANCEL.
A quick note: If you’re accessing your deposit statement through this link, don’t use your TSC Online Banking username and password. You’ll need to create a new user ID and password that will be specific to eStatements. (If you have online banking access, you can also log in directly through online banking from the homepage to obtain your eStatements.) Reach out with questions anytime, Monday through Friday, 8am to 5pm ET at 1-866-680-8722, option 2, or email us directly at [email protected].
Continue

You are about to visit Chartwell Investment Partners website.

By clicking CONTINUE, you’ll be leaving the TriState Capital Bank website and be directed to chartwellip.com. If you’d like to return to the previous page, just click CANCEL.
A quick note: If you’re accessing your deposit statement through this link, don’t use your TSC Online Banking username and password. You’ll need to create a new user ID and password that will be specific to eStatements. (If you have online banking access, you can also log in directly through online banking from the homepage to obtain your eStatements.) Reach out with questions anytime, Monday through Friday, 8am to 5pm ET at 1-866-680-8722, option 2, or email us directly at [email protected].
Continue