Mid-Level SQL Developer

Mid-Level SQL DeveloperLocation: 3 days' hybrid on-site - Washington, District of Columbia 20036This role is officially a Mid-Level SQL Developer, but the work is heavily focused on ETL, data ingestion, and backend data pipeline processing rather than traditional application development. The team supports large-scale financial market data environments involving futures, commodities, and predictive trading data. They ingest high volumes of data received from external trading exchanges and reporting entities, transform and validate that data, and load it into SQL Server environments for downstream reporting and analytics.What the manager is really looking for:Strong SQL fundamentals including:JoinsStored ProceduresKeys/relationshipsData validation and quality checksData transformationsExperience working with backend data pipelines and data ingestion processesAbility to parse, map, and load data from structured files such as XML and CSVSome Python exposure is helpful, as portions of the loader and database transition processes are written in PythonETL or Data Engineering experience is a plus, but strong SQL development skills remain the priorityWhat is less important:Traditional front-end or application developmentDeep financial domain expertiseSpecialized XML technologies such as FIXML or FPML (general XML parsing experience is sufficient)Nice-to-Have Skills:AWS Cloud experienceRedshiftAWS GlueAWS LambdaETL/Data Engineering backgroundsThe manager specifically stated that candidates need to be true SQL Developers who understand joins, stored procedures, data validation, and how data moves through ingestion and transformation pipelines. Candidates with a Data Engineering background are absolutely acceptable if they possess solid SQL development experience.Role OverviewOur organization is seeking a mid-level SQL Developer to join our development, maintenance, and data engineering team. This role supports a key federal project by providing analyses, solutions, and maintenance for processes that handle financial market data. The position involves working with high-volume, mission-critical data ingest pipelines that are essential to the client's regulatory and analytical functions. This is a potential contract-to-hire opportunity, with a hybrid work model requiring up to three specific days onsite per week.Key ResponsibilitiesServe as a member of an Agile team to provide engineering support and maintenance for services and processes that migrate data and algorithms to a cloud environment.Design, code, test, and implement cloud-based solutions in SQL.Collaborate with the customer and internal team on requirements gathering and task estimation.Perform routine data checks, code development, and quality checks.Support database planning, design, and implementation.Support systems analysis, design, and implementation.Participate in code reviews and cloud deployments.Provide regular status updates on progress within the Agile framework and through weekly reporting.Required QualificationsA Bachelor's degree in computer science and 3 years of experience, or a High School Diploma or equivalent and 7 years of experience.Familiarity with tools such as AWS Cloud databases using SQL Server.Experience with Python and XML.Must be a US Citizen.Preferred QualificationsA Master's degree in business, finance, computer science, statistics, or a related field and 2 years of experience.Experience working in an Agile software development environment.Experience in ETL processes using AWS resources.Knowledge of industry XML data exchange message formats.Experience with XML, FIXML, or FPML.AWS developer experience.Experience in the financial industry.