Data Connections Engineer
Orchard LLC

Data Connections Engineer

Must hold an active Secret Clearance
Arlington or Alexandria Virginia - Hybrid Work
@Orchard is working with a fast-growing Service-Disabled Veteran-owned Small Business (SDVOSB) focused on delivering solutions to the US Government in Data Analytics, Change Management, and Audit Readiness. Our client has multiple prime and large sub-contract opportunities for Data Engineers at all levels that require the individual with an active Secret clearance to support areas of the DOD and DHS (several roles require Top Secret clearance). Our client offers tremendous growth opportunities and will be able to allow team members to build their careers by moving across different engagements and developing their skills both technically and as client-facing leaders.

• Does the idea of using data to justify the adoption of business transformation excite you?
• Do you enjoy partnering with decision-makers to understand data insights and develop solutions that help them better control costs, ensure basic accountability, anticipate the future, measure performance, and maintain optimal operations?

Our client supports the DOD under the Under-Secretary for Acquisition and Sustainment, Acquisition Data and Analytics Division as they utilize ADVANA, the primary DOD tool for data analytics to make data discoverable, understandable, and usable for advanced analytics.

As a Data Connections Engineer, you will be expected to.

• Design, develop, and implement end-to-end data pipelines, utilizing ETL processes and technologies such as Databricks, Python, Spark, Scala, JavaScript/JSON, SQL, and Jupyter Notebooks.
• Create and optimize data pipelines from scratch, ensuring scalability, reliability, and high-performance processing.
• Perform data cleansing, data integration, and data quality assurance activities to maintain the accuracy and integrity of large datasets.
• Leverage big data technologies to efficiently process and analyze large datasets, particularly those encountered in a federal agency.
• Troubleshoot data-related problems and provide innovative solutions to address complex data challenges.
• Implement and enforce data governance policies and procedures, ensuring compliance with regulatory requirements and industry best practices.
• Work closely with cross-functional teams to understand data requirements and design optimal data models and architectures.
• Collaborate with data scientists, analysts, and stakeholders to provide timely and accurate data insights and support decision-making processes.
• Maintain documentation for software applications, workflows, and processes.
• Stay updated with emerging trends and advancements in data engineering and recommend suitable tools and technologies for continuous improvement.

Your background will include the following attributes and experience.

• Secret clearance is required.
• Demonstrated experience creating data pipelines from scratch.
• Proven proficiency in ETL processes and demonstrated hands-on experience with technologies such as Databricks, Python, Spark, Scala, JavaScript/JSON, SQL, and Jupyter Notebooks.
• Strong problem-solving skills and ability to solve complex data-related issues.
• Demonstrated experience working with large datasets and leveraging big data technologies to process and analyze data efficiently.
• Understanding of data modeling/visualization, database design principles, and data governance practices.
• Excellent communication and collaboration skills, with the ability to work effectively with cross-functional teams.
• Detail-oriented mindset with a commitment to delivering high-quality results.

Other capabilities desired.

• Knowledge of Qlik/Qlik Sense, QVD/QlikView, and Qlik Production Application Standards (QPAS) is a significant plus.
• Recent DoD or IC-related experience.
• Previous experience with Advana is a plus.

If you are excited by the prospect of supporting a critical mission through the delivery of vital information gleaned from a wide array of data sources, while working for a fast-growing firm offering great opportunities to progress and excellent benefits, this is an opportunity to explore.

Established in 2010, @Orchard has an exceptional reputation, providing staffing solutions to time-sensitive, talent scarcity issues to deliver better talent management ROI. Our specialty lies in the critical area of program talent acquisition and resource management, not in one narrow skillset, but across many areas of technical and functional delivery. To learn more about our other exciting opportunities, visit our Jobs Page at www.atorchard.com.

---