Senior Data Engineer - Python

THE COMPANY:

Customers use our platform to manage equipment rentals: reservations, check-out, damage photos, invoicing and QuickBooks sync. We make a web-based inventory and purchasing system used by independent restaurants, breweries and small food manufacturers.

THE POSITION:

Kinsale Digital is hiring a Senior Data Engineer - Python to work remotely from the US. The Data Infrastructure team moves data from about 30 source systems into Snowflake. You'll own ingestion, modeling and data quality checks. Fully remote. You can work from anywhere in the US. You can set your own hours around a daily morning check-in.

YOUR RESPONSIBILITIES:

• Maintain CI for data code and review pull requests.
• Work with analysts to define metrics and fix discrepancies between reports.
• Write data quality tests with dbt or Great Expectations and alert on failures.
• Model data in dbt using staging, intermediate and mart layers.
• Design table layouts and partitioning for Parquet, Delta Lake or Iceberg.

SKILLS AND EXPERIENCE:

• 5+ years of data engineering, or backend work with data at volume.
• Hands-on with an orchestration tool such as Airflow.
• Expert SQL, including window functions and query tuning.
• Working knowledge of AWS, GCP or Azure data services.
• Understanding of dimensional modeling and slowly changing dimensions.
• Patience with messy source data and the habit of documenting assumptions.

PREFERRED:

• Knowledge of GDPR, CCPA or HIPAA data handling rules.

WHAT WE OFFER:

Compensation: $187,000 to $230,000 annually DOE.

• Medical, dental and vision insurance.
• 401(k) with 4% match.
• Paid holidays.
• Stock options.
• Profit sharing.
• 401(k) with a 100% match up to 5%.
• Vision insurance.

Apply with your resume. A cover letter is optional.

Start dates are flexible, usually within a few weeks of an offer.

Start: Immediately.

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