Red Arch Solutions is a proven and effective small business IT integrator and consultant, recognized as a leading IT provider to the Federal Government, primarily focused within the Intelligence Community. We provide our customers with state-of-the-art tactical and strategic intelligence, systems, and software engineering solutions, solving some of the most pressing and unique intelligence community challenges related to national security.
Our employees are exceptionally skilled professionals. We recruit individuals who are dedicated to collecting, analyzing, and disseminating critical information to national leaders. Our engineers design, develop, and deploy mission critical solutions to support our war fighters. We are also an official AWS Partner and are pleased to now offer Cloud Solutions Architecture and Engineering using Amazon Web Services.
Position Overview:
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.
Responsibilities:

• Design and create the overall data onboarding architecture for DDH. Work closely with stakeholders to understand their data requirements and translate them into scalable data models and structures.
• Inspect data with the goal of discovering useful information needed to create data schemas.
• 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.
• Provide training to Data Stewards and end users on DDH UI.
• Build data pipelines to extract, transform, and load (ETL) data from various sources into data warehouses while developing reliable ETL processes to ensure data quality, integrity, and timeliness.
• Integrate disparate data sources and systems, both internal and external, to enable seamless data flow across different platforms using APIs, databases, cloud services, and third-party tools to establish data connections and ensure smooth data integration.
• 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.
• Ensure data quality and integrity.

Qualifications:

• T/S/SCI with polygraph.
• Bachelor's Degree 12 years of experience or a master's degree with 10 years of experience or 16 years of experience in total.
• Experience developing requirements based on needs obtained from users.
• Experience building scripts to manipulate data for ingestion into databases.
• Proficiency using Tableau, Power BI, or QlikView to create meaningful visualizations and reports.
• Demonstrated knowledge of data security best practices, data encryption techniques, and understanding of privacy regulations.
• Strong programming skills in languages such as Python.
• Understanding of Apache and or Kafka for processing and analyzing streaming data.
• Familiarity with cloud platforms like Amazon Web Services (AWS and their relevant data services.) #CJ

All Red Arch Solutions openings require US Citizenship.
We offer best in class 100% paid employee healthcare premiums, generous PTO, a 10% combined - 6% match on your 401K, vested day one, complemented by up to 4% in profit sharing. Enjoy annualized bonus opportunities, spot bonuses for professional certifications, tuition reimbursement, and a variety of additional employee first perks, including an employee choice of an annual allowance for technology or fitness expenses, tailored to support your lifestyle. Celebrate and unwind with all 11 federal holidays observed, because we believe your hard work deserves significant recognition. We value the power of referrals and offer substantial bonuses for introducing use to more great people life yourself.
Red Arch Solutions provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.