Data Modellers

LDSS Corp; Dayton (OH); On-site; USD 95,000 - 135,000; Full time

Benefits offered by this job

Dental insurance

Health insurance

Health savings account

Life insurance

Tuition reimbursement

Flexible spending account

Job summary

LDSS Corp in Dayton, Ohio is seeking a skilled Data Engineer to join our team and drive data-driven transformation for federal programs. You will work with Databricks, Apache Spark, Python, AWS, and SharePoint while collaborating closely with SMEs and stakeholders.

Responsibilities include building ETL pipelines, data modeling, API integrations, and cross-system data exchanges. Strong communication and problem-solving are essential to support mission-critical operations.

Qualifications

• Bachelor’s degree in computer science, engineering or related field.
• Databricks, Spark, and cloud data engineering experience (2-3 years).
• SQL proficiency for querying relational data (4+ years).
• AWS cloud services including S3 (3+ years).
• Python for data analysis, cleansing, and visualization (4+ years).
• SharePoint lists/libs, Microsoft Graph, and 365 integration.
• APIs for data exchange between systems; Jira for agile tracking.
• Security clearance suitable for federal programs; relevant certifications.

Responsibilities

• Build and optimize ETL data pipelines using Databricks and Spark.
• Develop scalable data models using Spark DataFrames and Spark SQL.
• Use Python and regex for text parsing and data cleansing.
• Leverage APIs for cross-system data exchange and automation.
• Manage SharePoint data programmatically via Microsoft Graph.
• Utilize Microsoft 365 for documentation and collaboration.
• Develop and maintain AWS services including S3.
• Collaborate with SMEs and cross-functional teams to define data transformations.
• Track work with Jira and ensure timely delivery of data solutions.

Skills

Databricks

Apache Spark

Python

APIs

Data modeling

SQL

Jira

Stakeholder collaboration

Education

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

Tools

AWS (S3)

SharePoint

Microsoft Graph

Databricks Certified Data Engineer

AWS Certified Solutions Architect

Job description

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. Excellence – Dedicated to raising the bar of quality and performance

We are seeking a skilled, customer-focused Data Engineer with experience in Databricks, Apache Spark, Python, AWS, Microsoft 365, and SharePoint. 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

Qualifications

• Bachelor’s degree in computer science, engineering, or a related field
• 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
• 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
• 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
• AWS Certified Solutions Architect
• Databricks Certified Data Engineer
• S federal government security clearance

Benefits

• Dental insurance
• Flexible spending account
• Health insurance
• Health savings account
• Life insurance
• Tuition reimbursement