O

OpenData

Delivers standardized open data for research

SQL Data Engineer

Data EngineeringPosted on Nov 13
Full-timeWashington, DC, USA$120k - $140k /yr

About the Job

Requirements

  • At least 4 years of data engineering, database development, database engineering, software development, or comparable practical experience.
  • A bachelor's degree is required.
  • SQL skills across complex queries, views, stored procedures, and functions, together with relational design, normalization, and data modeling are required.
  • Working expertise in Amazon Aurora (PostgreSQL-compatible), including schema design, stored procedures and functions, and indexing, is required.
  • Experience with Amazon DynamoDB, including data modeling and Global and Local Secondary Indexes (GSIs and LSIs), is required.
  • Experience tuning performance and queries to address slow queries through indexing and execution-plan work is required.
  • Experience making logical data modeling and database-design decisions for assigned components within an established platform architecture is required.
  • Experience developing ETL and ELT processes and integrating data across AWS services such as Aurora, DynamoDB, and S3 is required.
  • Experience working within data security controls such as encryption, access management, and auditing is required.
  • Experience loading data from S3 into platform stores and connecting through Open Database Connectivity (ODBC) and Java Database Connectivity (JDBC) is required.
  • Proficiency in writing, PowerPoint, and Excel is required.

Responsibilities

  • Design database schemas and write the views, stored procedures, functions, and SQL queries that run on them.
  • Build and maintain data pipelines and ETL and ELT processes, including loads from Amazon S3.
  • Tune queries and databases for high-volume workloads.
  • Model data across AWS stores such as Amazon Aurora, Amazon DynamoDB, and S3.
  • Maintain accurate and secure data with governed access and auditable changes.
  • Work out data access patterns and integrations with developers, architects, and data engineers.
  • Where the work allows, use AI-assisted tools for query, pipeline, and troubleshooting work, and review and validate their outputs.
  • Take responsibility for the accuracy and performance of assigned components.
  • Automate data loads and checks that were previously run by hand, and build models that continue to work as the platform grows.
  • Own assigned database work from design through maintenance while working within data security controls.

Desired Qualifications

  • An AWS certification at the associate level, such as Developer Associate or Solutions Architect Associate, is preferred.
  • Experience tuning queries involving locking and deadlocks is preferred.
  • Familiarity with supporting cloud-native applications in AWS through continuous integration and continuous delivery (CI/CD) and development, security, and operations (DevSecOps) practices is preferred.
  • Ownership of physical design for Aurora and DynamoDB schemas and indexes, or the drive to grow into it, is preferred.
  • Experience in federal information technology or high-volume transaction environments is preferred.
  • Familiarity with AI-assisted developer tools is preferred.

About the Company

OpenData

Delivers standardized open data for research

OpenData is a collaborative effort that makes public data easier to access and use. It collects public datasets, standardizes them, and centralizes them so researchers, analysts, and governments can find reliable data in one place. The service works by providing access to standardized datasets—through partnerships, subscriptions, or data services—so users can download, analyze, and apply the data to research and policy work. Unlike more traditional data providers, OpenData emphasizes open access and collaboration, focusing on broad accessibility and the usefulness of data for innovation rather than selling bespoke data products. The goal is to empower researchers and organizations to gain insights, drive innovation, and enable positive social impact through open, high-quality public data.

Company size
Not listed
Company stage
Not listed
Total funding
Not listed
Headquarters
Mexico
Founded
2024

Recently Posted Jobs

Explore more opportunities at OpenData

See more jobs