Data Engineer

Transition Careers, LLC; Dayton (OH); Híbrido; USD 110 000 - 150 000; Tempo integral

Resumo da oferta

LDSS in Dayton, OH is hiring a Data Engineer to support DoD-grade data solutions for the Air Force MRO program. The role blends Databricks, Spark, Python, SQL, and AWS in a hybrid setting with occasional in-person program meetings.

Ideal candidates understand supply chain logistics and have DoD experience. Strong collaboration with SMEs and cross-functional teams will drive data transformations across legacy systems to modern schemas.

Qualificações

• U.S. citizenship and ability to obtain/maintain a U.S. Government Secret clearance.
• Bachelor’s degree in computer science, engineering, or a related field.
• Databricks, Spark experience; 2–3 years preferred.
• SQL proficiency; 4 years preferred.
• AWS including S3; 3 years preferred.
• Python for data analysis and workflows; 4 years preferred.
• Experience with SharePoint lists/docs and Microsoft Graph.
• Microsoft 365 apps and integration workflows.
• APIs for data exchange across systems.
• Jira or similar agile tool for project tracking.

Responsabilidades

• Build and optimize ETL data pipelines using Databricks and Spark.
• Develop scalable data models using Spark DataFrames/SQL for diverse sources.
• Use Python and regex for data cleansing and structuring datasets.
• Leverage APIs for data exchange and automation across systems.
• Manage SharePoint data and Microsoft Graph interactions.
• Utilize Microsoft 365 for documentation and collaboration.
• Develop and maintain AWS components including S3.
• Collaborate with cross-functional teams to transform legacy data.
• Work with SMEs to interpret business rules and implement data logic.
• Track work in Jira and ensure timely delivery.

Conhecimentos

Databricks

Apache Spark

SQL

Python

AWS

SharePoint

Microsoft Graph

Jira

APIs

Data Modeling

ETL Pipelines

Formação académica

Bachelor’s degree in CS/engineering

Ferramentas

Microsoft 365

S3

Descrição da oferta de emprego

Company Overview

Established in 2006, LDSS is a Woman-Owned Small Business (WOSB) based in Dayton, Ohio, with 20 years of proven success delivering high-impact solutions and services to federal agencies. LDSS is unwavering in its commitment to quality, collaboration, and delivering measurable outcomes that foster long-term success. Our thriving culture is powered by our A.C.T.I.V.E. core values:

• Attitude – Optimistic, hopeful, and forward-thinking
• Compassionate Teamwork – Respectful collaboration through self-awareness and mutual understanding
• Integrity – Acting ethically and transparently while honoring commitments
• Versatility – Adaptive and anticipatory problem-solving
• Excellence – Dedicated to raising the bar of quality and performance

Summary

This is a hybrid position that includes in-person participation in program meetings occasionally during the year. We are seeking a skilled, customer-focused Data Engineer with experience in Databricks, Apache Spark, Python, AWS, Microsoft 365, and SharePoint. Ideal candidates will have a solid grasp of supply chain logistics and prior Department of Defense experience. This position supports the Air Force’s Maintenance, Repair, and Overhaul (MRO) program to streamline depot-level operations across the Air Force Sustainment Center. If you're passionate about data-driven transformation and ready to support mission-critical operations, we'd love to hear from you.

Key Responsibilities

• Build and optimize ETL data pipelines using Databricks and Apache Spark
• Develop scalable data models leveraging Spark Data Frames and Spark SQL for efficient querying, aggregation, and integration against numerous diverse data sources
• Utilize Python and Regular Expressions for advanced text parsing, pattern matching, and data cleansing to prepare structured datasets for downstream [CM1] ingestion
• Use APIs for seamless data exchange and automation across systems
• Manage SharePoint data (lists, libraries, files, metadata) programmatically using Python and Microsoft Graph API[CM2]
• Leverage Microsoft 365 tools for documentation and collaboration
• Develop and maintain Amazon Web Services (AWS) including S3
• Fully utilize the Microsoft 365 environment for cross-functional data sharing and productivity
• Use Jira to track and manage issues, tasks, and project workflows
• Collaborate with cross-functional teams and technical stakeholders to define data transformations of legacy systems to modern schemas
• Leverage SME collaboration to interpret business rules and build business logic into data extracts and transformation processes
• Build and maintain strong working relationships with SME’s, helping to identify requirements for data transformations based upon iterative product feedback

Required Skills, Knowledge and Abilities

Employment Eligibility Requirements

• U.S. citizenship and eligibility to obtain and maintain a U.S. Government Secret security clearance are required.

Education:

• Bachelor’s degree in computer science, engineering, or a related field

Technical skills, hands-on experience and proficiency with:

• Databricks, Apache Spark, and cloud-based data engineering and modeling (2-3 years preferred)
• SQL for querying and managing relational data (4 years preferred)
• AWS cloud services, including S3 (3 years preferred)
• Python for data analysis, cleansing, and visualization (4 years preferred)
• SharePoint lists, document libraries, and Microsoft Graph
• Microsoft 365 apps and integration workflows
• Developing and consuming APIs for data exchange between different systems
• Jira or other agile workflow management systems for issue and project tracking

Relationship Management and Teamwork:

• Proven ability to build trust and maintain strong partnerships with customers and stakeholders
• Takes initiative and drives projects forward with minimal supervision, anticipating challenges before they arise
• Meticulous in managing complex tasks and deadlines, ensuring accuracy and consistency across deliverables
• Thrives in cross-functional environments, fostering open communication and teamwork across diverse groups
• Rapidly assimilates new technologies and processes, adapting to evolving requirements in dynamic settings
• Ability to work collaboratively with a diverse team of contractors and government personnel
• Ability to work collaboratively with a diverse team of contractors, government personnel, and stakeholders from multiple organizations
• Skilled in building strong customer relationships and engaging with Subject Matter Experts (SMEs) to derive business logic for data transformation methods and rules

Preferred Licenses/Certifications:

• AWS Certified Solutions Architect
• Databricks Certified Data Engineer
• U.S federal government security clearance

Benefits

• 401(k)
• 401(k) matching
• Dental insurance
• Flexible spending account
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Referral program
• Tuition reimbursement
• Vision insurance