Senior Data Engineer

About the role:

Wright Software needs someone who writes solid SQL and Python and treats pipelines like production software. Remote position. Most of the team is in Chicago, but nobody is required to come in. Few meetings, lots of written updates. You will write a lot of updates, so clear written English is important.

Key responsibilities:

• Work with analysts to define metrics and fix discrepancies between reports.
• Write data quality tests with dbt or Great Expectations and alert on failures.
• Design table layouts and partitioning for Parquet, Delta Lake or Iceberg.
• Ingest data from APIs, SaaS tools and databases with Fivetran, Airbyte or custom Python.
• Model data in dbt using staging, intermediate and mart layers.
• Respond to pipeline failures and backfill data when needed.
• Tune slow queries and expensive jobs.
• Maintain CI for data code and review pull requests.

What we're looking for:

• 7+ years of data engineering, or backend work with data at volume.
• Strong Python for data processing.
• Expert SQL, including window functions and query tuning.

Bonus points:

• Terraform for data infrastructure.

What you get:

Compensation: $176,000 - $205,000 annually

• Medical, dental and vision insurance.
• 401(k) with 4% match.
• Three weeks of PTO to start.
• Employee discount.
• Home office stipend.

About the company:

Founded in 2013, the business writes the billing, metering and customer portal software that small water and electric utilities run on. Our main product is a payroll and timekeeping app for hourly workforces, sold by subscription and supported from Chicago.

We are unable to sponsor visas for this position.

Start: Flexible.

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