Data Engineer

Job not on LinkedIn

🔥 0 minutes ago

🇺🇸 United States – Remote

⏰ Full Time

🟡 Mid-level

🟠 Senior

🚰 Data Engineer

👻 Ghost score 10%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

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

Upload Resume

Climate First Bank

WebsiteLinkedInAll Job Openings

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