Data Engineer / Developer – Python & SQL

Brite Consulting; San Antonio (TX); Hybrid; USD 100,000 - 140,000; Full time

Job summary

Brite Consulting is seeking a technically strong Data Engineer/Developer to support modernization of data solutions in a federal financial management environment. You will work with SQL, Python, ETL, data pipelines, and complex enterprise datasets to design reliable, scalable data products for analytics and reporting.

The role requires strong collaboration with data engineers, analysts, SMEs, and stakeholders, and adherence to best practices across data pipelines, transformations, and

Qualifications

• 3+ years in data engineering or related technical fields.
• Strong SQL skills with complex joins and transformations.
• Hands-on Python development and data pipeline experience.
• Experience building automated data processes and data integration.
• Understanding of data modeling, transformation, and quality concepts.
• Experience with large enterprise datasets and troubleshooting.

Responsibilities

• Design, develop, test, and maintain scalable data solutions for enterprise processes.
• Build and maintain ETL/ELT pipelines and automated data transformations.
• Use SQL and Python to integrate, transform, validate, and analyze data.
• Implement reconciliation logic, transformations, and business rules.
• Develop reusable code for automated data processes and data quality controls.
• Integrate data from multiple sources into trusted analytics datasets.
• Identify discrepancies and data-quality issues across systems.
• Document pipelines, mappings, dependencies, and governance aspects.
• Support migration to modern data-platform solutions and Databricks environments.
• Collaborate with stakeholders to translate requirements into technical solutions.

Skills

SQL

Python

ETL development

Data pipelines

Data modeling

Data quality

Analytical skills

Communication

Security clearance

Education

Bachelor's degree

Tools

Databricks

PySpark

Spark SQL

Snowflake

Power BI

Tableau

Qlik

Git

Unity Catalog

Job 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.
• 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, aggregations, and working with relational data.
• Hands-on development experience with Python or another relevant programming or 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.
• 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.

Preferred Skills:

• 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 working within the War Data Platform (WDP) or another Department of Defense data environment.
• Experience supporting DoD, DHA, or another federal financial management organization.
• Experience supporting financial, accounting, budget execution, acquisition, contract, invoice, operational, logistics, healthcare, or other federal government datasets.
• Experience developing solutions requiring strong data lineage, auditability, governance, and traceability.
• Experience helping teams transition from legacy or manual reporting processes to modern data platforms.
• Databricks certification, such as Databricks Certified Data Engineer Associate or Professional, is a plus.

Location:

• Hybrid, based on client requirements.

Travel Required:

• Minimal

Hours:

• 8:00 AM – 5:00 PM

Minimum Required Years of Experience:

• 3+ years of relevant professional experience, including hands-on data engineering, software development, ETL development, data integration, or similar technical work.

Education Requirements:

• Bachelor's degree in Computer Science, Information Systems, Data Science, Engineering, Mathematics, Statistics, or a related technical field. Relevant professional experience may be considered in place of a degree.

Security Clearance/Investigation:

• T-3 Investigation/Tier II or ability to obtain the required government background investigation.