Data Engineer – Python & SQL for Modern Data Platforms

Brite Consulting; Washington (District of Columbia, MD); Hybrid; USD 110,000 - 160,000; Full time

Job summary

Brite Consulting is seeking a technically strong Data Engineer/Developer to support modernization of data solutions within a federal financial management environment. The role focuses on SQL, Python, data pipelines, data transformation, and complex enterprise datasets, with collaboration across engineers, analysts, SMEs, and stakeholders.

The position emphasizes designing scalable data platforms, building automated processes, and delivering trusted data products for downstream analytics and

Qualifications

• 3+ years of experience in data engineering, software development, analytics engineering, ETL development, data integration, or a related technical field.
• Strong proficiency in SQL, including complex joins, transformations, aggregations, and working with relational data.
• Hands-on development experience with Python or another relevant programming language.
• Experience building and maintaining data pipelines, integrations, automated data processes, or backend data solutions.
• Strong understanding of relational data, data transformation, data modeling, and data-quality concepts.
• Experience working with large and complex enterprise datasets.
• Ability to troubleshoot code, data pipelines, transformations, and data-quality issues.
• Demonstrated ability to assess an existing data environment and help determine an appropriate technical solution or architecture.
• Experience gathering technical requirements and translating business needs into technical solutions.
• Ability to learn unfamiliar technologies, platforms, and development environments quickly.
• Strong analytical, troubleshooting, and root-cause analysis capabilities.
• Strong communication and collaboration skills.
• Ability to work independently while supporting a larger development team.
• Must be able to pass a government security background check.
• Authorization to work in the United States is required; visa sponsorship is not available at this time.

Responsibilities

• Design, develop, test, and maintain scalable data solutions supporting enterprise financial and operational processes.
• Build and maintain ETL/ELT pipelines, integrations, and automated data transformation processes.
• Use SQL and Python or similar technologies to integrate, transform, validate, and analyze complex datasets.
• Perform complex joins, aggregations, transformations, reconciliation logic, and business‑rule implementation.
• Develop reusable and maintainable code supporting automated data processes.
• Integrate data from multiple enterprise data sources into consolidated and trusted analytical datasets.
• Analyze and reconcile data across multiple systems to identify discrepancies, missing data, business‑rule issues, and data‑quality concerns.
• Develop automated data validation and quality‑control processes to ensure outputs are accurate, complete, reliable, and traceable.
• Troubleshoot data pipeline failures, code issues, performance problems, and complex data‑quality concerns.
• Develop data models and curated datasets to support downstream reporting, analytics, and decision‑making.
• Support migration of existing reporting and analytical processes into more automated and scalable modern data‑platform solutions.
• Collaborate with business stakeholders and functional SMEs to understand requirements and translate them into technical solutions.
• Support development and modernization efforts within Databricks and the War Data Platform (WDP) environment.
• Support downstream reporting and visualization solutions using Qlik, Tableau, Power BI, or similar platforms.
• Document data pipelines, transformation logic, source‑to‑target mappings, dependencies, business rules, and technical processes.
• Follow development standards and best practices for source control, testing, deployment, code review, and maintainability.
• Communicate technical issues, risks, dependencies, and recommendations clearly to technical and non‑technical stakeholders.

Skills

SQL

Python

ETL development

Data integration

Data modeling

Troubleshooting

Analytical skills

Communication

Education

Bachelor's degree in Computer Science, Information Systems, Data Science, Engineering, Mathematics, Statistics, or a related technical field

Tools

Databricks

PySpark

Apache Spark

Spark SQL

Databricks SQL

Palantir Foundry

Snowflake

Azure data services

AWS

Delta Lake

Job description

Brite Consulting is seeking a technically strong Data Engineer/Developer to support modernization of data solutions within a federal financial management environment. The role focuses on SQL, Python, data pipelines, data transformation, and complex enterprise datasets, with collaboration across engineers, analysts, SMEs, and stakeholders.

The position emphasizes designing scalable data platforms, building automated processes, and delivering trusted data products for downstream analytics and