Data Engineer

Job Category: Science

Time Type: Full time

Minimum Clearance Required to Start: None

Employee Type: Regular

Percentage of Travel Required:

Type of Travel: None

* * *

 The CDM Data Services Program mission is to provide a standardized platform to collect, transform, and integrate cybersecurity data from relevant authoritative data sources into a coherent data, delivering actionable information into Agency and Federal Dashboards to identify risk areas in support of mitigation as well as to facilitate coordinated agency and national response to cyber-threats.    

This is a remote position where the candidate can work from any location within the United States provided, they are able to work on an eastern time zone schedule.

What You’ll Get to Do:

Our Data Engineering and Quality team guides and verifies data transformations so that our automated solution delivers end-to-end results with confidence.  The solution is managed in cloud environments and the team works closely with developers to create an automated continuous integration (CI) and continuous delivery (CD) solution using Agile delivery methodologies. 

The cybersecurity data engineer is responsible for taking contractual obligations, requirements, and customer desires and directs data business rules and data transformations between the customer and the team of developers.  Ownership of the data model will be needed to test and observe data quality issues.  Dashboard creation will be utilized to communicate findings.

The successful candidate will bring a consultative approach to business processes and will proactively collaborate with different stakeholders to define the data workflow of the solution.  They will work closely with developers to instruct and validate the solution to ensure it fulfils its objectives. The candidate should have a business and data analysis mindset in addition to data engineering to support the clients’ needs and understanding to make the best out of the developed solution.

More About the Role:

• Work with internal and external stakeholders to examine contractual data requirements in order to drive data modeling, pipelines, transformation, normalization, and quality for each solution release through a SAFe Agile Release Train (ART) to achieve business goals
• Act as subject matter expert regarding data requirements, formats, types, lineage, and quality to brief internal and external stakeholders
• Analyze raw data from different sources and define consistent and machine-readable formats for the data store
• Work with stakeholders to track and obtain nonautomated data sources to maintain freshness
• Develop, document, and communicate processes for seamless data ETL (extraction, transformation, and loading) through Cloud based data services
• In charge of directing developers on how to join and convert raw data from multiple sources into usable information for analytics and reporting
• Work collaboratively with cross-functional teams to design, implement, and maintain a scalable and secure data repository/lake that can support analyzing trends and patterns
• Prepare options, levels of effort, and estimates when data requirements change
• Suggest where automation can improve processes and gain efficiencies
• Develop database objects and schemas that support extracting, transforming, loading, and storage of data based on a logical data model (LDM)
• Participate in Agile ceremonies and track and document work in Jira and Confluence
• Ensure data integrity, quality, and accessibility within the repository/lake
• Conduct complex data analysis using SQL based searches and instruct developers on how to handle data quality issues
• Explore and implement ways to enhance data quality and reliability and use tools to develop analytical dashboards
• Work with Data Scientists to improve the quality and accuracy of the information enabling stakeholders to make more responsible cyber risk decisions
• Prepare and maintaining datasets for testing and modeling
• Develop and maintain the solution’s data dictionary and data lineage
• Define data retentions and governance for the solution

You’ll Bring These Qualifications:

• Must be a US citizen and pass a background investigation.
• Able to obtain and maintain a DHS Suitability/Entry on Duty (EOD)
• Degree in Computer Science, IT, or similar field
• At least 5 years of proven experience as a Data Engineer or similar role
• Solid understanding of relational databases and ETL processes
• Proficiency in data transformation, normalization, and configuration
• Technical expertise in data ingestion and manipulation
• Knowledge of big data platforms and data source formats from APIs (JSON, csv, yaml)
• Familiarity with API integration and data pipelines
• Experience in creating dashboards (e.g., Tableau, PowerBI, or similar) for data visualization
• Detail-oriented, strong analytical skills, and the ability to combine data from different sources
• Experience with data abstraction, various data conditions including blank and NULL data, and detecting and handling data collisions, and filtering logic syntax
• Experience with SQL/T-SQL, NoSQL, and data visualization tools design
• Having been involved with data segmentation, cleansing, enrichment, and indexing
• Familiarity with application administration, configuration, and integration
• Experience with data security and segregation physically or logically.  Know the use of role-based access and attribute-based access when limiting data.
• Excellent communication skills, both written and oral
• Ability to independently perform research on industry standards, regulatory requirements, and cutting-edge technological trends.  Have passion for new technologies, software, and processes
• Skilled and disciplined to work with a remote distributed team
• Ability to multi-task in a fast-paced environment with multiple deadlines is essential
• Familiarity with agile development methodologies
• Expertise in the Microsoft Office / Google suite of software

These Qualifications Would be Nice to Have:

• Data engineering or data analyst certification
• Scaled Agile Framework (SAFe) certification
• Experience with Data Lakes, Data Warehouses, or Data Lakehouse
• Experience with Data governance tools
• Experience with Cloud services such as Azure, AWS or GCP
• Understanding of cybersecurity tools such as vulnerability (CVE) scanners, software scanners, mobile and network host discovery scanners, and other tools in order to understand source data
• Familiarity with federal cybersecurity concepts such as Vulnerabilities, DISA STIGs, NIST, FISMA, Risk Management Framework, and MITRE ATT&CK Framework
• Experience working with government contracting
• Knowledge of programming languages (e.g., Python, PowerShell)
• Experience with data compression, data deduplication.
• Experience with Elasticsearch with Kibana Dashboards.

What We Can Offer You:

- We’ve been named a Best Place to Work by the Washington Post.

- Our employees value the flexibility at CACI that allows them to balance quality work and their personal lives.

- We offer competitive benefits and learning and development opportunities.

- We are mission-oriented and ever vigilant in aligning our solutions with the nation’s highest priorities.

- For over 60 years, the principles of CACI’s unique, character-based culture have been the driving force behind our success.

Company Overview:

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

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 more here

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:

$104,200-$229,200