← Back to jobsJob ID col-cmv8ctjvf0377oz01lbl58jyr

Climate First BankPosted 30+ days ago

Data Engineer

Full-time
Remote
3+ years
Competitive
Posted 30+ days ago

Climate First Bank is a mission-driven, sustainability-focused commercial bank offering personal and business banking services. The Data Engineer designs, builds, maintains, and improves enterprise data pipelines, integrations, databases, and analytical data models across cloud, on-premises, and hybrid environments. The role owns data flow from source connectivity through ingestion, transformation, validation, storage, monitoring, and delivery to reporting and analytics consumers.

Posted
30+ Days Ago
Source
Ethic Leaf recruiter
Sector
Information Technology & AI

No employer link yet — an Ethic Leaf recruiter forwards your application

Responsibilities

  • Design, develop, operate, and improve end-to-end ETL and ELT pipelines from enterprise sources to business-ready datasets and analytical models
  • Own source connectivity, extraction, transformation, loading, validation, storage, monitoring, recovery, documentation, and operational support
  • Build maintainable solutions that meet defined business needs without unnecessary complexity; balance immediate delivery with a scalable foundation
  • Evaluate existing pipelines, rebuild unstable or obsolete processes, and select patterns based on business value, risk, cost, performance, security, and supportability
  • Integrate Microsoft SQL Server and other relational databases, ODBC sources, REST APIs, SaaS applications, secure file locations, shared datasets, CSV, JSON, Parquet, and other approved sources
  • Develop reusable ingestion patterns for authentication, pagination, rate limits, token renewal, retries, logging, exception handling, and schema changes
  • Support batch, incremental, snapshot, near-real-time, and streaming patterns when justified by business requirements
  • Maintain source-to-target mappings and document how source fields become standardized, validated, and usable information
  • Create complex SQL queries, views, stored procedures, functions, tables, keys, and transformation logic
  • Manage SQL Server from the database perspective, including schemas, objects, data structures, permissions coordination, backup requirements, troubleshooting, and performance
  • Design normalized structures and analytical models, including facts, dimensions, star schemas, data marts, and semantic-ready datasets
  • Optimize workloads through indexing, execution-plan analysis, partitioning, appropriate data types, incremental processing, and controlled historical retention
  • Build and maintain workflows using approved platforms such as Azure Data Factory, SQL Server, and other Bank-approved tools
  • Determine when to use full loads, incremental loads, watermarks, change tracking, snapshots, or event-driven patterns
  • Create parameterized pipelines with retries, checkpoints, idempotency, dependency controls, backfill procedures, and failure notifications
  • Design fault-tolerant processing so isolated data errors are captured and reported without unnecessarily stopping unrelated workloads
  • Embed automated checks for schema, data types, required fields, ranges, reference values, row counts, totals, balances, and completeness
  • Detect and handle duplicates, null values, malformed identifiers, invalid formats, latearriving records, schema drift, and incorrect aggregates
  • Reconcile transformed data against authoritative source systems, control totals, approved reports, and business rules
  • Prevent unverified data from reaching production reporting layers; maintain traceability for exceptions, remediation, and reprocessing
  • Build and support data solutions across Microsoft Azure, Google Cloud Platform, and on-premises environments as required by the Bank’s architecture
  • Securely move data between environments and coordinate on networking, integration runtimes, service accounts, secrets, access, and platform configuration
  • Improve execution time, query performance, freshness, reliability, and resource use through batching, parallelism, partitioning, workload management, and incremental processing
  • Assess storage, compute, movement, licensing, and duplication costs before changes; avoid unnecessary replication when secure direct-query or shared-data approaches are appropriate
  • Be capable of creating and working with Big Data solutions and products, such as BigQuery
  • Consolidate pipelines results on centralized data stores such as Datalakes and others
  • Deliver clean, documented, trustworthy, and appropriately modeled data to Power BI and other approved reporting platforms
  • Build reusable enterprise datasets and semantic-ready models; support relationships, field definitions, refresh requirements, and upstream performance troubleshooting
  • Partner with analysts and reporting teams while maintaining clear ownership boundaries between engineering, analytical modeling, and visualization development
  • Protect customer, financial, and operational information through least privilege, role-based access, encryption, approved secret management, logging, monitoring, and separation of duties
  • Maintain lineage, metadata, ownership, classification, retention, and access documentation; support audits, risk assessments, vendor reviews, and examinations
  • Ensure solutions align with Bank policies and applicable expectations, including GLBA, FFIEC, NIST, BSA, AML, CIP, and OFAC; escalate suspected control failures or unauthorized access
  • Monitor pipelines, integrations, databases, and delivery commitments; perform root-cause analysis and implement durable corrective actions
  • Maintain architecture and data-flow diagrams, entity relationships, dictionaries, pipeline inventories, transformation specifications, validation rules, runbooks, dependencies, and recovery procedures
  • Use approved shared repositories, version control, peer review, controlled releases, and change management for SQL, Python, pipeline assets, and documentation
  • Gather requirements and communicate scope, dependencies, risks, limitations, timelines, and recovery status clearly to technical teams, business users, executives, vendors, and auditors

Qualifications

  • The successful candidate must combine strong SQL, data integration, scripting, data quality, and troubleshooting skills with practical judgment and clear communication
  • Bachelor's degree in Computer Science, Information Systems, Data Engineering, Software Engineering, Mathematics, Finance, or a related field; equivalent practical experience may be considered
  • 3+ years of relevant experience in data engineering, database development, ETL/ELT development, analytics engineering, or a related discipline
  • Demonstrated ownership of production data pipelines from source ingestion through a final analytical model or business-ready dataset
  • Advanced SQL and T-SQL, including complex joins, transformations, window functions, stored procedures, query tuning, indexing, schema design, and incremental patterns
  • Demonstrated experience with CRM data streams (modeling and integration), like Salesforce and DataHub
  • Microsoft SQL Server experience from a database and data-engineering perspective
  • Hands-on experience with Azure Data Factory or a directly comparable enterprise orchestration platform
  • Proficiency in Python or an equivalent language for ingestion, transformation, validation, automation, and troubleshooting
  • Experience with APIs, file-based data, hybrid integration, analytical modeling, automated quality controls, monitoring, recovery, Git-based version control, and production support
  • Working knowledge of Power BI data models, relationships, refresh patterns, and upstream performance considerations; understanding of access control, encryption, logging, and auditability
  • We are unable to provide employment visa sponsorship now or in the future
  • You take charge of your work product and take pride in delivering consistently great and measurable results
  • You solve problems efficiently, seek operational efficiencies and are an analytical thinker with a strong focus on data-driven decision making
  • Whether it's in-person, on camera, phone, or chat — you communicate with confidence, precision, and professionalism
  • You listen deeply and respond thoughtfully and are able to engage efficiently and tactfully with stakeholders at all levels of the organization
  • Additionally, you masterfully build relationships and develop business with strong influencing and decision-making skills
  • You are highly educated in financial products and services, applicable regulations and laws
  • You also possess strong overall business acumen and the ability to interpret financial reports and legal documents
  • Strong knowledge of unique industries and markets in conjunction with a broad knowledge of business banking products and services is required
  • You learn new tools quickly, are excited by innovation and leverage technology to optimize your work product and streamline your creative process
  • You lift others up, share ideas, and bring positive energy to everything you do
  • You know what it takes to operate as a part of a larger team and cherish opportunities to contribute to the big picture
  • You're dependable, communicate clearly and always happy to lend a hand where needed

Preferred

  • Experience in banking, financial services, healthcare, insurance, or another regulated industry is preferred
  • Experience with core systems migrations, data-platform modernization, reporting conversions, or foundational data-environment buildouts is preferred
  • Banking Industry Experience
  • Financial Services Experience
  • Healthcare Industry Experience
  • Insurance Industry Experience
  • Regulated Industry Experience

Required skills

Advanced SQL and T-SQLMicrosoft SQL ServerETL/ELT DevelopmentAzure Data FactoryPythonCRM Data IntegrationSalesforceDataHubAPI IntegrationAnalytical Data ModelingData Quality and ValidationPower BI Data ModelsStakeholder Management

Full job description

Climate First Bank is a mission-driven, sustainability-focused commercial bank offering personal and business banking services. The Data Engineer designs, builds, maintains, and improves enterprise data pipelines, integrations, databases, and analytical data models across cloud, on-premises, and hybrid environments. The role owns data flow from source connectivity through ingestion, transformation, validation, storage, monitoring, and delivery to reporting and analytics consumers.

Responsibilities

  • Design, develop, operate, and improve end-to-end ETL and ELT pipelines from enterprise sources to business-ready datasets and analytical models
  • Own source connectivity, extraction, transformation, loading, validation, storage, monitoring, recovery, documentation, and operational support
  • Build maintainable solutions that meet defined business needs without unnecessary complexity; balance immediate delivery with a scalable foundation
  • Evaluate existing pipelines, rebuild unstable or obsolete processes, and select patterns based on business value, risk, cost, performance, security, and supportability
  • Integrate Microsoft SQL Server and other relational databases, ODBC sources, REST APIs, SaaS applications, secure file locations, shared datasets, CSV, JSON, Parquet, and other approved sources
  • Develop reusable ingestion patterns for authentication, pagination, rate limits, token renewal, retries, logging, exception handling, and schema changes
  • Support batch, incremental, snapshot, near-real-time, and streaming patterns when justified by business requirements
  • Maintain source-to-target mappings and document how source fields become standardized, validated, and usable information
  • Create complex SQL queries, views, stored procedures, functions, tables, keys, and transformation logic
  • Manage SQL Server from the database perspective, including schemas, objects, data structures, permissions coordination, backup requirements, troubleshooting, and performance
  • Design normalized structures and analytical models, including facts, dimensions, star schemas, data marts, and semantic-ready datasets
  • Optimize workloads through indexing, execution-plan analysis, partitioning, appropriate data types, incremental processing, and controlled historical retention
  • Build and maintain workflows using approved platforms such as Azure Data Factory, SQL Server, and other Bank-approved tools
  • Determine when to use full loads, incremental loads, watermarks, change tracking, snapshots, or event-driven patterns
  • Create parameterized pipelines with retries, checkpoints, idempotency, dependency controls, backfill procedures, and failure notifications
  • Design fault-tolerant processing so isolated data errors are captured and reported without unnecessarily stopping unrelated workloads
  • Embed automated checks for schema, data types, required fields, ranges, reference values, row counts, totals, balances, and completeness
  • Detect and handle duplicates, null values, malformed identifiers, invalid formats, latearriving records, schema drift, and incorrect aggregates
  • Reconcile transformed data against authoritative source systems, control totals, approved reports, and business rules
  • Prevent unverified data from reaching production reporting layers; maintain traceability for exceptions, remediation, and reprocessing
  • Build and support data solutions across Microsoft Azure, Google Cloud Platform, and on-premises environments as required by the Bank’s architecture
  • Securely move data between environments and coordinate on networking, integration runtimes, service accounts, secrets, access, and platform configuration
  • Improve execution time, query performance, freshness, reliability, and resource use through batching, parallelism, partitioning, workload management, and incremental processing
  • Assess storage, compute, movement, licensing, and duplication costs before changes; avoid unnecessary replication when secure direct-query or shared-data approaches are appropriate
  • Be capable of creating and working with Big Data solutions and products, such as BigQuery
  • Consolidate pipelines results on centralized data stores such as Datalakes and others
  • Deliver clean, documented, trustworthy, and appropriately modeled data to Power BI and other approved reporting platforms
  • Build reusable enterprise datasets and semantic-ready models; support relationships, field definitions, refresh requirements, and upstream performance troubleshooting
  • Partner with analysts and reporting teams while maintaining clear ownership boundaries between engineering, analytical modeling, and visualization development
  • Protect customer, financial, and operational information through least privilege, role-based access, encryption, approved secret management, logging, monitoring, and separation of duties
  • Maintain lineage, metadata, ownership, classification, retention, and access documentation; support audits, risk assessments, vendor reviews, and examinations
  • Ensure solutions align with Bank policies and applicable expectations, including GLBA, FFIEC, NIST, BSA, AML, CIP, and OFAC; escalate suspected control failures or unauthorized access
  • Monitor pipelines, integrations, databases, and delivery commitments; perform root-cause analysis and implement durable corrective actions
  • Maintain architecture and data-flow diagrams, entity relationships, dictionaries, pipeline inventories, transformation specifications, validation rules, runbooks, dependencies, and recovery procedures
  • Use approved shared repositories, version control, peer review, controlled releases, and change management for SQL, Python, pipeline assets, and documentation
  • Gather requirements and communicate scope, dependencies, risks, limitations, timelines, and recovery status clearly to technical teams, business users, executives, vendors, and auditors

Preferred

  • Experience in banking, financial services, healthcare, insurance, or another regulated industry is preferred
  • Experience with core systems migrations, data-platform modernization, reporting conversions, or foundational data-environment buildouts is preferred
  • Banking Industry Experience
  • Financial Services Experience
  • Healthcare Industry Experience
  • Insurance Industry Experience
  • Regulated Industry Experience
  • Core Systems Migration
  • Data Platform Modernization
  • Reporting Conversion
  • Data Environment Buildout

Benefits

  • This position may be eligible for an annual bonus, incentives and equity.
  • Health coverage 100% employer-paid for employees; employer contribution for dependents.
  • Medical, Dental & Vision Insurance
  • Health Savings Account (HSA)
  • Free Telemedicine access via Teladoc
  • 401(k) with 6% Employer Match — No Vesting Period.
  • Employee Stock Options
  • Exclusive Employee Banking Perks
  • 0% Financing for Employee Solar Loans
  • Employee Only Mortgage Product with exclusive interest rates and terms.
  • 0% Financing for Eligible Electric Vehicles (EVs)
  • Referral Incentives
  • 2–4 Weeks of Vacation based on officer level plus additional tenure-based time.
  • 64 Hours of Paid Sick Time for all full-time employees.
  • Company-Paid Life Insurance
  • Short- & Long-Term Disability Insurance
  • Voluntary Life, Accident & Critical Illness Coverage
  • Employee Assistance Program (EAP) with free counseling, legal, and financial services.
  • Remote role within the United States; Eastern Standard Hours.

Company

  • Climate-friendly personal and business banking solutions
  • St. Petersburg, Florida, USA
  • https://climatefirstbank.com/
  • Founded in 2018
  • 51-200 employees

Qualifications

  • The successful candidate must combine strong SQL, data integration, scripting, data quality, and troubleshooting skills with practical judgment and clear communication
  • Bachelor's degree in Computer Science, Information Systems, Data Engineering, Software Engineering, Mathematics, Finance, or a related field; equivalent practical experience may be considered
  • 3+ years of relevant experience in data engineering, database development, ETL/ELT development, analytics engineering, or a related discipline
  • Demonstrated ownership of production data pipelines from source ingestion through a final analytical model or business-ready dataset
  • Advanced SQL and T-SQL, including complex joins, transformations, window functions, stored procedures, query tuning, indexing, schema design, and incremental patterns
  • Demonstrated experience with CRM data streams (modeling and integration), like Salesforce and DataHub
  • Microsoft SQL Server experience from a database and data-engineering perspective
  • Hands-on experience with Azure Data Factory or a directly comparable enterprise orchestration platform
  • Proficiency in Python or an equivalent language for ingestion, transformation, validation, automation, and troubleshooting
  • Experience with APIs, file-based data, hybrid integration, analytical modeling, automated quality controls, monitoring, recovery, Git-based version control, and production support
  • Working knowledge of Power BI data models, relationships, refresh patterns, and upstream performance considerations; understanding of access control, encryption, logging, and auditability
  • We are unable to provide employment visa sponsorship now or in the future
  • You take charge of your work product and take pride in delivering consistently great and measurable results
  • You solve problems efficiently, seek operational efficiencies and are an analytical thinker with a strong focus on data-driven decision making
  • Whether it's in-person, on camera, phone, or chat — you communicate with confidence, precision, and professionalism
  • You listen deeply and respond thoughtfully and are able to engage efficiently and tactfully with stakeholders at all levels of the organization
  • Additionally, you masterfully build relationships and develop business with strong influencing and decision-making skills
  • You are highly educated in financial products and services, applicable regulations and laws
  • You also possess strong overall business acumen and the ability to interpret financial reports and legal documents
  • Strong knowledge of unique industries and markets in conjunction with a broad knowledge of business banking products and services is required
  • You learn new tools quickly, are excited by innovation and leverage technology to optimize your work product and streamline your creative process
  • You lift others up, share ideas, and bring positive energy to everything you do
  • You know what it takes to operate as a part of a larger team and cherish opportunities to contribute to the big picture
  • You're dependable, communicate clearly and always happy to lend a hand where needed
  • Experience in banking, financial services, healthcare, insurance, or another regulated industry is preferred
  • Experience with core systems migrations, data-platform modernization, reporting conversions, or foundational data-environment buildouts is preferred
  • 3+ years of relevant experience in data engineering, database development, ETL/ELT development, analytics engineering, or a related discipline.

Required skills

  • Advanced SQL and T-SQL, Microsoft SQL Server, ETL/ELT Development, Azure Data Factory, Python, CRM Data Integration, Salesforce, DataHub, API Integration, Analytical Data Modeling, Data Quality and Validation, Power BI Data Models, Stakeholder Management

Experience

  • 3+ years

Job details

Employment type

Full-time

Seniority level

3+ years

Date posted

Oct 1, 2026

Work mode

Remote

Job source

Ethic Leaf recruiter

Company

Climate First Bank

Information Technology & AI

Climate-friendly personal and business banking solutions

  • St. Petersburg, Florida, USA
  • Information Technology & AI
  • 51-200 employees
  • Founded 2018
  • climatefirstbank.com

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Engineer jobs

Curana Health

1d ago

New

Data Engineer

Full-timeRemoteUnited StatesCompetitive

Curana Health is hiring a Data Engineer to build, optimize, and maintain data pipelines supporting clinical, operational, and analytical reporting.

Why similarSame roleAzure Data FactoryRemote

Spring Health

1d ago

New

Senior GTM Data Engineer

Full-timeRemoteUnited States$159K – $175K/yr

Spring Health is hiring a Senior GTM Data Engineer to build and maintain the integrated data infrastructure supporting go-to-market analytics, automation, and AI agents.

Why similarSame roleAPI IntegrationRemote

eTeam

1d ago

New

Data Engineer

TemporaryRemoteUnited StatesCompetitive

SMBC US is hiring a Data Engineer to build systems that gather, store, and process large volumes of data for analysis. The role focuses on developing ETL pipelines, ensuring data quality, and optimizing data storage solutions.

Why similarSame roleAzure Data FactoryRemote

Get new Data Engineer jobs by email

Create job alert

Data Engineer

Climate First Bank · Competitive

Apply via Ethic Leaf