[Remote] Senior Data Engineer

Note: The job is a remote job and is open to candidates in USA. Capital Bank, N.A. is a publicly traded company that has been serving communities since 1999, offering commercial and consumer banking services. They are seeking a Senior Data Engineer to manage and optimize enterprise data pipelines and database solutions, ensuring high-performance data platforms and strong data governance across various business lines.ResponsibilitiesServe as the expert for ETL and DB solutions, collaborating with business stakeholders and IT teams to define requirements, gather data, and implement optimized data solutionsDesign, implement, and maintain data systems in Snowflake to ensure data scalability and accessibilityImplement and manage data lakes and data warehouses, creating pipelines and data models to enable efficient analytics and reportingEstablish and document strategies for managing data transfer processes, including secure file transfers (SFTP), batch data processing, and real-time streamingBuild and optimize ETL pipelines for data extraction, transformation, and loading into operational databases or analytical platformsIntegrate and support data visualization tools such as Power BI, Sisense, Google Looker, Tableau, or similar platforms to enable actionable insights for business stakeholdersDevelop and maintain optimized data models for dashboards and reporting, ensuring compatibility with visualization toolsPlan, coordinate, and implement database migrations, upgrades, and patches with minimal downtimeDefine and enforce database governance policies, including data integrity, security, and compliance with regulatory requirementsAnalyze and resolve database performance issues by optimizing queries, indexes, and schema designsPartner with vendors to evaluate, select, and implement database tools, services, and technologies; stay informed about product roadmaps and industry trendsDevelop disaster recovery and high-availability solutions, including replication, clustering, and failoverSkillsBachelor's degree or higher in Computer Science, Information Systems, or a related field6+ years of experience in data engineering, ETL, database management with experience in cloud-based databases and financial services preferredExperience in Database Administration (DBA), managing and optimizing databases for performance and security3+ years of experience designing and building data lakes and data warehouses using platforms like Azure Fabrik, Snowflake, Amazon Redshift, or Google BigQuery2+ years of experience using data visualization tools like Power BI, Sisense, Google Looker, Tableau, or similar platformsExperience with managing data transfers and file processes, including SFTP, secure data pipelines, and real-time or batch data movementExperience in proactively identifying, addressing, and monitoring data quality issues, adhering to established data quality standardsExcellent communication skills and the ability to collaborate effectively across teams and stakeholders, explain technical concepts to non-technical stakeholdersExpertise in cloud-based database platforms, such as Azure SQL, Amazon RDS, Google Cloud Spanner, and SnowflakeStrong knowledge of data lake and data warehouse architectures, including designing efficient schemas, partitioning strategies, and optimizing storageProficiency with data integration tools and technologies, such as Apache Kafka, Apache Spark, Talend, or InformaticaHands-on experience building and maintaining ETL pipelines to support large-scale data environmentsAdvanced SQL skills and familiarity with programming languages like Python or Java for data manipulation and automationExperience with data visualization platforms, including building and optimizing dashboards using Sisense, Power BI, Google Looker, Tableau, or similar toolsExperience 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 standardsAbility to manage data file transfers and processing workflows effectivelyExperience with database monitoring and performance tuning in cloud and hybrid environmentsPreferred experience in understanding data relationships, as well as developing and optimizing SQL queries, stored procedures, and database functions in both OLTP and OLAP systemsStrong organizational and problem-solving skills in Agile or fast-paced environmentsBenefitsYearly annual target bonus based on individual performanceComprehensive benefits package including Medical, Dental, Vision, Company Paid Life Insurance, Disability Insurance, and more?Company Contributions to your 401k - Regardless of your contributionEmployee 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 opportunitiesCompany OverviewCapital Bank N.A., headquartered in Rockville, Maryland is a Maryland chartered commercial bank that offers commercial and consumer banking services to clients in the Washington D.C. It was founded in 1998, and is headquartered in Rockville, Maryland, USA, with a workforce of 201-500 employees. Its website is http://www.capitalbankmd.com.