Mid Data Engineer
Job Description
Castalia Systems is hiring a Mid-Level Data Engineer in Arlington, VA (hybrid) to support reliable data availability and scalable pipeline delivery.
Responsibilities
- Ensure data availability across the lifecycle: movement, modification, and storage
- Build and support scalable data pipelines for high-priority users
- Design and implement Extract Transform Load (ETL) processes
- Perform data handling work using scripting and data manipulation workflows
- Work with tools and systems supporting data storage and processing, including data lake and related platforms
- Collaborate using Agile SCRUM methodologies
Requirements
- BS Degree
- 3+ years of professional experience (needed for most opportunities)
- Python experience for data manipulation, scripting, and related tasks
- Databricks experience
- Proficiency designing and implementing ETL data processes
- Experience with at least one relational database, such as PostgreSQL, MySQL, or SQLite
- Experience with Agile SCRUM
Technologies
- Python
- Databricks
- Extract Transform Load (ETL)
- PostgreSQL
- MySQL
- SQLite
- Agile SCRUM
- NiFi
- SQL
- NoSQL
- Graph Databases
- Data Lakes
- Qlik
Preferred Qualifications
- Familiarity with database design, server management, connection protocols, database normalization, and principles of information theory
- Experience with data cleaning or data organization
- Familiarity with NiFi, SQL, NoSQL, Graph Databases, and Data Lakes
- Familiarity with dashboarding tools similar to Qlik
- Familiarity with cybersecurity, including design and implementation of unique data transfer protocols
Clearance & Eligibility
- Active Secret clearance
- Must be a U.S. Citizen
Workplace
- Location: Arlington, VA (hybrid)
- Onsite schedule: 3-5 days per week
- Work environment: Normal office environment
- Travel: As needed
Job Type
- Full-Time
Compensation
- USD 130,000 - 140,000 per year
Benefits
- Medical, dental, vision coverage
- 401k matching
- Generous PTO
- Paid holidays
- Professional training opportunities
- Pet insurance