CACI International IncCI

ETL Data Architect

CACI, founded in 1962, is a leading provider of technology and expertise for national security, committed to innovation and excellence.

CACI International Inc

Employee count: 5000+

Salary: 90k-188k USD

United States only
ETL Data ArchitectJob Category: EngineeringTime Type: Full timeMinimum Clearance Required to Start: SecretEmployee Type: RegularPercentage of Travel Required: Up to 10%Type of Travel: Continental US* * *

The Opportunity:
CACI wants you to join us on the development of a customer data platform for the business systems of Military Sealift Command. With your skills, you will help integrate the data of multiple business systems that drive Military Sealift Command's organization, working with a dynamic set of stakeholders as part of an agile team. Through your development and integration, you will ensure the successful delivery of data needs are met using a cloud-first customer data platform.

Responsibilities:

  • Support the development of an integrated data model for the data domains of the business systems to include: Budgeting, Human Resources, Logistics, Maintenance and Repair, and Contracts.
  • Collaborate with Business Intelligence and Data Analyst staff to identify, define, and generate data structures based upon user requirements
  • Perform critical analysis of existing database systems to produce data models
  • Reverse engineering existing databases into models for analyst consumption
  • Support metadata collection efforts identifying and coordinating stewards to respond to data calls on data models stored within the platform.
  • Establish and maintain interfaces between DoD systems, maintaining Interconnection Agreements and data management plans
  • Design and develop ETL scripts utilizing AWS Glue/Skar, Lambda, EMR, and SageMaker; using Python
  • Develop data orchestration workflows using AWS Step Functions and AWS Glue to coordinate ETL scripts to mature, enrich, and expose existing data sets
  • Analyze the performance of and optimize Apache Spark job scripts
  • Analyze and Optimize AWS resources of the customer data platform and data lake.
  • Develop AWS deployments by programming the infrastructure using CDK and performed through a CICD pipeline
  • Perform code reviews as a member of an agile team for the development of Data Products

Qualifications:

Required:

  • Bachelors of Science, focused in Computer Science or equivalent Bachelors focusing on data integration services
  • Security+, CSSLP, or other DCWF certification targeting the Data/AI or Software Engineering work roles.
  • 4-5 years experience in software development, at least 2 in Python and familarity with AWS CDK
  • 2-4 years experience in developing big data products leveraging Spark / Pyspark or equivalent distributed map-reduce solutions
  • 3-5 years Data Modeling experience using formal methods such as DoDAF, SysML, UML, or equivalent
  • 2-4 years experience in Data Warehousing or Data Lake design
  • 4+ years of applied experience using an RDBMS or other database technologies and SQL script development

Desired:

  • AWS Certified Developer, Solutions Architect, or Data Engineer associate
  • DAMA CDMP or EDM Council DCAM
  • CompTIA Data+ or equivalent certification
-

What You Can Expect:

A culture of integrity.

At CACI, we place character and innovation at the center of everything we do. As a valued team member, you’ll be part of a high-performing group dedicated to our customer’s missions and driven by a higher purpose – to ensure the safety of our nation.

An environment of trust.

CACI values the unique contributions that every employee brings to our company and our customers - every day. You’ll have the autonomy to take the time you need through a unique flexible time off benefit and have access to robust learning resources to make your ambitions a reality.

A focus on continuous growth.

Together, we will advance our nation's most critical missions, build on our lengthy track record of business success, and find opportunities to break new ground — in your career and in our legacy.

Your potential is limitless. So is ours.

Learn more about CACI here.

Pay Range: There are a host of factors that can influence final salary including, but not limited to, geographic location, Federal Government contract labor categories and contract wage rates, relevant prior work experience, specific skills and competencies, education, and certifications. Our employees value the flexibility at CACI that allows them to balance quality work and their personal lives. We offer competitive compensation, benefits and learning and development opportunities. Our broad and competitive mix of benefits options is designed to support and protect employees and their families. At CACI, you will receive comprehensive benefits such as; healthcare, wellness, financial, retirement, family support, continuing education, and time off benefits. Learn morehere.

Since this position can be worked in more than one location, the range shown is the national average for the position.

The proposed salary range for this position is:

$89,500-$188,000

CACI is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, age, national origin, disability, status as a protected veteran, or any other protected characteristic.

About the job

Apply before

Posted on

Job type

Full Time

Experience level

Senior

Salary

Salary: 90k-188k USD

Location requirements

Hiring timezones

United States +/- 0 hours

About CACI International Inc

Learn more about CACI International Inc and their company culture.

View company profile

CACI is a $7.7 billion company that specializes in delivering distinctive expertise and innovative technology to U.S. government customers, particularly in support of national security missions. Founded in 1962 by Herb Karr and Harry Markowitz, CACI was established during a pivotal time in the computer industry, quickly evolving into a leader in providing IT services and consulting. Over the years, CACI has grown significantly, employing around 24,000 talented individuals who are committed to ethics, integrity, and excellence in all endeavors.

Our offerings extend beyond traditional IT solutions to include advanced technology for defense, cybersecurity, electronic warfare, and intelligence operations. We pride ourselves on our agile methodologies, enhancing performance through innovative products and solutions that address the most pressing challenges faced by our customers. CACI's culture is founded on two pillars: character and innovation, which drive our mission to meet the nation’s highest priorities. Recognized as one of America’s Most Trusted Companies by Forbes and a top workplace, CACI’s commitment to excellence continues to be reflected in our achievements, further solidifying our role at the forefront of the national security sector.

Claim this profileCACI International Inc logoCI

CACI International Inc

View company profile

Similar remote jobs

Here are other jobs you might want to apply for.

View all remote jobs

51 remote jobs at CACI International Inc

Explore the variety of open remote roles at CACI International Inc, offering flexible work options across multiple disciplines and skill levels.

View all jobs at CACI International Inc

Remote companies like CACI International Inc

Find your next opportunity by exploring profiles of companies that are similar to CACI International Inc. Compare culture, benefits, and job openings on Himalayas.

View all companies

Find your dream job

Sign up now and join over 85,000 remote workers who receive personalized job alerts, curated job matches, and more for free!

Sign up
Himalayas profile for an example user named Frankie Sullivan
CACI International Inc hiring ETL Data Architect • Remote (Work from Home) | Himalayas