Data Engineer II

Build and operate data pipelines and models that support Kind Lending’s Snowflake data platform.

Responsibilities

• Design, build, and maintain scalable ETL/ELT pipelines to ingest source-system data into Snowflake using a governed Bronze/Silver/Gold medallion architecture.
• Develop and maintain CDC-based replication and ingestion pipelines using tools such as OpenFlow, Fivetran, or comparable options, ensuring data arrives 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.
• Create Python-based scripts, automation, and integrations to support ingestion, transformation, monitoring, and governance workflows.
• Design and maintain dimensional and semantic data models (fact and dimension tables, star schema, and surrogate keys) for reporting and self-service analytics.
• Partner with BI developers to build semantic-layer views that power Power BI dashboards, keeping business logic in the data platform instead of in DAX.
• Monitor pipeline health and data quality; implement observability and logging; troubleshoot issues across ingestion and transformation layers.
• Integrate third-party systems and APIs (including Jira and other ticketing or operational platforms) into the data warehouse to centralize reporting.
• Document pipelines, data models, and processes with clear technical documentation for internal teams.
• Collaborate with the Data & 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 such as Redshift, BigQuery, or Synapse.
• Proficiency in Python for scripting, automation, and pipeline development.
• Experience building and maintaining ETL/ELT pipelines and CDC-based replication (e.g., OpenFlow, Fivetran, or similar tools).
• Solid understanding of data modeling, including medallion (Bronze/Silver/Gold), star schema, and dimensional modeling.
• Familiarity with Power BI (or similar BI tools) and how upstream models support dashboards and reporting.
• Experience using Jira or similar ticketing/project tracking tools to manage and document engineering work.
• Comfort with Git and 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

• $120,000 - $140,000 per year starting base salary range
• Actual base depends on experience, business needs, market demands, and other compensation components
• Base pay range may change 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
• Sit or stand for prolonged periods; occasionally stoop, bend, kneel, crouch, reach, and twist
• Lift, carry, push, and/or pull light to moderate amounts of weight
• Operate office equipment requiring repetitive hand movement and fine coordination (keyboard use)
• Verbal communication 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

Other Information

• Job duties are not all-inclusive and may expand based on business needs
• Kind Lending is an equal opportunity employer committed to workforce diversity
• Only contact from email addresses ending in @kindlending.com; emails from other domains may be phishing attempts