About the position
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. We are looking for a highly technical and hands-on Business Intelligence (BI) Developer to design and maintain domain-oriented data marts within our enterprise data warehouse. This role is critical to enabling self-service BI, advanced analytics, and AI/ML use cases across the organization. You will work on complex data challenges, collaborate with cross-functional teams, and play a key role in shaping the future of data and analytics at the bank. This is an exciting opportunity to combine your technical expertise and business acumen to impact decision-making across the organization.
Responsibilities
- Partner closely with data engineers to design and maintain dimensional data models (e.g., star schema, snowflake schema) in the presentation layer, tailoring datasets to support BI and advanced analytics
- Develop and implement robust data transformations using SQL and tools like Coalesce to deliver modular and scalable data marts optimized for self-service, reporting, and analytics
- Develop efficient, reliable ETL/ELT workflows in Snowflake to automate data ingestion, transformation, and delivery for analytical use cases
- Advocate for and help implement modern practices like data observability, CI/CD for data pipelines, and testing frameworks to enhance the reliability of analytics solutions, including automated data validation checks
- Contribute to the development and enhancement of dashboards and reports for critical use cases
- Partner with data engineers to diagnose and resolve issues related to data pipelines, ETL/ELT processes, and data mart performance
- Maintain thorough technical documentation for data pipelines, transformation logic, and data mart designs
- Use version control systems (e.g., Git) to track changes and ensure consistency across deployments
- Contribute to advanced analytics initiatives by preparing domain-oriented datasets and/or feature stores for AI/ML, predictive modeling, and other use cases
- Embed outputs from analytics models into BI dashboards or other operational reporting workflows
- Actively participate in team knowledge-sharing sessions, code reviews, and retrospectives to foster a collaborative and high-performing engineering culture
Requirements
- Bachelor's degree in Computer Science, Data Science, Data Engineering, Information Systems, Mathematics, or a related field (Master's preferred)
- Minimum of 7 years of experience in analytics engineering, data engineering, or a related technical field
- Strong understanding of data warehouse concepts and modern enterprise data architectures
- Advanced SQL skills with the ability to write, optimize, and troubleshoot complex queries in Snowflake. Familiarity with Snowflake-specific features, such as time travel, zero-copy cloning, data sharing, and materialized views, is preferred
- Hands-on experience with Coalesce, dbt, or similar tools for managing robust SQL-based transformations and creating reusable, modular data models
- Familiarity with building, scheduling, and monitoring ETL/ELT workflows using tools like Airflow, or similar orchestration platforms
- Strong understanding of dimensional modeling concepts (e.g., star schema, snowflake schema) and their application to scalable and user-friendly data marts; knowledge of Data Vault 2.0 is a plus
- Strong proficiency in Power BI for building and validating dashboards, and optimizing datasets and/or queries for reporting
- Proficiency in Python for scripting and automation is highly preferred
- Experience implementing data validation checks and quality assurance processes to ensure the accuracy, reliability, and consistency of datasets
- Experience integrating predictive model outputs into analytics workflows and/or BI solutions is preferred
- Strong knowledge of data governance principles and tooling; experience with Collibra is a plus
- Strong problem-solving skills and ability to debug complex workflows and/or pipelines
- Excellent communication skills and ability to translate technical information to a non-technical audience
- Ability to manage competing priorities on complex projects, initiatives, and deliverables
- Experience working in Agile or Scrum environments
- Familiarity with version control systems like Git and experience using collaboration tools such as Jira, Confluence, or Azure DevOps
Benefits
- 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
- Paid time off (PTO)
