Data Engineer / Developer – Python & SQL
Builds and maintains ETL/ELT data pipelines and trusted analytical datasets with SQL and Python for a federal financial-management client, including modernization work in Databricks and the War Data Platform, with downstream BI reporting in Qlik/Tableau/Power BI. Hybrid role based in Washington, US.
- Compensation
- Not disclosed
- Location
- Washington, United States
- Work setup
- Not specified
- Seniority
- Not specified
- Employment
- Contract
- Experience
- 3+ years
- Category
- Data engineering
- Posted
Skills
Must have
- 3+ years of experience in data engineering, software development, analytics engineering, ETL development, data integration, or related technical field
- Strong proficiency in SQL, including complex joins, transformations, aggregations, and relational data
- Hands-on development experience with Python or another relevant programming/data-development 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
- Ability to assess an existing data environment and 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
- Must be able to pass a government security background check
- Authorization to work in the United States required; visa sponsorship not available
- Bachelor's degree in Computer Science, Information Systems, Data Science, Engineering, Mathematics, Statistics, or related field (relevant experience may substitute)
Nice to have
- Experience developing data solutions in Databricks
- Experience with PySpark, Apache Spark, Spark SQL, or Databricks SQL
- Experience with Palantir Foundry, Snowflake, Azure data services, AWS, or another modern cloud data platform
- Experience with Delta Lake, data lakes, data warehouses, or lakehouse architecture
- Experience implementing Bronze, Silver, and Gold data architectures
- Experience with Databricks notebooks, jobs, workflows, or Lakeflow Jobs
- Familiarity with Unity Catalog, data governance, permissions, and lineage
- Experience with Git-based version control, collaborative development, testing, and CI/CD practices
- Experience integrating data products with Qlik, Tableau, Power BI, or other BI platforms
- Previous experience within the War Data Platform (WDP) or another DoD data environment
- Experience supporting DoD, DHA, or another federal financial management organization
- Experience supporting financial, accounting, budget execution, acquisition, or other federal government datasets
- Experience with strong data lineage, auditability, governance, and traceability
- Databricks certification (Certified Data Engineer Associate or Professional) is a plus
Full description
Brite Consulting is a management and technology consulting firm dedicated to delivering value-added services that impact the public and private sectors. We work closely with our clients to optimize their operational needs and provide innovative solutions that help them achieve their missions.
Scroll down the page to see all associated job requirements, and any responsibilities successful candidates can expect.
We are a small business with a big heart. We are passionate about helping our clients succeed, and we are committed to providing the highest quality of service. Join us in building a brighter future.
Job Overview:
We are seeking a technically strong Data Engineer / Developer to support the continued development and modernization of data solutions within a complex federal financial management environment.
The ideal candidate will have strong hands-on experience working with SQL, Python or similar development technologies, data pipelines, data transformation, and complex enterprise datasets. This individual will serve as a key technical resource helping the team understand data requirements, design and build scalable solutions, troubleshoot technical and data-quality issues, and develop trusted data products for downstream analytics and reporting.
The successful candidate should be comfortable working through ambiguous data challenges, evaluating existing data sources and processes, recommending a technical path forward, and then building the solution. The developer will work closely with data engineers, analysts, functional SMEs, developers, and business stakeholders to translate requirements into reliable, maintainable, and efficient solutions.
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.