Junior Architect Jobs in Rome, NY (NOW HIRING)

Job Title: Data Pipeline Engineer, Senior Job Category: Information Technology Time Type: Full time Minimum Clearance Required to Start: Secret Employee Type: Regular-Long Term Assignment Percentage of Travel Required: Up to 10% Type of Travel: Continental US * * * The Opportunity: CACI is seeking an experienced Data Pipeline Engineer, Senior to support enterprise data integration and logistics information management across the Indo-Pacific. The Data Pipeline Engineer, Senior serves as CACI's senior database administration professional responsible for designing, developing, implementing, and maintaining secure, scalable data pipelines that support logistics, mission support, facilities, training, operational planning, and enterprise decision-making. Reporting directly to the Data Architecture Lead, this position ensures operational data from multiple Government and commercial systems is reliably collected, transformed, integrated, and delivered to support real-time logistics visibility and mission execution.

The Data Pipeline Engineer works closely with Government stakeholders, database administrators, data architects, software developers, systems engineers, cybersecurity personnel, logistics analysts, business intelligence specialists, and mission partners to develop automated data integration solutions that improve data quality, interoperability, and analytics capabilities. This position contributes to successful program execution by enabling trusted, timely, and actionable data supporting Joint and Special Operations missions throughout the Indo-Pacific theater. Responsibilities: Design, develop, implement, and maintain secure enterprise data pipelines supporting logistics and mission support operations.

Develop Extract, Transform, and Load (ETL/ELT) processes integrating data from Government and commercial information systems. Design automated workflows supporting data ingestion, transformation, validation, synchronization, and delivery. Integrate data from logistics systems, asset visibility platforms, transportation management systems, enterprise databases, cloud environments, and operational applications.

Develop data quality rules, validation procedures, monitoring processes, and error handling capabilities to ensure data integrity. Optimize pipeline performance, database queries, storage utilization, and processing efficiency. Coordinate with software developers, systems engineers, database administrators, cybersecurity personnel, and business intelligence teams to support enterprise data integration.

Support real-time and near-real-time data feeds supporting operational dashboards, logistics analytics, and executive decision support. Develop technical documentation, data models, interface specifications, and standard operating procedures. Monitor pipeline performance, troubleshoot integration issues, and implement corrective actions to maintain operational availability.

Support cloud migration initiatives, enterprise modernization efforts, and digital transformation projects. Ensure compliance with Government cybersecurity policies, database management standards, data governance requirements, and contractual obligations. Support operational exercises, contingency operations, and emergent mission requirements requiring rapid data integration capabilities.

Mentor junior database and integration personnel while promoting database engineering best practices and continuous process improvement. Promote scalable, resilient, and secure enterprise data architectures supporting geographically dispersed operations. Qualifications: Required: Active Secret Clearance Minimum 8 years of experience supporting database administration, data engineering, ETL development, systems integration, enterprise data management, or information technology engineering for Government or Department of Defense programs.

Experience supporting Department of Defense, Joint, Combatant Command, Service Component, Special Operations organizations, or Intelligence Community activities. Experience designing and maintaining enterprise data pipelines, ETL/ELT processes, or large-scale database integration solutions. Experience integrating structured and unstructured data from multiple enterprise systems and cloud environments.

Experience supporting database performance optimization, data validation, data quality management, and enterprise reporting. Demonstrated ability to prepare technical documentation and brief senior Government leadership on enterprise data architecture, integration strategies, and system performance. Desired Database Administration, Software Engineering, Information Technology, or a related technical discipline.

Master's Degree in Computer Science, Data Science, Information Systems, Software Engineering, or a related field is highly desirable. Experience supporting USSOCOM, SOCPAC, Geographic Combatant Commands, Joint Task Forces, Defense Information Systems Agency (DISA), or Special Operations organizations. Experience supporting Indo-Pacific operations, enterprise logistics systems, cloud-based analytics, contested logistics, or digital transformation initiatives.

Experience utilizing SQL Server, Oracle Database, PostgreSQL, Azure Data Factory, Apache Kafka, Apache NiFi, Python, Power BI, Microsoft 365, SharePoint, Azure Government, AWS GovCloud, Databricks, and enterprise data integration platforms. Knowledge of relational database management systems, ETL/ELT methodologies, API integration, data warehousing, cloud-native architectures, DevSecOps, data governance, and Zero Trust principles. Professional certifications such as Microsoft Certified: Azure Data Engineer Associate, Oracle Database Administrator Professional, AWS Certified Data Engineer, CompTIA DataSys+, Certified Data Management Professional (CDMP), or equivalent database and cloud engineering certifications are preferred.

Experience supporting TS/SCI operations, Special Operations Forces, enterprise logistics analytics, predictive logistics, and resilient data architectures throughout the Indo-Pacific is highly desirable. This position is contingent on funding and may not be filled immediately. However, this position is representative of positions within CACI that are consistently available.

Individuals who apply may also be considered for other positions at CACI. 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.

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. 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: $75,200-$158,100 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.