Data Engineer

Vaga não está no LinkedIn

🕒 Outubro 1

🇺🇸 Estados Unidos – Remoto (EUA)

⏰ Tempo Integral

🟡 Pleno

🟠 Sênior

🚰 Engenheiro de Dados

👻 Score fantasma 11%

O que significa: quão provável esta vaga está aberta sem contratação ativa.Como ler: 60% ou mais significa que achamos que é uma vaga fantasma. Pontuações mais baixas preocupam menos.Como pontuamos: tempo em aberto, republicações, vagas abertas vs tamanho do time, rapidez para fechar vagas, e se o salário está divulgado.Observação: é uma estimativa de dados públicos, não um julgamento da empresa. Vagas reais podem ter pontuação alta, então use como uma dica, não como um fato.

Candidatar-se

Encontrar Vagas Remotas Similares

Configurar Alerta de Email para Novas Vagas

📊 Verifique sua pontuação de currículo para esta vaga

Melhore suas chances de conseguir uma entrevista verificando sua pontuação de currículo antes de se candidatar.

Enviar Currículo

Climate First Bank

SiteLinkedInTodas as Vagas

51 - 200 funcionários

Fundada em 2020

🏦 Bancário

⚡ Energia

Banking • Energy

O Climate First Bank é um banco orientado por missão, segurado pelo FDIC, que foca em impacto climático e comunitário, oferecendo serviços completos de banco pessoal e empresarial. O banco disponibiliza produtos de depósito orientados para impacto (Conta Corrente Impacto, Conta Mercado Monetário Impacto, CDs), empréstimos hipotecários residenciais e de consumo, e um proeminente programa de financiamento solar (empréstimos solares para consumidores e empresas, financiamento de projetos de energia) projetado para financiar melhorias residenciais e de infraestrutura que reduzem emissões. O Climate First também oferece serviços bancários para empresas (empréstimos SBA, factoring/ABL, contas mercado monetário para empresas), financiamento ESOP, um aplicativo móvel e serviços de internet banking, além de ferramentas como Calculadora de Impacto de Depósito e Mercado de Depósito à Vista. A instituição destaca métricas de impacto (ex: mais de 9. 000 famílias apoiadas por meio de seu programa de empréstimos solares, mais de 30. 000 clientes, rodada de financiamento estratégico de $67M) e enfatiza empréstimos e gestão transparentes, alinhados à missão.

Descrição

• 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

🎯 Requisitos

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

🏖️ Benefícios

• 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