Data & Software Engineer

Data & Software EngineerThe Data & Software Engineer works with a small team to build complex data flows for a custom application. Successful candidate will have advanced Python programming skills, familiarity with Java, an understanding of data security, privacy, governance and compliance principles and a demonstrated history of building production data pipelines and ETL workflows at scale. The candidate must have experience:Building end-to-end data pipelines leveraging Python.Using orchestration tools to deploy data pipelines, including configuring and updating Spark Jobs.Containerizing and deploying applications in cloud environments like AWS.Working with MySQL and PostgreSQL including performance tuning, schema design, and query optimization for complex, analytical workloads.Leveraging industry standard tools for code control (Git, IaaC control, etc.).Working with data catalogs, tracking data lineage and handling a variety of data formats, including Geospatial.Using Bash scripting for automation and data processing tasks.Integrating Al/ML services and models.ResponsibilitiesWork with stakeholders to understand data requirements, assess feasibility, and design appropriate solutions with minimal oversight.Leverage strong problem-solving and debugging skills for data quality issues, pipeline failures, and performance bottlenecks.Leverage a background in large-scale data migration or platform modernization efforts.Contribute to data engineering documentation, best practices, and design patterns.RequirementsTS/SCI FSP ClearanceMinimum of 5 years' experience:Demonstrated experience building production data pipelines and ETL/EL workflows at scaleProficiency with Apache Spark and PySpark for distributed data processingAdvanced Python programming skills including data manipulation libraries (Pandas, NumPy) and data engineering best practicesUnderstanding of data security, privacy, governance, and compliance principlesExperience with workflow orchestration tools (such as Step Functions, Airflow)Familiarity with containerization (such as Docker or Podman) and deploying data applications in cloud environmentsExperience with AWS services (S3, Lambda, Step Functions)Experience with PostgreSQL and MySQL in production environments, including performance tuning and schema designDemonstrated experience with SQL and query optimization for complex analytical workloadsExperience with version control (Git) and Cl/CD practices for data pipelinesDemonstrated ability to work with stakeholders to understand data requirements, assess feasibility, and design appropriate solutions with minimal oversightStrong problem-solving and debugging skills for data quality issues, pipeline failures, and performance bottlenecksHighly Desired SkillsExperience with data Lakehouse architecture using Apache IcebergHands-on experience configuring, deploying, and integrating data platform components:Apache Ranger (access control and data governance)Trino (distributed SQL query engine)Data catalogs (Unity Catalog OSS, Apache Polaris, etc.)Apache Superset {data visualization and dashboarding)Proficiency with Bash scripting for automation and data processing tasksExperience with Infrastructure as Code (Terraform or CloudFormation) for data infrastructureFamiliarity or experience with tracking data lineage and associated tooling such as Open lineageFamiliarity or experience with JavaFamiliarity with data quality frameworks, testing methodologies, and validation strategiesBackground with large-scale data migrations or platform modernization effortsExperience integrating Al/ML services and models (translation, OCR, speech-to-text, NLP, language detection, topic modeling), LLMs, and RAG {retrieval-augmented generation) pipelinesFamiliarity with geospatial data processing {H3, PostGIS, or similar)Contributions to data engineering documentation, best practices, and design patternsExperience with NoSQL databases (DynamoDB, etc.)About Us For more than 20 years, NewGen Technologies has solved our clients' toughest IT challenges with integrity, security, and outstanding service by delivering both technology and talent. We have helped secure borders, have used artificial intelligence (AI) to fight terror, aided the identification of criminals, and have helped to prevent crime through the introduction of biometrics. Our team of Highly Cleared Specialists have hard-to-find skills and expertise in a wide spectrum of technologies to provide solutions that transform business processes and solve problems of national significance. #CJ