Business Intelligence Developer

Brief Overview of Position

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

Qualifications

• 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

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.