Software Engineer 3 (Data Transformation & Analytics) with Security Clearance

Cornerstone Defense LLC; Annapolis (MD); On-site; USD 190,000 - 210,000; Full time

Benefits offered by this job

Medical, Dental and Vision Plans

401(k)

HSA and FSA options

Life and Disability Insurance

Tuition Reimbursement and Training

Perks at Work Discount Program

Referral Program

Leads Generation Program

CollegeAmerica 529

Fitness Reimbursement Program

Travel Assistance

Norton Lifelock Benefit Solutions

Life Planning Financial & Legal Serv

Job summary

Cornerstone Defense LLC is seeking a Software Engineer 3 focused on Data Transformation & Analytics in Annapolis Junction, MD. You will design and optimize data pipelines using Apache Spark and Python, ensuring scalable processing for analytics workloads.

The role demands strong Linux/CLI, Bash scripting, and SQL across major databases. The ideal candidate has a Master’s or Bachelor’s degree in CS with several years of SWE experience, and familiarity with Airflow, JIRA/Confluence, and HPC tools

Qualifications

• Master's or Bachelor's degree in computer science or related discipline with related experience.
• Experience with Linux CLI and scripting for automation.
• Proficient in Python and Java development for data transformation workloads.
• Hands-on experience with distributed big data processing using Apache Spark.
• Proficient in Jupyter Notebook for exploratory data analysis.
• Comfort with data wrangling using pandas and NumPy on diverse data formats (Parquet, JSON, CSV, XML).
• Knowledge of data quality concepts, validation, and anomaly detection.
• Experience with Apache Airflow to orchestrate complex workflows.
• Strong SQL skills across MySQL, MariaDB, PostgreSQL.
• Familiarity with HPC scheduling tools like Slurm.
• Experience with Jira/Confluence tooling.

Responsibilities

• Design, implement, and optimize data ingress/egress pathways for analytics workloads.
• Develop data transformation pipelines and distributed processing using Spark.
• Automate data workflows using Bash, Python, and Airflow.
• Collaborate with data science and analytics teams to ensure scalable solutions.

Skills

Linux CLI

Bash scripting

Python

Java

Apache Spark

Jupyter Notebook

Pandas/NumPy

Parquet/JSON/CSV/XML

Data quality concepts

Anomaly detection

Git

SQL (MySQL/MariaDB/PostgreSQL)

HPC Slurm

JIRA/Confluence

Education

Master's degree in computer science or related discipline

Bachelor's degree in computer science or related discipline

9 years of SWE experience (equivalent)

Tools

Apache Airflow

JIRA

Confluence

Job description

Title: Software Engineer 3 (Data Transformation & Analytics) Location: Annapolis Junction, MD Compensation Range: $190 -$210K

• Clearance:
• Active TS/SCI w/ Polygraph needed to apply
• Company Overview: Cornerstone Defense is the Employer of Choice within the Intelligence, Defense, and Space communities of the U.S. Government. Realizing early on that our most prized assets are our employees, we continually focus our attention on improving the overall work/life experience they have supporting the mission. Our Team is pushed every day to use their industry leading knowledge to provide end-to-end solutions to combat our nation's toughest and most secure problems. If you are looking for a place to not only be professionally challenged, but encouraged and supported by a company that cares, don't look any further than Cornerstone Defense. Benefits Overview: Cornerstone Defense offers a very comprehensive benefits package including, but not limited to: Medical, Dental and Vision Plans
• Generous PTO Policy
• 401(k)
• HSA and FSA options
• Life and Disability Insurance
• Tuition Reimbursement and Training
• Perks at Work Discount Program
• Referral Program
• Leads Generation Program
• CollegeAmerica 529
• Fitness Reimbursement Program
• Travel Assistance
• Norton Lifelock Benefit Solutions
• Life Planning Financial & Legal Services
• Summary: The Software Engineer shall possess extensive expertise in dataflow design, data transport mechanisms, and Apache Spark based distributed processing. In this role, the Software Engineer will be responsible for designing, implementing, and optimizing data ingress and egress pathways to ensure efficient, scalable, and reliable processing of the organization's analytics workloads. Qualifications: Master's degree in computer science or related discipline from an accredited college or university, plus five (5) years of experience as a SWE, in programs and contracts of similar scope, type, and complexity. OR Bachelor's degree in computer science or related discipline from an accredited college or university, plus seven (7) years of experience as a SWE, in programs and contracts of similar scope, type, and complexity OR Nine (9) years of experience as a SWE, in programs and contracts of similar scope, type, and complexity. Required Skills:
• Experience using the Linux CLI and Linux tools
• Experience developing Bash scripts to automate manual processes
• Recent software development experience using Python and Java
• Experience with Distributed Big Data processing engines including Apache Spark
• Experience using Jupyter Notebook
• Experience with data wrangling and preprocessing using tools such as pandas, NumPy
• Experience working with structured, semi-structured, and unstructured data such as Parquet, JSON, CSV, XML
• Familiarity with data quality concepts, data validation, and anomaly detection
• Experience with Git Source Control System Desired Skills:
• Experience using Apache Airflow (DAG design, scheduling, operators, sensors) to orchestrate, schedule, and monitor complex workflows
• Experience with SQL technologies such as MySQL, MariaDB, and PostgreSQL for querying, joining, and aggregating large datasets
• Familiar with HPC Job Scheduling tools including Slurm
• Experience using the Atlassian Tool Suite (JIRA, Confluence)