Data Engineer / Developer – Python & SQL
Data engineer/developer at a consulting firm supporting a federal financial management environment: building and maintaining ETL/ELT pipelines, transformations, and validated data products with SQL and Python, largely in Databricks, feeding BI reporting (Qlik/Tableau/Power BI). Hybrid US role requiring a government background check; no visa sponsorship.
- Compensation
- Not disclosed
- Location
- United States
- Work setup
- Not specified
- Seniority
- Not specified
- Employment
- Contract
- Experience
- 3+ years
- Category
- Data engineering
- Posted
Skills
Must have
- 3+ years in data engineering, software development, analytics engineering, ETL development, or data integration
- Strong SQL proficiency including complex joins, transformations, aggregations, relational data
- Hands-on Python or similar development language experience
- Experience building and maintaining data pipelines, integrations, or automated data processes
- Understanding of relational data, data transformation, data modeling, and data-quality concepts
- Experience with large, complex enterprise datasets
- Ability to troubleshoot code, pipelines, transformations, and data-quality issues
- Ability to assess an existing data environment and recommend a technical solution or architecture
- Gather technical requirements and translate business needs into technical solutions
- Strong communication and collaboration skills
- Must pass a government security background check (T-3 Investigation/Tier II or ability to obtain)
- US work authorization required; visa sponsorship not available
- Bachelor's degree in CS, Information Systems, Data Science, Engineering, Math, Statistics, or related (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 cloud data platform
- Experience with Delta Lake, data lakes, warehouses, or lakehouse architecture (Bronze/Silver/Gold)
- Experience with Databricks notebooks, jobs, workflows, or Lakeflow Jobs
- Familiarity with Unity Catalog, data governance, permissions, and lineage
- Git-based version control, collaborative development, testing, and CI/CD practices
- Integrating data products with Qlik, Tableau, Power BI, or other BI platforms
- Prior experience with the War Data Platform (WDP) or another DoD data environment
- Experience supporting DoD, DHA, or federal financial management organizations and datasets
- Experience with data lineage, auditability, governance, and traceability requirements
- Experience migrating legacy/manual reporting to modern data platforms
- Databricks certification (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.
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.