Junior Data Engineer
Job Description
BigBear.ai is seeking a motivated Junior Data Engineer to support data pipeline development, database integrations, and data quality for government and national security missions.
Responsibilities
- Assist with developing, maintaining, and improving data pipelines and ETL workflows to ingest, transform, validate, and deliver data from multiple source systems
- Write, maintain, and optimize SQL queries for retrieval, transformation, validation, and analysis across relational databases
- Support data integration by connecting source systems, developing data imports, and helping automate recurring data transfers and reporting activities
- Execute data quality checks, audits, and reconciliations to detect inconsistencies, improve accuracy, and maintain data integrity
- Support database development and maintenance, including schema documentation, query optimization, data organization, and performance monitoring
- Assist with cloud-based data engineering and integration efforts using AWS, Databricks, and other approved enterprise data platforms
- Develop and maintain data documentation assets such as data dictionaries, technical documentation, dataflow diagrams, and standard operating procedures
- Support metadata and data inventory management to improve data governance, traceability, and standardization across systems
- Assist in building and maintaining reports, dashboards, and data products that support technical teams and leadership
- Support secure data access and handling, including user permissions, access controls, and protection of sensitive information
- Collaborate with software developers, data analysts, and cross-functional teams to troubleshoot data issues and deliver incremental improvements using Agile practices
- Contribute to process automation and continuous improvement initiatives to reduce manual effort and increase confidence in enterprise data processing
Requirements
- Must be eligible to obtain and maintain a Secret security clearance
- Bachelor’s degree in Computer Science, Information Systems, Engineering, Data Analytics, Accounting, or a related field, or equivalent relevant professional experience
- 3–5 years of relevant experience in data analysis, data engineering, database support, ETL development, reporting, or data integration
- Working knowledge of SQL and relational databases, including ability to write queries and retrieve, manipulate, and validate data
- Familiarity with data imports, ETL processes, data transformations, or integrations between multiple source systems
- Experience performing data validation, quality assurance, auditing, reconciliation, or similar activities to improve accuracy and reliability
- Basic understanding of database structures, data relationships, query performance, and data management principles
- Strong analytical and problem-solving skills with high attention to detail for investigating and resolving data discrepancies
- Ability to document technical processes, communicate findings clearly, and collaborate with technical and nontechnical stakeholders
- Ability to work in a team environment, learn new tools and technologies, and support multiple data-related priorities
Technologies
- SQL
- AWS
- Databricks
- Microsoft SQL Server
- Power BI
- Tableau
- SQL Server Reporting Services (SSRS)
- Python
- R
What we’d like you to have
- Exposure to AWS, Databricks, or other cloud-based data platforms
- Experience with Microsoft SQL Server, Databricks, or other relational database technologies
- Familiarity with data governance, metadata management, data inventories, data dictionaries, or data cataloging
- Experience with Power BI, Tableau, SQL Server Reporting Services (SSRS), or other reporting and visualization tools
- Familiarity with Python, R, or scripting used to support data processing and automation
- Experience integrating data across enterprise applications, databases, file transfers, or external data sources
- Understanding of data security, access management, regulatory compliance, or handling sensitive information
- Exposure to Agile software development, IT service management, or collaborative development environments
- Interest in supporting government, defense, critical infrastructure, or other mission-focused data environments
Location: Norfolk, VA (onsite)