CACI bv · 15 hours ago
Senior Data Engineer (Informatica/Databricks)
Ashburn, VA
Full-time
Onsite
Mid, Senior Level
$113K/yr - $238K/yr
7+ years expCACI is currently looking for a highly skilled and experienced Senior Data Engineer (Informatica/Databricks) to join their BEAGLE Agile Solution Factory Team supporting Customs and Border Protection. The role involves designing and maintaining data architectures and pipelines, optimizing data processing, and serving as a technology expert to enhance mission outcomes.
EducationConsultingTraining
No H1B
U.S. Citizen Only
Responsibilities
Design, develop, and maintain robust and scalable data warehouse architectures and ETL/ELT data pipelines using Databricks or a similar cloud-based platform
Optimize and troubleshoot data pipelines and warehouse performance to ensure efficient and reliable data processing
Work with database developers and administrators across multiple product teams
Serve as a data and technology expert across a broad and diverse set of mission critical applications
Modernize the data warehouse environment by migrating the platform to Databricks
Evaluating existing data sets and reporting architectures to identify strategic gaps and apply modern technologies to creatively achieve superior mission outcomes
Analyze project-related problems and create innovative solutions involving technology, analytic methodologies, and advanced solution components
Create or augment business and operational intelligence tools using languages such as SQL, Spark, and Python to detect trends, patterns, and non-obvious relationships in large, complex, and disparate data sets
Actively participate in Agile Scrum sprint planning, artifact creation, sprint testing, regression testing, demonstrations, retrospectives and solution releases
Qualification
Required
Must be a U.S. Citizen with the ability to pass CBP background investigation, criteria includes but is not limited to: 3 year check for felony convictions, 1 year check for illegal drug use, 1 year check for misconduct such as theft or fraud
7+ years of professional experience working on complex data challenges in the areas of data architecture and engineering
Proven 7+ years of experience automating ELT data pipelines using Informatica
Experience with cloud platforms (e.g., AWS, Azure, GCP) and services related to data storage and processing (e.g., S3, ADLS)
Experience building and optimizing data pipelines for batch and/or streaming data
3-5 years of Databricks experience. Alternative/equivalent technologies: Significant experience with Snowflake, Google BigQuery, or Microsoft Azure Synapse Analytics will also be considered
Experience with Databricks, including extensive hands-on experience with PySpark, Python, SQL, Kafka, and Databricks notebooks. Strong experience with data modeling techniques (e.g., dimensional modeling, data vault) and database design
Database skillset for AWS RDS concepts, and understanding of database principles used by tools such Oracle, PostgreSQL and Databricks
Strong software development background using Agile or DevOps methods and deep familiarity with cloud-native technologies
Preferred
5-10 years of DHS, DoD, or IC experience working in complex data environments, including the architecture and optimization of data schemas, terabyte-scale ETL, etc
Exposure to implementing or migrating to Cloud environments like Amazon Web Services (AWS) or Microsoft Azure
Previous experience as an Enterprise-level Data Architect, Data Engineer, Data Scientist, or Data Analyst
Ability to apply advanced principles, theories, and concepts, and contribute to the development of innovative principles and ideas
Benefits
Healthcare
Wellness
Financial
Retirement
Family support
Continuing education
Time off benefits
Company
CACI bv
CACI levert, implementeert en beheert bedrijfskritische oplossingen voor het Hoger Onderwijs: het StudentInformatieSysteem OSIRIS en LISA voor zaakgericht werken.
51-200 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase