> Markdown version of [/jobs/ext/4625509-data-engineer-sql](https://www.wearedevelopers.com/jobs/ext/4625509-data-engineer-sql). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Engineer (SQL) - **Company:** Open Data Watch, Inc. - **Location:** Washington, DC, United States - **Experience:** Experienced - **Salary:** $120,000 - $140,000 - **Contract:** Permanent contract - **Skills:** Microsoft Excel, Artificial Intelligence, Amazon Web Services, Amazon S3, Databases, Continuous Integration, Information Engineering, Data Integration, Extract Transform Load (ETL), Data Security, Database Development, Programming Tools, Amazon DynamoDB, Identity and Access Management, Java Database Connectivity, PostgreSQL, Logical Data Models, Open Database Connectivity, Microsoft PowerPoint, Query Optimization, Standard Sql, Software Engineering, SQL Stored Procedures, SQL Databases, Spring Cloud, Indexer, Information Technology, AWS Data Analytics, Data Management, Physical Design, Software Version Control, Devsecops - **Published:** November 7, 2026 - **Apply:** https://www.juju.com/job/16_d742f1c11 ## About the Role * 4+ years of data engineering, database development, database engineering, software development, or comparable practical experience * Bachelor's degree * SQL skills across complex queries, views, stored procedures, and functions, together with relational design, normalization, and data modeling * Working expertise in Amazon Aurora (PostgreSQL-compatible), covering schema design, stored procedures and functions, and indexing * Experience with Amazon DynamoDB, covering data modeling and Global and Local Secondary Indexes (GSIs and LSIs) * Performance and query tuning that addresses slow queries through indexing and execution-plan work * Experience making logical data modeling and database-design decisions for assigned components within an established platform architecture * ETL and ELT development and data integration across AWS data services such as Aurora, DynamoDB, and S3 * Experience working within data security controls such as encryption, access management, and auditing * Experience loading data from S3 into the platform stores and connecting through Open Database Connectivity (ODBC) and Java Database Connectivity (JDBC) * Proficiency in writing, PowerPoint, and Excel Preferred * An AWS certification at the associate level, such as Developer Associate or Solutions Architect Associate * Experience tuning queries that involve locking and deadlocks * Familiarity with supporting cloud-native applications in AWS through continuous integration and continuous delivery (CI/CD) and development, security, and operations (DevSecOps) practices * Ownership of physical design for Aurora and DynamoDB schemas and indexes, or the drive to grow into it * Experience in federal information technology or high-volume transaction environments * Familiarity with AI-assisted developer tools Who you are You enjoy building with SQL and take responsibility for getting data right. You can take a database problem from design through delivery and stand behind how your work performs. You experiment, fail, learn, and repeat quickly. You would rather own an outcome than be handed a task., * Practical skill in query tuning against slow queries, indexing, and execution plans, together with data loading, connectivity, version control, and clean delivery. * Practical experience developing logical data models and database schemas, and making database-design decisions for assigned components within the established platform architecture. * The ability to own assigned database work from design through maintenance, working within data security controls, with sound judgment where accuracy and auditability are not optional. When we talk Be prepared to discuss a difficult problem you worked through, the decisions you made, what happened, and what you learned. ## Description Your first project will likely have you taking responsibility for the accuracy and performance of your assigned components. Depending on the assignment, you may: * Design database schemas, and write the views, stored procedures, functions, and Structured Query Language (SQL) queries that run on them. * Build and maintain data pipelines and extract, transform, and load (ETL) and extract, load, and transform (ELT) processes, including loads from Amazon Simple Storage Service (S3). * Make queries and databases fast enough for high-volume workloads. * Help model data across Amazon Web Services (AWS) stores such as Amazon Aurora (PostgreSQL-compatible), Amazon DynamoDB, and S3. * Keep data accurate and secure, with governed access and changes that can be audited. * Work out data access patterns and integrations with developers, architects, and data engineers. * Where the work allows, use artificial intelligence (AI)-assisted tools for query, pipeline, and troubleshooting work, and review and validate what they produce. You deliver database components accurate and fast enough that analysts and systems trust them. You automate the loads and checks that used to be run by hand, and you build models that keep working as the platform grows., * Solid SQL on a modern relational platform, Amazon Aurora (PostgreSQL-compatible), with stored procedures, functions, and views that hold up in use., You will work alongside developers, engineers, data scientists, architects, and strategists, on work ranging from strategy to implementation. We support your development across assignments and clients through extensive onboarding, sponsored professional certifications such as the Data Management Capability Assessment Model (DCAM) and AWS technical certifications, and rotation across functions to expand your skills and perspective. The mission is real, the problems are hard, and you own what you ship.