Kind Lending, LLC is seeking a Data Engineer II to design, build, and maintain data pipelines, data models, and integrations that support its Snowflake data platform. This role focuses on governed Bronze/Silver/Gold ingestion and transformation, reliable CDC-based replication, and collaboration with BI to enable Power BI reporting.
Responsibilities
- Design, build, and maintain scalable ETL/ELT pipelines that ingest data from source systems 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 source data into the data platform on schedule.
- Write and optimize SQL in Snowflake, including stored procedures, views, and scheduled tasks 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 for reporting and self-service analytics.
- Partner with BI developers to create semantic-layer views that power Power BI dashboards, with business logic maintained in the data platform rather than DAX.
- Monitor pipeline health and data quality by implementing observability and logging across ingestion and transformation layers, then troubleshoot issues as needed.
- Integrate third-party systems and APIs (such as Jira and other ticketing or operational platforms) into the data warehouse to centralize reporting.
- Document data pipelines, data models, and processes with clear technical documentation for the broader team.
- 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 to 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 (Redshift, BigQuery, or Synapse).
- Proficiency in Python for scripting, automation, and data pipeline development.
- Experience building and maintaining ETL/ELT pipelines and CDC-based data replication (such as 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, including how upstream data models support dashboards and reporting.
- Experience using Jira or similar ticketing or 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 with willingness to work in a fast-paced environment while supporting 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 availability.
Compensation
The starting base salary range for this position is USD 120,000 - 140,000 per year. The actual base is dependent on work experience, business needs, market demands, and other compensation components. The base pay range may change based on future business needs.
Work Authorization
Must be able to verify identity and employment eligibility to work in the U.S. without a visa sponsorship.
Physical Demands
Primary functions require sufficient physical ability and mobility to work in an office setting, including standing or sitting for prolonged periods of time and occasionally stooping, bending, kneeling, crouching, reaching, and twisting. The role may require lifting, carrying, pushing, and/or pulling light to moderate amounts of weight, operating office equipment with repetitive hand movement and fine coordination (including keyboard use), and verbally communicating to exchange information. Vision requirements include seeing in the normal visual range with or without correction. Hearing requirements include hearing in the normal audio range with or without correction.
Additional Information
This job profile is not intended to be an all-inclusive list of duties and responsibilities, as other related duties may be 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.
