Database Engineer

Chantilly, VA
Full Time
*Prime Contract
Experienced

Red Arch Solutions (RAS) is building a DIA Enterprise Data Platform (EDP) that will facilitate the transition and retirement of duplicative and legacy data services and provide an automated, modernized, enterprise data hub within a secure environment.  EDP will enable DIA to expose its data to a wider audience through a zero-trust based, data centric architecture.  Based on a robust data governance policy approach, EDP will free data from siloes and allow more users to gain valuable insights from DIA data assets.  RAS will maintain and improve the EDP to ensure DIA has high data availability, accessibility, veracity, integration, and discoverability while enabling data analytics, visualization, security, governance, and management across the enterprise.

Basic Job Responsibilities: 

  • Data Onboarding Architecture: Data Engineers design and create the overall data onboarding architecture for DDH. They work closely with stakeholders to understand their data requirements and translate them into scalable data models and structures.

  • Data Analysis: Inspect data with the goal of discovering useful information needed to create data schemas.

  • Data Pipeline Development: Data Engineers build data pipelines to extract, transform, and load (ETL) data from various sources into data warehouses. They develop efficient and reliable ETL processes to ensure data quality, integrity, and timeliness.

  • Data Integration: Data Engineers integrate disparate data sources and systems, both internal and external, to enable seamless data flow across different platforms. They may work with APIs, databases, cloud services, and third-party tools to establish data connections and ensure smooth data integration.

  • Data Transformation and Processing: Data Engineers transform raw data into a format suitable for analysis or consumption. This involves cleaning, filtering, aggregating, and structuring the data using tools like SQL, Python.

  • Data Quality and Governance: Ensuring data quality and integrity is a crucial responsibility of Data Engineers. They implement data quality checks, data validation rules, and data governance practices to maintain accurate and consistent data throughout the data lifecycle.

  • Scalability and Performance: Data Engineers optimize data pipelines and infrastructure for scalability and performance.

  • Data Security: Data Engineers play a role in securing data assets by validating security policies are implemented for the data.

  • Monitoring and Troubleshooting: Data Engineers monitor data pipelines and systems to identify and resolve issues proactively.

  • Collaboration: Data Engineers collaborate with internal DDH teams and cross-functional teams (CDO, MARs).

  • Customer Engagement: Engage in regular meetings and communication channels with Data Stewards and Data Steward Representatives to gather information needed to appropriately understand and secure their data in preparation for data onboarding.

  • Provide “white glove” service to Data Stewards for data onboarding questionnaire assistance.

  • Training and User Support: Provide training to Data Stewards and end users on DDH UI.

  • Documentation: Author or update documentation such as the Data Onboarding Execution Plan, data onboarding Standard Operating Procedure, and any associated DDH documentation (CONOPS, CDD).

Data Engineering Skills: 

  • Data Modeling and Database Design: Proficiency in designing efficient and scalable data models, understanding relational and non-relational databases, and knowledge of SQL
  • ETL and Data Integration: Experience with Extract, Transform, Load (ETL) processes, data integration techniques, and tools like Apache NiFi.
  • Programming and Scripting: Strong programming skills in languages such as Python.
  • Data Warehousing: Understanding of data warehousing concepts and experience with data warehouse technologies.
  • Data Pipeline and Workflow Tools: Proficiency in tools for building and managing data pipelines and workflows.
  •  Data Streaming: Knowledge of real-time data streaming technologies such as Apache Kafka for processing and analyzing streaming data.
  • Data Quality and Governance: Understanding of data quality frameworks, data validation techniques, and experience implementing data governance practices.
  • Cloud Platforms: Familiarity with cloud platforms like Amazon Web Services (AWS and their relevant data services.
  •  Data Security: Knowledge of data security best practices, data encryption techniques, and understanding of privacy regulations.
  • Data Visualization: Ability to work with data visualization tools like Tableau, Power BI, or QlikView to create meaningful visualizations and reports.
  • Problem Solving and Troubleshooting: Strong analytical and problem-solving skills to identify and resolve issues in data pipelines, databases, or data infrastructure.
  • Collaboration and Communication: Effective communication skills to collaborate with cross-functional teams, understand requirements, and present technical solutions to non-technical individuals.
  • Continuous Learning: A mindset of continuous learning and keeping up-to-date with evolving technologies, tools, and industry trends in the field of data engineering.

.  Qualifications: 

  • Bachelor Degree + 12 years or Master Degree + 10 years experience or 16 years of experience.
  • Experience developing requirements based on needs obtained from users. 
  • Experience building scripts to manipulate data for ingestion into databases.

**TS/SCI with Poly is required for this position**

All Red Arch Solutions openings require US Citizenship.

Red Arch Solutions is a proven and effective small business integrator and consultant, recognized as a leading provider of IT development to the Federal Government. We offer excellent benefits, including 20 days PTO, 10 holidays, up to 10% 401k contribution, and reimbursement for tuition/certifications. Top of the line PPO Medical, Dental, Vision, and Short and Long-Term disability are also offered.

Red Arch Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of race, color, religion, sex, sexual orientation, national origin, age, marital status, disability, or protected veteran status. Red Arch Solutions takes affirmative action in support of its policy to advance in employment individuals who are minorities, women, protected veterans and individuals with disabilities.

Share

Apply for this position

Required*
Apply with
We've received your resume. Click here to update it.
Attach resume or Paste resume
Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

To comply with government Equal Employment Opportunity and/or Affirmative Action reporting regulations, we are requesting (but NOT requiring) that you enter this personal data. This information will not be used in connection with any employment decisions, and will be used solely as permitted by state and federal law. Your voluntary cooperation would be appreciated. Learn more.
Invitation for Job Applicants to Self-Identify as a U.S. Veteran
  • A “disabled veteran” is one of the following:
    • a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or
    • a person who was discharged or released from active duty because of a service-connected disability.
  • A “recently separated veteran” means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.
  • An “active duty wartime or campaign badge veteran” means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.
  • An “Armed forces service medal veteran” means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.
Veteran status


Voluntary Self-Identification of Disability
Voluntary Self-Identification of Disability Form CC-305
OMB Control Number 1250-0005
Expires 04/30/2026
Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury
Please check one of the boxes below:

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.

You must enter your name and date
Human Check*