Sr. 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 looking for a dedicated and dynamic Data Engineer to support theirs and their Federal Customers mission critical work in Washington, DC. The Data Engineer will support our Federal Government client, and will play a pivotal role in advancing the their mission to strengthen national security through enhanced collaboration with the private sector.

The contract is responsible for a broad range of technological and strategic responsibilities-from developing secure digital platforms and testing emerging technologies, to crafting impactful communication products and participating in Interagency working groups. By helping design innovative solutions that foster trust and engagement, you will contribute to our efforts to build resilient partnerships that protect the nation's people, infrastructure, and information.

Core Responsibilities (will include but not be limited to) :

• Design, implement, automate, and maintain Enterprise level of scalable Extract, Transform and Load (ETL) data ingestion and data analysis pipelines.
• Build robust data processing, enriching and analysis pipelines that aggregate and normalize large datasets across diverse sources, including sources from web services.
• Automate and optimize database and data workflows for best performance and efficiency.
• Identify and propose emerging technologies, automation, or alternative solutions to efficiently better support for developers and application stakeholders.
• Develop and maintain documentation, inline comments, confluence, and stand-alone documents, wherever necessary for the readability of the software design and code.
• Ensure the scheduling, processing, and documentation of data delivery and implementation, using automation when appropriate.
• A focus on producing results efficiently.

Requirements

• ACTIVE TOP-SECRET CLEARANCE
• Bachelor's degree in a quantitative field
• Minimum 10 years of relevant experience.
• Experience with designing, implementing, and maintaining big data processing, normalizing, and enriching pipelines in language such as Python, pySpark, or Spark.
• Experience with architecting, designing, and building modern medallion ETL processes for data lake, data warehouse or lakehouse.
• Experience with implementing automated data pipelines with Continuous Integration/Continuous Delivery (CI/CD).
• Experience with dataframe processing with filtering conditions.
• Experience with organizing data version history to optimize processing and retrieving performance.
• Experience with data indexing for robust searching and querying.
• Knowledge of PostgreSQL.
• Knowledge of automating data pipeline and workflow on Apache Niagra Files (NiFi) or Databricks for ease of maintenance.
• Strong verbal and written communication skills to effectively collaborate and integrate with enterprise partners and customers.
• Excellent at troubleshooting, debugging, and researching.
• Focus and have the desire to learn.
• Ability to work independently and coordinate with team members.

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:

• A 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 (of up to $5,000/year)
• Education Reimbursement/Training (of up to $2,500/year)

#cj