Data Engineer​/Developer – Python & SQL

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.

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.
• 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.

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,…