Senior Data Engineer

Capital Bank MD; Rockville (MD); Remote; USD 115,000 - 141,000; Full time

Job summary

An established industry player is seeking a skilled Data Engineer to join their team. This role involves designing and optimizing ETL processes and database solutions, focusing on cloud-based technologies. You will create scalable data pipelines and ensure seamless integration with enterprise systems, enabling insightful analytics through advanced visualization tools. Join a company recognized for its supportive culture and commitment to employee growth, where your contributions will directly impact the financial journeys of clients. If you're passionate about data and innovation, this opportunity is perfect for you!

Benefits

Comprehensive benefits package

Paid Parental Leave

Employee Recognition Program

Tuition Reimbursement Program

Generous Paid Time Off

Company Contributions to 401k

Paid Charity Hours

Qualifications

• 6+ years of experience in data engineering and ETL.
• Expertise in cloud-based database platforms like Azure SQL.
• Strong communication skills for collaboration across teams.

Responsibilities

• Manage and optimize ETL and database solutions for the Bank.
• Design and implement cloud-based database systems.
• Integrate data visualization tools for actionable insights.

Skills

ETL Solutions

Database Management

Cloud-based Databases

Data Visualization

SQL

Data Quality Management

Data Lake Development

Data Warehouse Development

Data Transfer Management

Collaboration Skills

Education

Bachelor's Degree in Computer Science

6+ years of Data Engineering Experience

Tools

Azure SQL

Power BI

Apache Kafka

Apache Spark

Talend

Informatica

GitLab

Azure DevOps

Airflow

Azure Data Factory

Job description

Description

About Us

Capital Bank N.A. is headquartered in Maryland and has been serving our communities since 1999. We stand as a publicly traded company (NASDAQ: CBNK) with over $3 billion in assets. We offer commercial and consumer banking services to clients in Maryland, DC, and Northern Virginia, alongside two nation-wide lending brands; Capital Bank Home Loans and OpenSky, a credit card division that offers and services credit cards across all states. Our personalized approach to banking, paired with cutting-edge technology solutions and a comprehensive suite of products and services, fuels our growth, and enables us to support our customers at every stage in their financial journey.

Come join a bank where our employees thrive and are engaged in meaningful work. For the last 5 out of 6 years, Capital Bank was named one of the "Best Banks to Work For" in the U.S. by American Banker.

Position Purpose

The Data Engineer will act as a subject matter expert (SME) and be responsible for managing, designing, and optimizing Extract Load Transform (ETL) and Database (DB) solutions for the entire Bank. This role involves creating scalable, secure, and high-performance ETL and data pipelines, database architectures, ensuring seamless integration with enterprise systems, and maintaining reliability. The Senior Data Engineer will focus on cloud-based solutions, data lake and data warehouse development, efficient management of data transfer and file processes, and enabling business insights through advanced data visualization tools.

Position Responsibilities

• Serve as the SME for ETL solutions and DB, collaborating with business stakeholders and IT teams to define requirements, gather data, and implement optimized database solutions.


• Design, implement, and maintain cloud-based database systems in Azure SQL to ensure data scalability and accessibility.


• Implement and manage data lakes and data warehouses, creating pipelines and data models to enable efficient analytics and reporting.


• Establish and document strategies for managing data transfer processes, including secure file transfers (SFTP), batch data processing, and real-time streaming.


• Build and optimize ETL pipelines for data extraction, transformation, and loading into operational databases or analytical platforms.


• Integrate and support data visualization tools such as Power BI, Sisense, Google Looker, Tableau, or similar platforms to enable actionable insights for business stakeholders.


• Develop and maintain optimized data models for dashboards and reporting, ensuring compatibility with visualization tools.


• Plan, coordinate, and implement database migrations, upgrades, and patches with minimal downtime.


• Define and enforce database governance policies, including data integrity, security, and compliance with regulatory requirements.


• Analyze and resolve database performance issues by optimizing queries, indexes, and schema designs.


• Partner with vendors to evaluate, select, and implement database tools, services, and technologies; stay informed about product roadmaps and industry trends.


• Develop disaster recovery and high-availability solutions, including replication, clustering, and failover.

Minimum Education & Experience Required

• 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.

Technical Skills and Qualifications

• 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.

Working Arrangements

• Open to 100% remote candidates.

Compensation:

• Base Salary Range: $115,214 - $140,817 annually. Final determination of where you are at in the salary range is based on numerous factors such as relevant experience, skill set, education, and ability to meet qualifications within the job description.


• Additional Compensation: This role will include a yearly annual target bonus based on individual performance.

Why Join Us?

• Join a growing company with a culture that fosters an entrepreneurial spirit


• 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

Supporting Businesses. Helping People. Strengthening Communities.
Capital Bank, N.A. is an Affirmative Action, E-Verify, and Equal Opportunity Employer.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

This employer is required to notify all applicants of their rights pursuant to federal employment laws.
For further information, please review the Know Your Rights notice from the Department of Labor.