1 month ago
Base Salary
$149k - $240k/yr
Responsibilities
- Design, review, and evolve Postgres schemas for GRC product services.
- Set standards for indexing, constraints, partitioning, connection pooling, query optimization, and transactional performance.
- Own schema migration tooling, backfills, and zero-downtime database deployments across services.
- Define change-data-capture and extraction patterns, schedules, output shapes, and upstream schema-change communication.
- Define stable, documented landing-zone data contracts with the OLAP specialist.
- Establish relational modeling patterns, SQL coding standards, data contracts, and documentation for engineering teams.
- Implement data integrity checks, replication and failover practices, and monitoring for transactional data health and extraction pipelines.
- Manage schema and pipeline promotions through regulated dev, test, and production release processes.
- Apply RBAC, audit logging, and encryption standards at the OLTP and extraction layers.
- Mentor engineers on relational modeling, query optimization, SQL, and transactional fundamentals.
- Lead incident resolution and root-cause analysis for production data and extraction failures.
- Partner with the OLAP specialist and platform data team on ownership boundaries, warehouse provisioning, streaming infrastructure, and CI/CD tooling.
Requirements
- At least 5 years of data engineering or backend engineering experience with hands-on ownership of production Postgres or comparable relational OLTP systems.
- Bachelor’s or master’s degree in Computer Science, Data Engineering, or a related field, or equivalent professional experience.
- Expert-level SQL knowledge and strong understanding of query planning, indexing strategy, and transactional isolation levels.
- Proven experience owning schema design and migrations for production Postgres services at scale.
- Experience building CDC or extraction pipelines using Debezium, Kafka Connect, or similar tools that feed a cloud warehouse.
- Experience in regulated or highly controlled environments with strict release governance and compliance requirements.
- Familiarity with connection pooling such as PgBouncer, replication, and backup and recovery strategies.
- Working knowledge of dbt for collaboration on shared models.
- Experience mentoring engineers and driving cross-team technical standards.
Benefits
- US base salary range of $149,000.00-$240,000.00, plus a discretionary annual bonus, restricted stock units at hire, 401(k) match, and comprehensive employee benefits.
- Up to 10% travel for team jams and an internal developer conference.
- Employees may work from an office or remotely from any location within their country of employment, with reliable internet access required when working remotely.
- Employees undergo comprehensive role-tailored security and privacy training.
Tech Stack
Categories
BackendData Engineering
About Workiva
Workiva builds a cloud platform for connected financial, regulatory, and ESG reporting used by finance, accounting, risk, and audit teams at enterprises and government agencies. Its SaaS products support SEC and SEDAR filings, SOX/internal controls, enterprise risk management, and audit-ready collaboration with data linking and workflow automation. Founded in 2008 and headquartered in Ames, Iowa, Workiva is a public company traded on the NYSE under the ticker WK.