Data Engineer II

Kind Lending, LLC; United States; Remote; USD 120,000 - 140,000; Full time

Job summary

Kind Lending, LLC seeks a Data Engineer II to design, build, and maintain data pipelines, data models, and integrations that power its Snowflake data platform.

This role supports a governed Bronze/Silver/Gold medallion architecture and enables clean reporting for downstream analytics and dashboards.

Qualifications

• Bachelor’s degree in CS/IS or related field or equivalent experience.
• 4–6+ years in data engineering or similar role.
• Strong SQL and hands-on Snowflake or comparable warehouse experience.

Responsibilities

• Design, build, and maintain scalable ETL/ELT pipelines into Snowflake.
• Develop CDC-based ingestion pipelines (OpenFlow, Fivetran, or similar).
• Write and optimize SQL, stored procedures, views, and tasks in Snowflake.
• Develop Python scripts for automation and governance workflows.
• Model dimensional structures (fact/dimension tables, star schema, surrogate keys).
• Collaborate with BI to build semantic views powering Power BI dashboards.
• Monitor data pipeline health, observability, and troubleshoot issues across layers.
• Integrate Jira and other systems into the data warehouse for centralized reporting.
• Document pipelines, models, and processes for the team.

Skills

SQL

Python

Snowflake

Data modeling

OpenFlow

Fivetran

Power BI

Jira

Git

Education

Bachelor’s degree in Computer Science, Information Systems, or a related field

Tools

Snowflake

OpenFlow

Fivetran

Power BI

Jira

Git

Redshift

BigQuery

Synapse

Job description

Kind Lending, LLC is hiring a Data Engineer II to design, build, and maintain data pipelines, data models, and integrations that support its Snowflake data platform. This role will help power a governed Bronze/Silver/Gold medallion architecture and enable clean reporting for downstream analytics.

Responsibilities

• Design, build, and maintain scalable ETL/ELT pipelines that ingest source system data into Snowflake using a governed Bronze/Silver/Gold medallion architecture.
• Build and maintain CDC-based replication and ingestion pipelines (for example, OpenFlow, Fivetran, or comparable tools) to bring operational data into the platform reliably and on schedule.
• Write and optimize SQL, stored procedures, views, and scheduled tasks in Snowflake to transform raw data into clean, business-ready datasets.
• Develop Python-based scripts, automation, and integrations to support ingestion, transformation, monitoring, and governance workflows.
• Design and maintain dimensional and semantic data models, including fact and dimension tables, star schema structures, and surrogate keys, to support reporting and self-service analytics.
• Partner with BI developers to build semantic-layer views that power Power BI dashboards, with business logic kept in the data platform rather than DAX.
• Monitor pipeline health and data quality, implement observability and logging, and troubleshoot issues across ingestion and transformation layers.
• Integrate third-party systems and APIs (for example, Jira and other ticketing or operational platforms) into the data warehouse to centralize reporting.
• Document data pipelines, data models, and processes to maintain technical documentation for the broader team.
• Collaborate with the Data and Business Intelligence team on platform governance, security, and access management best practices.

Requirements

• Bachelor’s degree in Computer Science, Information Systems, or a related field, or equivalent practical experience.
• 4-6+ years of experience in a data engineering or similar data platform role.
• Strong SQL skills and hands‑on experience with Snowflake or another cloud data warehouse (for example, Redshift, BigQuery, Synapse).
• Proficiency in Python for scripting, automation, and data pipeline development.
• Experience building and maintaining ETL/ELT pipelines and CDC-based data replication (for example, OpenFlow, Fivetran, or similar tools).
• Solid understanding of data modeling concepts, including medallion (Bronze/Silver/Gold) architecture, star schema, and dimensional modeling.
• Familiarity with Power BI or a similar BI tool, and how upstream data models support dashboards and reporting.
• Experience using Jira or similar ticketing and project tracking tools to manage and document engineering work.
• Comfort working with version control (Git) and applying general software engineering best practices.
• Mortgage, lending, or financial services industry experience is a plus.
• Excellent verbal and written communication skills.
• Team player mentality and willingness to work in a fast‑paced environment aligned with Kind Culture.

Technologies

• Snowflake
• SQL
• Python
• OpenFlow
• Fivetran
• Power BI
• DAX
• Jira
• Git
• Redshift
• BigQuery
• Synapse
• CDC
• ETL
• ELT

Location

Remote (remote). Remote, Hybrid, and In‑Person available.

Compensation

USD 120,000 - 140,000 per yearly. The actual base is dependent on factors including work experience, business needs, market demands, and other compensation components. The base pay range is subject to change and may be modified in the future.

Work Authorization

Must be able to verify identity and employment eligibility to work in the U.S. without visa sponsorship.

Physical Demands

Primary functions require sufficient physical ability and mobility to work in an office setting. This includes standing or sitting for prolonged periods; occasionally stooping, bending, kneeling, crouching, reaching, and twisting; lifting, carrying, pushing, and pulling light to moderate amounts of weight; operating office equipment requiring repetitive hand movement and fine coordination including use of a keyboard; and verbally communicating to exchange information. Vision: see in the normal visual range with or without correction. Hearing: hear in the normal audio range with or without correction.

Additional Information

This job profile is not intended to be an all-inclusive list of job duties and responsibilities, as one may perform additional related duties as assigned to meet organizational needs.

Equal Opportunity

Kind Lending is an equal opportunity employer committed to workforce diversity. Qualified applicants will receive consideration without regard to race, religion, creed, color, orientation, gender, age, national origin, veteran status, disability status, marital status, sexual orientation, gender identity, or gender expression.

Security Notice

For your security, Kind Lending will only contact you from email addresses ending in kindlending.com. Emails from any other domain should be treated as suspicious and may be phishing attempts.