Data Engineer

Job not on LinkedIn

🕒 October 1

🇺🇸 United States – Remote

⏰ Full Time

🟡 Mid-level

🚰 Data Engineer

Where this job comes from

Posted on Climate First Bank's careers page ↗Climate First Bank's careers page, not through a job board

First seen by Remote Rocketship October 1

Still open on Climate First Bank's site. Checked 5 hours ago.

Apply Now
Logo of Climate First Bank

Climate First Bank

51 - 200 employees

Founded 2020

🏦 Banking

⚡ Energy

Banking • Energy

Climate First Bank is a mission-driven, FDIC‑insured bank that focuses on climate and community impact while offering full-service personal and business banking. The bank provides impact-oriented deposit products (Impact Checking, Impact Money Market, CDs), consumer and residential mortgage lending, and a prominent solar financing program (consumer and commercial solar loans, project energy finance) designed to fund emissions-reducing home and infrastructure upgrades. Climate First also offers business banking (SBA lending, factoring/ABL, business money market accounts), ESOP financing, a mobile app and online banking, and tools like a Deposit Impact Calculator and a Demand Deposit Marketplace. The institution highlights impact metrics (e. g. , 9,000+ households supported through its solar loan program, 30,000+ customers, $67M strategic funding round) and emphasizes transparent, mission-aligned lending and stewardship.

📋 Description

• 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 • Evaluate existing pipelines, rebuild unstable or obsolete processes, and select patterns based on business value, risk, cost, performance, security, and supportability • Integrate 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 • Create complex SQL queries, views, stored procedures, functions, tables, keys, and transformation logic • Manage SQL Server 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 Azure Data Factory, SQL Server, and other approved tools • Create parameterized pipelines with retries, checkpoints, idempotency, dependency controls, backfill procedures, and failure notifications • Design fault-tolerant processing and isolate, report, and remediate data errors • Embed automated data-quality checks and reconcile transformed data against authoritative systems, control totals, approved reports, and business rules • Build and support data solutions across Microsoft Azure, Google Cloud Platform, and on-premises environments • Securely move data between environments and coordinate networking, integration runtimes, service accounts, secrets, access, and platform configuration • Create and work with Big Data solutions such as BigQuery and consolidate pipeline results in centralized data stores such as data lakes • Deliver clean, documented, trustworthy, appropriately modeled data to Power BI and other reporting platforms • Build reusable enterprise datasets and semantic-ready models; support relationships, field definitions, refresh requirements, and upstream performance troubleshooting • Protect customer, financial, and operational information through least privilege, role-based access, encryption, 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 • 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 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 to technical teams, business users, executives, vendors, and auditors

🎯 Requirements

• 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 • 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 • 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, such as 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 • Must be authorized to work in the U.S.; employment visa sponsorship is unavailable now and in the future • Must be able to work Eastern Standard Hours • Required strong knowledge of financial products and services, applicable regulations and laws, business banking products and services, and ability to interpret financial reports and legal documents • Must be able to meet physical requirements including sustained standing and sitting, frequent communication and PC use, and occasional lifting up to 20 lbs.

🏖️ Benefits

• Annual bonus, incentives and equity may be available in addition to base salary • 100% employer-paid employee health coverage; employer contribution for dependents • Medical, Dental & Vision Insurance • Health Savings Account (HSA) • Free Telemedicine access via Teladoc • 401(k) with 6% employer match and 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- and Long-Term Disability Insurance • Voluntary Life, Accident & Critical Illness Coverage • Employee Assistance Program (EAP) with free counseling, legal, and financial services

Apply Now

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Similar Jobs

🕒 October 1

TTEC Digital

1001 - 5000

💼 Consulting

📣 Marketing

🤖 Artificial Intelligence

Senior Data Engineer architecting Azure and Databricks data platforms for TTEC Digital’s customer-experience solutions. Building governed pipelines, APIs, and AI data integrations while mentoring engineers.

🕒 September 30

Extend

201 - 500

🛡️ Insurance

📦 Logistics

🛍️ eCommerce

Senior Data Platform Engineer building reliable AWS merchant integrations for Extend’s AI-driven post-purchase retail platform. Developing event-driven data systems, onboarding tooling, and error reporting.

🕒 September 30

Intertwine Associates

1 - 10

🏥 Healthcare

📦 Logistics

📣 Marketing

AI/Data Engineer building Python ETL workflows, Azure data services, and ML-ready infrastructure. Supporting federal and regulated clients with scalable, governed data platforms.

🕒 September 29

Stellic

51 - 200

📚 Education

☁️ SaaS

Platform Data Architect integrating university student information systems for Stellic’s student-success platform. Owning partner deployments, data feeds, migrations, and scalable integration standards.

🇺🇸 United States – Remote

💵 $118k - $173k / year

💰 $11M Series A - Stellic on 2022-03

⏰ Full Time

🟡 Mid-level

🟠 Senior

🚰 Data Engineer

🕒 September 29

Attain Talent

1 - 10

🎯 Recruiter

🤝 Non-profit

📚 Education

Senior Software Engineer building AirHub, a platform replacing eleven legacy EPA systems. Developing APIs, integrations, and data migration routines with a small engineering team.

Developed by Lior Neu-ner. I'd love to hear your feedback — Get in touch via DM or support@remoterocketship.com
Follow Remote Rocketship on LinkedInFollow Remote Rocketship on InstagramFollow Remote Rocketship on FacebookFollow Remote Rocketship on TikTok