Data Engineer

Company Overview XPECT Solutions, LLC has built a strong reputation by supporting our clients in meeting their strategic goals and mission objectives. We provide high quality resources for a wide range of IT and security solutions at best‑value pricing. Our success is built on a solid foundation of well‑vetted, highly technical personnel, a disciplined project management approach, and an overarching commitment to customer service. We develop, test, deploy, and support exceptional solutions that enhance system functionality, while maximizing reliability and availability, and ensure the tightest security. Job Overview XPECT Solutions is seeking a Solutions Architect to support our Federal Government Customer with delivering secure, cloud‑based mission systems. The Architect will lead the design of scalable data platforms and processing pipelines, translating mission requirements into reference architectures that balance performance, cost, and security. This role spans the full solution lifecycle — from whiteboard design through implementation guidance — and partners closely with data engineering, DevSecOps, and security teams to ensure solutions meet federal compliance requirements (NIST 800-53, FedRAMP, DHS 4300A). The ideal candidate is technically hands‑on across Python, Spark/PySpark, and SQL, fluent in storage and compute optimization trade‑offs, and able to communicate architectural decisions clearly to both engineers and government stakeholders. As a Hybrid position, there is an onsite requirement of one day per week. Core Responsibilities Design end-to-end solution architectures for secure, cloud-based data platforms supporting federal mission workloads, including data ingestion, processing, storage, and analytics layers. Develop reference architectures, design patterns, and architectural decision records (ADRs) that guide engineering teams and ensure consistency across the program. Architect distributed data processing pipelines using Spark and PySpark, defining partitioning, caching, and resource strategies to optimize throughput and cost. Lead database design and data modeling efforts for relational and analytical workloads, including schema design, indexing strategy, and SQL performance tuning. Define storage and compute optimization strategies — tiering, right-sizing, autoscaling, and workload placement — to balance performance against budget constraints. Collaborate with DevSecOps to embed security and compliance controls (NIST 800-53, FedRAMP, DHS 4300A) into architectural designs and CI/CD workflows using GitHub, Jenkins/CloudBees, Ansible, Terraform, and Vault. Conduct architectural reviews, design trade‑off analyses, and proof‑of‑concept evaluations to validate solutions before full implementation. Produce architecture documentation, diagrams, and technical briefings tailored to engineering, security, and government stakeholder audiences. Provide technical leadership and mentorship to engineering teams, guiding implementation decisions and resolving complex design issues. Partner with program leadership to assess emerging technologies, evaluate vendor offerings, and recommend roadmap investments aligned to mission needs. Requirements Must be able to obtain Public Trust Level 6C. Six (6) years of Information Assurance experience. Experience with the following technologies: Python Spark PySpark SQL and Database Implementation Data Engineering and Data Pipelines Storage and Compute Optimization GitHub Jenkins/Cloudbees Ansible Terraform Vault Preferred Additional Skills and Qualifications Bachelor’s Degree in Computer Science or related field. Benefits XPECT Solutions, LLC is a one-of-a-kind employer with a talented team that is cleared at various levels and is certified in dozens of industry-recognized certifications. Our talented staff are the key to our success. They bring the knowledge, experience and technical skills to deliver the best solutions to our customers. We support our team by providing open communication, win‑win partnerships with clients and vendors, a team‑oriented culture, and a focus on professional development and growth for a long‑lasting and happy career. We offer a benefits package that is designed to keep our most important assets – our employees – healthy, happy, energized and moving forward. Our philosophy is simple – empower our employees with the benefits, resources and the financial incentives they need to be successful. Benefits and Perks: Competitive Medical, Dental, and Vision plan Retirement Savings Plan Life Insurance AD&D Insurance Short Term and Long Term Disability Insurance 3 weeks of annual PTO 11 days of Holiday PTO Performance Awards Referral Bonus Plan (up to $5,000/year) Education Reimbursement/Training (up to $2,500/year) #J-18808-Ljbffr