Data & Software Engineer

Avalore; Chantilly (VA); On-site; USD 120,000 - 180,000; Full time

Benefits offered by this job

Health insurance

401k

Life Insurance

Paid time off

Training & development

Employee assistance program

Job summary

Avalore is seeking a Data & Software Engineer to join a small team and build complex data flows for a custom application. The candidate will possess advanced Python skills, familiarity with Java, and experience delivering production data pipelines and ETL workflows at scale.

Responsibilities include orchestration, Spark jobs, containerized deployment in AWS, and working with MySQL/PostgreSQL/Trino, data catalogs and lineage. Bash scripting and AI/ML integration are a plus.

Qualifications

• 5+ years in data engineering or related field.
• Hands-on experience building end-to-end data pipelines with Python.
• Experience with Spark, PySpark, and orchestration tools like Airflow.
• Containerization and cloud deployment in AWS.
• Strong SQL skills (MySQL, PostgreSQL, Trino).
• Familiarity with NoSQL (DynamoDB) and data cataloging.

Responsibilities

• Design and implement data pipelines and ETL workflows.
• Collaborate with stakeholders to translate data requirements into scalable solutions.
• Identify and resolve data quality, performance, and reliability issues.
• Contribute to data engineering best practices and documentation.

Skills

Advanced Python

Java familiarity

Problem solving

Data security awareness

Tools

Docker

Podman

Apache Spark

PySpark

AWS (S3, Lambda, Step Functions)

SQL (Trino)

NoSQL (DynamoDB)

Airflow

Apache Iceberg

PostgreSQL

MySQL

Geospatial (PostGIS)

Terraform/CloudFormation

Apache Superset

OpenLineage

Unity Catalog OSS

H3

Job description

The 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. Candidate must have experience:

• Buildingend-to-end data pipelines leveraging Python
• Using orchestration tools to deploy data pipelines, including configuring and updating Spark Jobs
• Containerizingand deploying applications in cloud environments like AWS.
• Workingwith MySQL and PostgreSQL including performance tuning, schema design, and query optimization for complex, analytical workloads.
• Leveragingindustry standard tools for code control (Git, IaaCcontrol, etc.)
• Workingwith data catalogs, tracking data lineage andhandling a variety of data formats, including Geospatial.
• UsingBash scripting for automation and data processing tasks
• IntegratingAl/ML services and models

Responsibilities:

• Workwith stakeholders to understand data requirements, assess feasibility, and design appropriate solutions with minimal oversight
• Leveragestrong problem-solving and debugging skills for data quality issues, pipeline failures, and performance bottlenecks
• Leveragea background in large-scale data migration or platform modernization efforts
• Contribute to data engineering documentation, best practices, and design patterns.

Minimum of 5 years' experience with:

• ApacheSpark & PySpark
• AdvancedPython skills (including Pandas & NumPy)
• Docker, Podman
• AWSS3, Lambda & Step functions
• ApacheIceberg, Airflow, etc.
• SQL(with Trino)
• NoSQL, DynamoDB
• UnityCatalog OSS, Apache Polaris
• ApacheSuperset
• Terraformor CloudFormation
• OpenLineage
• H3, PostGIS

Eligibility requirements apply.

• Employer-Paid Health Care Plan (Medical, Dental & Vision)
• Retirement Plan (401k, IRA) with a generous matching program
• Life Insurance (Basic, Voluntary & AD&D)
• Paid Time Off (Vacation, Sick & Public Holidays)
• Short Term & Long Term Disability
• Training & Development
• Employee Assistance Program