Senior Data Engineer

Role Description

As part of the Technology team, the Senior Data Engineer will act as a subject matter expert (SME) responsible for managing, designing, and optimizing enterprise data pipelines and database solutions that support all lines of business at Capital Bank, including our Commercial Bank, Consumer Card division, and Mortgage division. This role owns end-to-end delivery and operations across our primary technology stack (Azure, SQL Server, and Snowflake), ensuring scalable, secure, and high-performance data platforms, reliable integrations with enterprise systems, and strong data governance.

The Senior Data Engineer will build and optimize ETL/ELT processes, data lake and data warehouse solutions, and data transfer/file processing workflows to enable trusted analytics and reporting across the bank.

Qualifications

• Bachelor’s degree or higher in Computer Science, Information Systems, or a related field.
• 6+ years of experience in data engineering, ETL, database management with experience in cloud-based databases and financial services preferred.
• Experience in Database Administration (DBA), managing and optimizing databases for performance and security.
• 3+ years of experience designing and building data lakes and data warehouses using platforms like Azure Fabrik, Snowflake, Amazon Redshift, or Google BigQuery.
• 2+ years of experience using data visualization tools like Power BI, Sisense, Google Looker, Tableau, or similar platforms.
• Experience with managing data transfers and file processes, including SFTP, secure data pipelines, and real-time or batch data movement.
• Experience in proactively identifying, addressing, and monitoring data quality issues, adhering to established data quality standards.
• Excellent communication skills and the ability to collaborate effectively across teams and stakeholders, explain technical concepts to non-technical stakeholders.

Requirements

• Expertise in cloud-based database platforms, such as Azure SQL, Amazon RDS, Google Cloud Spanner, and Snowflake.
• Strong knowledge of data lake and data warehouse architectures, including designing efficient schemas, partitioning strategies, and optimizing storage.
• Proficiency with data integration tools and technologies, such as Apache Kafka, Apache Spark, Talend, or Informatica.
• Hands-on experience building and maintaining ETL pipelines to support large-scale data environments.
• Advanced SQL skills and familiarity with programming languages like Python or Java for data manipulation and automation.
• Experience with data visualization platforms, including building and optimizing dashboards using Sisense, Power BI, Google Looker, Tableau, or similar tools.
• Experience with CI/CD tools (e.g., GitLab, Azure DevOps, Jenkins) and data pipeline monitoring tools (e.g., Airflow, Apache NiFi, Azure Data Factory).
• Strong understanding of database security best practices, including encryption, access controls, and compliance with regulatory standards.
• Ability to manage data file transfers and processing workflows effectively.
• Experience with database monitoring and performance tuning in cloud and hybrid environments.
• Preferred experience in understanding data relationships, as well as developing and optimizing SQL queries, stored procedures, and database functions in both OLTP and OLAP systems.
• Strong organizational and problem-solving skills in Agile or fast-paced environments.

Benefits

• Base Salary Range: $115,000 - $130,000 annually.
• This role will include a yearly annual target bonus based on individual performance.
• This is a 100% remote role.
• Comprehensive benefits package including Medical, Dental, Vision, Company Paid Life Insurance, Disability Insurance, and more.
• Company Contributions to your 401k - Regardless of your contribution.
• Employee Perks: Paid Parental Leave, Employee Recognition Program, Leadership Program, Tuition Reimbursement Program, Employee Bank Checking Account, and much more!
• Generous Paid Time Off and Paid Holidays - Including Paid Charity Hours to support volunteer opportunities.