Data Engineer

Summary

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

Skills

• 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

Qualifications

Must Haves

• 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

Nice to Haves

• 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

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.