Data Engineer

Job Description

Job Description:\n\n We are changing FINANCE to finance CHANGE!\n At Climate First Bank, we're redefining what banking can be. As a Florida Benefit Corporation and FDIC-insured commercial bank, we offer a full suite of personal and business services—including solar, residential, commercial, ESOP Banking, Structured Finance and SBA loans—all designed to power a better future. We're proud to be a Certified B Corporation, a member of 1% for the Planet, and part of the Global Alliance for Banking on Values (GABV), reflecting our deep commitment to sustainability, transparency, and ethical banking.\n With branches in St. Petersburg, Winter Park, Mount Dora, Downtown Orlando and a growing digital presence, we're proving that banking can be a force for good. We don't just support environmental and social causes—we're built on them.\n Under our Holding Company, Climate First Bancorp, we are also powered by OneEthos. OneEthos operates at the intersection of fintech and traditional banking to expand access to inclusive, values-driven financial services. Regulated by the Federal Reserve Bank, it equips Community Banks, Credit Unions, CDFIs, and Green Banks with ethical lending tools—especially in climate finance and solar lending.Join the Movement\n We're seeking driven, mission-aligned individuals ready to make an impact. If you're passionate about sustainability, thrive in a fast-paced, results driven environment, and want to be part of something bigger, you will feel right at home.\n Our team is one of goal-setters, go-getters, problem solvers, thought leaders, and changemakers. We celebrate wins, tackle challenges head-on, and push boundaries. Fueled by purpose, we thrive where perseverance and passion turn ambitious goals into reality.Thrive at Climate First Bank\n At Climate First Bank, we're investing in your future. We offer a comprehensive, people-first benefits package that supports your health, finances, and work-life balance. Please note that benefit eligibility varies by employment status and that benefits for part-time employees may differ from those listed below.\n Compensation — In addition to the base salary, this position may be eligible for an annual bonus, incentives and equity. Actual compensation is based on industry salary ranges, internal salary structures, experience, skills and other job-related factors.\n Health Coverage — 100% employer-paid for employees; employer contribution for dependents by Us\n \n Medical, Dental & Vision Insurance \n Health Savings Account (HSA) \n Free Telemedicine access via Teladoc\n \n Financial Wellness & Wealth Building\n \n 401(k) with 6% Employer Match — No Vesting Period.\n Employee Stock Options \n Exclusive Employee Banking Perks \n 0% Financing for Employee Solar Loans \n Employee Only Mortgage Product with exclusive interest rates and terms.\n 0% Financing for Eligible Electric Vehicles (EVs) \n Referral Incentives \n \n Generous Paid Time Off\n \n 2–4 Weeks of Vacation based on officer level plus additional tenure-based time.\n 64 Hours of Paid Sick Time for all full-time employees.\n \n Protection & Peace of Mind\n \n Company-Paid Life Insurance \n Short- & Long-Term Disability Insurance\n Voluntary Life, Accident & Critical Illness Coverage \n Employee Assistance Program (EAP) with free counseling, legal, and financial services.\n \n\nNow Hiring: Data Engineer\nAll Climate First Bank employees must be willing to embrace the vision of an inclusive, equitable, and regenerative economic system. The Data Engineer designs, builds, maintains, and improves the Bank's enterprise data pipelines, integrations, databases, and analytical data models. The role owns the flow of data from source connection through ingestion, transformation, validation, storage, monitoring, and delivery to reporting and analytics consumers. This hands-on role spans cloud, on-premises, and hybrid environments. The Data Engineer integrates core banking platforms, operational databases, APIs, files, SaaS applications, and cloud data platforms while emphasizing secure, reliable, documented, and business-ready outcomes. The successful candidate must combine strong SQL, data integration, scripting, data quality, and troubleshooting skills with practical judgment and clear communication.\nWhat You'll Contribute as a Data Engineer\nData Architecture and Pipeline Ownership\n\n Design, develop, operate, and improve end-to-end ETL and ELT pipelines from enterprise sources to business-ready datasets and analytical models.\n Own source connectivity, extraction, transformation, loading, validation, storage, monitoring, recovery, documentation, and operational support.\n Build maintainable solutions that meet defined business needs without unnecessary complexity; balance immediate delivery with a scalable foundation.\n Evaluate existing pipelines, rebuild unstable or obsolete processes, and select patterns based on business value, risk, cost, performance, security, and supportability\n\nData Integration and Source Connectivity\n\n 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.\n Develop reusable ingestion patterns for authentication, pagination, rate limits, token renewal, retries, logging, exception handling, and schema changes.\n Support batch, incremental, snapshot, near-real-time, and streaming patterns when justified by business requirements.\n Maintain source-to-target mappings and document how source fields become standardized, validated, and usable information.\n\nSQL, Database Engineering, and Data Modeling\n\n Create complex SQL queries, views, stored procedures, functions, tables, keys, and transformation logic.\n Manage SQL Server from the database perspective, including schemas, objects, data structures, permissions coordination, backup requirements, troubleshooting, and performance.\n Design normalized structures and analytical models, including facts, dimensions, star schemas, data marts, and semantic-ready datasets.\n Optimize workloads through indexing, execution-plan analysis, partitioning, appropriate data types, incremental processing, and controlled historical retention.\n\nETL/ELT Development and Reliability\n\n Build and maintain workflows using approved platforms such as Azure Data Factory, SQL Server, and other Bank-approved tools.\n Determine when to use full loads, incremental loads, watermarks, change tracking, snapshots, or event-driven patterns.\n Create parameterized pipelines with retries, checkpoints, idempotency, dependency controls, backfill procedures, and failure notifications.\n Design fault-tolerant processing so isolated data errors are captured and reported without unnecessarily stopping unrelated workloads.\n\nData Quality, Validation, and Reconciliation\n\n Embed automated checks for schema, data types, required fields, ranges, reference values, row counts, totals, balances, and completeness.\n Detect and handle duplicates, null values, malformed identifiers, invalid formats, latearriving records, schema drift, and incorrect aggregates.\n Reconcile transformed data against authoritative source systems, control totals, approved reports, and business rules.\n Prevent unverified data from reaching production reporting layers; maintain traceability for exceptions, remediation, and reprocessing.\n\nCloud, Hybrid, Performance, and Cost\n\n Build and support data solutions across Microsoft Azure, Google Cloud Platform, and on-premises environments as required by the Bank's architecture.\n Securely move data between environments and coordinate on networking, integration runtimes, service accounts, secrets, access, and platform configuration.\n Improve execution time, query performance, freshness, reliability, and resource use through batching, parallelism, partitioning, workload management, and incremental processing.\n Assess storage, compute, movement, licensing, and duplication costs before changes; avoid unnecessary replication when secure direct-query or shared-data approaches are appropriate.\n\nData Consolidation and Big Data\n\n Be capable of creating and working with Big Data solutions and products, such as BigQuery.\n Consolidate pipelines results on centralized data stores such as Datalakes and others.\n\nAnalytics and Power BI Readiness\n\n Deliver clean, documented, trustworthy, and appropriately modeled data to Power BI and other approved reporting platforms.\n Build reusable enterprise datasets and semantic-ready models; support relationships, field definitions, refresh requirements, and upstream performance troubleshooting.\n Partner with analysts and reporting teams while maintaining clear ownership boundaries between engineering, analytical modeling, and visualization development.\n\nSecurity, Governance, and Compliance\n\n Protect customer, financial, and operational information through least privilege, role-based access, encryption, approved secret management, logging, monitoring, and separation of duties.\n Maintain lineage, metadata, ownership, classification, retention, and access documentation; support audits, risk assessments, vendor reviews, and examinations.\n 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.\n\nOperations, Documentation, and Collaboration\n\n Monitor pipelines, integrations, databases, and delivery commitments; perform root-cause analysis and implement durable corrective actions.\n Maintain architecture and data-flow diagrams, entity relationships, dictionaries, pipeline inventories, transformation specifications, validation rules, runbooks, dependencies, and recovery procedures.\n Use approved shared repositories, version control, peer review, controlled releases, and change management for SQL, Python, pipeline assets, and documentation.\n Gather requirements and communicate scope, dependencies, risks, limitations, timelines, and recovery status clearly to technical teams, business users, executives, vendors, and auditors.\n\nWhat You'll Leverage in this Role:\nExperience & Education\n\n Bachelor's degree in Computer Science, Information Systems, Data Engineering, Software Engineering, Mathematics, Finance, or a related field; equivalent practical experience may be considered. \n 3+ years of relevant experience in data engineering, database development, ETL/ELT development, analytics engineering, or a related discipline.\n Demonstrated ownership of production data pipelines from source ingestion through a final analytical model or business-ready dataset.\n Experience in banking, financial services, healthcare, insurance, or another regulated industry is preferred.\n Experience with core systems migrations, data-platform modernization, reporting conversions, or foundational data-environment buildouts is preferred.\n\nRequired Technical Skills\n\n Advanced SQL and T-SQL, including complex joins, transformations, window functions, stored procedures, query tuning, indexing, schema design, and incremental patterns.\n Demonstrated experience with CRM data streams (modeling and integration), like Salesforce and DataHub.\n Microsoft SQL Server experience from a database and data-engineering perspective.\n Hands-on experience with Azure Data Factory or a directly comparable enterprise orchestration platform.\n Proficiency in Python or an equivalent language for ingestion, transformation, validation, automation, and troubleshooting.\n Experience with APIs, file-based data, hybrid integration, analytical modeling, automated quality controls, monitoring, recovery, Git-based version control, and production support.\n Working knowledge of Power BI data models, relationships, refresh patterns, and upstream performance considerations; understanding of access control, encryption, logging, and auditability.\n\nWe are unable to provide employment visa sponsorship now or in the future. \nEntrepreneurial Self-Starter Mentality - 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. A high-pace and high-expectation environment excites you and you can't wait to push yourself to new professional heights in a company that rewards high performance.\nMaster Communicator - 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.\nBanking & Fintech Acumen- 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.\nTech-Forward and Analytical Thinking - You learn new tools quickly, are excited by innovation and leverage technology to optimize your work product and streamline your creative process. \nCommitment to Being a Team Player - 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.\n \nWhat to expect from your physical environment\n\n Remote role within the United States; Eastern Standard Hours.\n Occasional U.S. travel for company events or leadership sessions.\n Sustained standing and sitting.\n Frequent communication (speaking and listening) and use of PC, including typing or sustained attention to monitor.\n Occasional lifting up to 20 lbs.\n\n \n\n Equal Opportunity Statement:At Climate First Bank we truly believe that our people are our strength and the diverse talents they bring to our workforce are directly linked to our success. Diversity and inclusion are at the core of our values and mission. We do not discriminate on the basis of any protected attribute, including race, religion, color, national origin, gender, sexual orientation, gender identity, gender expression, age, marital or veteran status, pregnancy or disability, or any other basis protected under applicable law. In accordance with applicable law, we make reasonable accommodations for applicants' and employees' religious practices and beliefs, as well as any mental health or physical disability needs.Equal Opportunity Employer/Disability/VeteransE-Verify Statement: This employer participates in E-Verify and will provide the federal government with your Form I-9 information to confirm that