Data Engineer at Constellation West

Job Description:

Constellation West is looking for an entry-level to senior-level Data Engineer to support the CDAO's Mission Analytics Directorate through the Advana program, which provides core and data analytics across various domains, including procurement and financial management (FM). By enhancing the integration of procurement and FM datasets, the program aims to improve data quality and completeness, focusing on detailed contract line item numbers (CLIN) and line of accounting (LOA) levels. This integration facilitates the measurement of end-to-end processes, identification of interface failures, and timely obligations and payments. It also supports accurate data conversions and contract closeouts, offering the DoD critical insights into mission-critical processes and helping prevent financial discrepancies and overpayments.

Job Details & Tasks:

Senior-Level with seven plus years of experience:

Manage a team of specialized data scientists and data engineers focused on optimizing the creation, deployment, testing, and iterative development of all bronze, silver, and gold data tables deployed across unclassified and classified CDAO environments under the References. Advana uses Python, SQL, and PySpark languages and standard Python packages in Databricks. Bronze tables are query-able versions of data as they are received, including historical copies. Silver tables are refined source data with a schema standardized against guidance from the data source. Gold tables store fit-for-purpose analytic data transformed, cleansed, and aggregated for the use case or application.

All levels of Data Engineer will be expected to perform the following:

Create and maintain templates, guides, and playbooks to inform and enable the DoD to reuse and scale data, analytic, and AI work for decision advantage.

Provide engineering support to all customers working to leverage the Advana platform and other CDAO platforms:

• Build data products and data mesh services.
• Register, ingest, store, search, and retrieve data products.
• Develop suites of data quality business logic.
• Train, test, and deploy production AI/ML models.
• Integrate and maintain metadata.

Job Qualifications & Requirements:

• For the Senior-Level position, 7-10+ years of development experience in Python, Spark, SQL
• Proven ability to independently establish and manage multiple data pipelines.
• Experience with Big Data systems and ELT processes.
• Experience with Amazon Web Services (AWS) certification is preferred.
• Experience applying DoD Security Technical Implementation Guides (STIGs) and automating the process.
• Experience in Advana Preferred.
• Bachelors or Higher in related field
• Must hold a Secret security clearance with TS/SCI clearance preferred.
• Valid Passport
• Ability to commute to Falls Church 2-3 days per week.

Note: This opportunity is contingent upon the awarding of a bid. We are conducting screenings and interviews to ensure a suitable fit for both candidates and our organization. Successful candidates will receive contingent offers based on mutual agreement, demonstrating our commitment to collaboration upon securing the project. We look forward to the possibility of welcoming you to our team. The tentative start date for this project is December 1, 2024

Project Background:

Advana is the Department of Defense (DoD) Chief Digital and Artificial Intelligence Office’s (CDAO) enterprise-wide, multi-domain data, analytics, and artificial intelligence (AI) platform that provides all DoD military and civilian decision makers, analysts, and builders with enterprise data, tools, and capabilities—all in a scalable, reliable, and secure environment. Jointly managed by the DoD CDAO Mission Analytics and Enterprise Platforms and Services Directorates, the mission of Advana is to accelerate decision advantage by making data, analytics, and AI widely accessible, understandable, and actionable across DoD. To do this, the Advana platform hosts curated analytics applications in a total of 13 DoD business domains, to include logistics, people and health, intelligence and security, readiness and global force management, etc.; it provides market-leading, self-service tools to perform data exploration, model development, data visualization, and other analysis activities; and it provides both users and builders on-demand data, analytics, and AI capabilities via a DoD-wide platform.

We are an Equal Opportunity Employer

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender, gender identity, national origin, disability status, protected veteran status, or any other characteristic protected by law. Constellation West will not discharge or, in any other manner, discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)

About The Organization

Constellation West is an award winning company that delivers Information Technology (IT) engineering services and solutions and non-IT subject matter expertise worldwide. Established in 1997, Constellation West is an industry leader, partnering with key organizations. As a prime contractor or preferred subcontractor, we have a continual list of opportunities to fill nationwide with multiple agencies such as the Department of Veteran Affairs, the Department of Defense, civilian agencies, and the national intelligence community. Many positions supporting the U.S. federal government require our employees to be granted security clearances.

Constellation West strives to provide fully integrated solutions that cover all aspects of system and network engineering, administration, and management. We believe in attracting the right people ready to take on exciting challenges and be part of a dynamic team. Are you one of them? Do you have the expertise and knowledge to solve complex problems? If yes, join us and be a part of an exhilarating work environment that rewards your hard work and dedication. Don't miss out on this fantastic opportunity to make a difference!

Benefits include but are not limited to:

• Tuition reimbursement
• Competitive 401(k) plan
• Competitive Health Benefits
• 11 Paid Holidays!!
• Start accruing PTO on Day 1!
• Veteran Hiring Preference

Constellation West is proud to be an EEO/AA employer M/F/D/V