Senior Data Engineer

Senior Data EngineerLocation: Washington, DC (Hybrid - 3 days onsite 2 days remote) Duration: 6 - 12 MonthsResponsibilities:Develop new datasets to support loan fraud identification, audits, and investigations.Optimizes the performance of common queries in the database.Creates and implements data models to improve the efficiency and utility of the database.Proposes and implements architectural improvements to reduce cloud costs.Develops, optimizes, and maintains ELT/ETL pipelines.Monitors pipelines to ensure performance and regular updating of datasets.Works with a Cloud Architect to develop new ways of accessing and transporting data.Aids in the development of dashboards or reports to visualize data and storytelling.Assists in ingestion, transformation, and configuration of data in cloud-based data lake or data warehouse.Assists with exploration, structuring, and analysis of unstructured and semi structured data from SQL and data lake environments.Required Qualification:Bachelor's degree in data engineering, computer science, data science, machine learning, mathematics, or a related field; OR 5 years of applied work experience in any of the same fields.Five (5) years of hands-on experience in each of the following:Maintaining SQL databases and conducting advanced operations in SQL and TSQL.Designing, implementing, and maintaining ELT/ETL processes in cloud-based data analytics environments.Three (3) years of hands-on experience in each of the following:Working in Azure Synapse and Azure Machine Learning, with the modern data stack. Certifications preferred (DP-203 or equivalent).Manipulating data in Python / Pandas required / PySpark/Polars preferred.Experience developing reusable, modular code preferred.Preferred experience for the Data Engineer includes the following:Implementing pipelines and infrastructure using code-first approaches (Python SDK, CLI, REST APIs, or IaC tooling).Implementing source control and CI/CD workflows.Demonstrated familiarity with AI coding assistants and LLM integration patterns.