Data Engineer - Hybrid

Department: Contract DeliveryLocation: WPAFBCompensation: $120,000 - $135,000 / yearDescriptionCompany OverviewEstablished 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-thinkingCompassionate Teamwork – Respectful collaboration through self-awareness and mutual understandingIntegrity – Acting ethically and transparently while honoring commitmentsVersatility – Adaptive and anticipatory problem-solvingExcellence – Dedicated to raising the bar of quality and performanceSummaryThis is currently a remote position with participation twice year at an in-person workshop customer. 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 ResponsibilitiesBuild and optimize ETL data pipelines using Databricks and Apache SparkDevelop scalable data models leveraging Spark Data Frames and Spark SQL for efficient querying, aggregation, and integration against numerous diverse data sourcesUtilize Python and Regular Expressions for advanced text parsing, pattern matching, and data cleansing to prepare structured datasets for downstream [CM1] ingestionUse APIs for seamless data exchange and automation across systemsManage SharePoint data (lists, libraries, files, metadata) programmatically using Python and Microsoft Graph API[CM2]Leverage Microsoft 365 tools for documentation and collaborationDevelop and maintain Amazon Web Services (AWS) including S3Fully utilize the Microsoft 365 environment for cross-functional data sharing and productivityUse Jira to track and manage issues, tasks, and project workflowsCollaborate with cross-functional teams and technical stakeholders to define data transformations of legacy systems to modern schemasLeverage SME collaboration to interpret business rules and build business logic into data extracts and transformation processesBuild and maintain strong working relationships with SME’s, helping to identify requirements for data transformations based upon iterative product feedbackSkills, Knowledge and ExpertiseEducation:Bachelor’s degree in computer science, engineering, or a related fieldTechnical 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 GraphMicrosoft 365 apps and integration workflowsDeveloping and consuming APIs for data exchange between different systemsJira or other agile workflow management systems for issue and project trackingRelationship Management and Teamwork:Proven ability to build trust and maintain strong partnerships with customers and stakeholdersTakes initiative and drives projects forward with minimal supervision, anticipating challenges before they ariseMeticulous in managing complex tasks and deadlines, ensuring accuracy and consistency across deliverablesThrives in cross-functional environments, fostering open communication and teamwork across diverse groupsRapidly assimilates new technologies and processes, adapting to evolving requirements in dynamic settingsAbility to work collaboratively with a diverse team of contractors and government personnelAbility to work collaboratively with a diverse team of contractors, government personnel, and stakeholders from multiple organizationsSkilled in building strong customer relationships and engaging with Subject Matter Experts (SMEs) to derive business logic for data transformation methods and rulesPreferred Licenses/Certifications:AWS Certified Solutions ArchitectDatabricks Certified Data EngineerU.S federal government security clearanceBenefits401(k)401(k) matchingDental insuranceFlexible spending accountHealth insuranceHealth savings accountLife insurancePaid time offReferral programTuition reimbursementVision insurance