Data Engineer I

We run one of the larger SaaS platforms for commercial insurance carriers, processing millions of policy transactions a year. More than 9,000 organizations use our HR and payroll suite, from regional hospitals to school districts.

Job summary:

The Data Platform team moves data from about 30 source systems into Snowflake. You'll own ingestion, modeling and data quality checks. Kestrelscale needs someone who writes solid SQL and Python and treats pipelines like production software. Fully remote. You can work from anywhere in the US. Few meetings, lots of written updates. Good written English matters here, since most updates are written.

In this role you will:

• Work with analysts to define metrics and fix discrepancies between reports
• Maintain CI for data code and review pull requests
• Tune slow queries and expensive jobs
• Process large datasets with Spark on Databricks or EMR
• Respond to pipeline failures and backfill data when needed
• Handle PII according to retention, masking and access policies
• Document datasets and lineage in a catalog such as DataHub or Atlan

Qualifications:

• 1-2 years of data engineering, or backend work with data at volume
• Familiarity with Git, CI/CD and testing practices for data code
• Working knowledge of AWS, GCP or Azure data services
• Understanding of dimensional modeling and slowly changing dimensions
• Expert SQL, including window functions and query tuning
• Patience with messy source data and the habit of documenting assumptions
• Strong Python for data processing

Preferred:

• Background in finance or marketing data
• Reverse ETL tools like Hightouch or Census

The salary range for this role is $64.50 - $75.00 per hour. This range reflects base salary only.

Compensation and benefits:

• Home office stipend
• $1,000 home office setup budget

We are an equal opportunity employer and value diversity. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.

Duration: 6 months. Start: Within 30 days.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Kestrelscale LLC.