DataJobs.io
← Back to all jobs

Job Description

The Data Engineer role at Silverthorne Advisory Group LLC supports Defense sector initiatives by designing and maintaining data infrastructure and engineering solutions within the Advana environment. The position involves building scalable data pipelines, integrating complex datasets, and delivering reliable analytics workflows, with Palantir Foundry experience highly preferred.

Key Responsibilities

  • Design, develop, and maintain end-to-end data pipelines using ETL processes and technologies including Databricks, Python, Spark, Scala, SQL, JavaScript/JSON, and Jupyter Notebooks.
  • Build and optimize data pipelines from scratch, focusing on scalability, reliability, efficiency, and high performance.
  • Support data engineering and integration activities within the Advana platform.
  • Use Palantir Foundry, when applicable, to support data integration, transformation, pipeline development, and analytics workflows.
  • Conduct data cleansing, integration, transformation, and quality assurance to maintain accurate, reliable datasets.
  • Process and analyze large, complex datasets using big data technologies.
  • Troubleshoot data pipeline issues, determine root causes, and implement effective technical solutions.
  • Develop and maintain data models, database structures, and data architectures to meet business and analytical needs.
  • Implement data governance standards, security controls, and best practices aligned with federal requirements.
  • Collaborate with data scientists, analysts, engineers, and stakeholders to deliver dependable data solutions.
  • Maintain technical documentation for data pipelines, applications, workflows, and processes.
  • Evaluate emerging data engineering technologies and recommend improvements to existing systems.

Required Qualifications

  • Secret security clearance or higher required; sponsorship may be available.
  • Hands-on experience developing ETL pipelines and working with large datasets.
  • Proficiency with data engineering technologies, including Databricks.
  • Proficiency with data engineering technologies, including Python.
  • Proficiency with data engineering technologies, including Apache Spark / PySpark.
  • Proficiency with data engineering technologies, including SQL.
  • Proficiency with data engineering technologies, including Scala.
  • Proficiency with data engineering technologies, including JavaScript / JSON.
  • Proficiency with data engineering technologies, including Jupyter Notebooks.
  • Experience designing, developing, and optimizing data pipelines from scratch.
  • Strong understanding of data modeling, database design, data integration, and data governance.
  • Experience working with big data technologies and complex data environments.
  • Strong analytical, troubleshooting, and problem-solving skills.
  • Excellent communication and collaboration skills.
  • Ability to work independently and collaboratively in a fast-paced technical environment.
  • Strong attention to detail and commitment to delivering high-quality solutions.

Highly Preferred Qualifications

  • Hands-on experience with Palantir Foundry, including data pipelines, data integration, transformations, and data modeling.
  • Experience working within the Advana data environment.
  • Previous experience supporting Department of Defense (DoD) or other federal government agencies.
  • Familiarity with Palantir Foundry tools such as Pipeline Builder, Code Repositories, and Ontology.
  • Experience with cloud-based data platforms and enterprise data architectures.
  • Understanding of federal financial management data, reporting, or analytics environments.
  • Experience supporting business intelligence and data visualization platforms such as Power BI or Qlik Sense.

Technology Stack

  • Advana, Palantir Foundry, ETL
  • Databricks, Python, Apache Spark, PySpark, Spark
  • Scala, SQL, JavaScript, JSON
  • Jupyter Notebooks
  • Power BI, Qlik Sense

Compensation & Employment Details

  • Salary: USD 120,000 - 140,000 per year
  • Location: Washington, D.C. (hybrid)
  • Work arrangement: On-site/Hybrid, 2-days a week
  • Employment type: Full-Time/Salaried
  • Industry: Federal Government / Department of Defense (DoD)
  • Experience level: All Levels

Benefits

  • Competitive Compensation: Salary determined based on experience, qualifications, technical expertise, location, and other applicable factors.
  • Healthcare Benefits: Comprehensive medical, dental, and vision insurance plans for employees and their families.
  • 401(k) Retirement Plan: 100% company match on employee contributions up to the first 6%, with access to Vanguard Admiral funds.
  • Paid Time Off: Generous paid leave based on length of service.
  • Performance Bonuses: Bonus opportunities for employees who meet and exceed performance goals.
  • Professional Development: Opportunities for training, certifications, and career advancement.
  • Company Retreats & Team Events: Sponsored trips, team-building activities, and professional conferences.

Flexible work from home options are available.

Similar Jobs