Data Engineer
San Diego, CA, United States
Full Time Mid-level / Intermediate Clearance required USD 90K - 130K
INDUS Technology
The Team and the Role
INDUS is a 100% employee-owned, customer-focused government services provider with expertise in Engineering, Information Technology, Cybersecurity, Program/Financial Management, Logistics, and Data Analytics. At INDUS, we believe in the value of the INDUS team. Together we deliver exceptional customer service, foster a growth and support-centered work environment, and focus on how we can give back to the communities that we serve. Empowering our employees starts on day one and creates an environment full of innovation and promise. By offering mentorship and robust Training and Development opportunities, INDUS continues its pursuit to be the Employer of Choice.
The Shore and Expeditionary Integration Program Office (PMW 790) is acquiring support services in the areas of production systems engineering, logistics, installation management, and integration/planning/requirements services for the architecture, integration, acquisition, and support of multiple shore and expeditionary Command, Control, Communications, Computers, and Intelligence (C4I) programs. PMW 790's mission is to acquire, integrate, deliver, and support interoperable shore-based C4I capabilities for the warfighter. PMW 790’s vision is to be the preeminent provider of integrated shore-based transformational Network Centric Warfare capabilities to the warfighter by providing assured connectivity between tactical forces and higher commands.
Reporting to the Program Manager, the Data Engineer is responsible for collaborating with software engineers to design and implement relational data structures, develop robust data pipelines, and ensure data integrity across multiple environments on the PMW 790 Shore and Expeditionary Integration Program Office Planning and Logistics Support Services contract. The ideal candidate has prior experience executing ETL processes, administering PostgreSQL databases, and implementing data security measures to maintain compliance in a Controlled Unclassified Information (CUI) environment. Additionally, the ideal candidate has demonstrated proficiency in Python coding language, experience with Django migrations, and is familiar with agile methodologies and containerization technologies. This position is located in San Diego, CA.
What You'll Do
- Collaborate with software engineers on the design and execution of relational data structures.
- Develop and deploy robust and scalable data pipelines and workflows facilitating data exchange across multiple software development environments.
- Execute ETL data integration processes, transforming structured data from sources like SQLite to PostgreSQL targets.
- Ensure data quality and integrity throughout all stages of an application’s lifecycle.
- Implement and meticulously document data security and compliance measures to uphold a Controlled Unclassified Information (CUI) environment.
- Administer and optimize PostgreSQL performance, managing capacity, user roles, and privileges.
- Deploy databases and schemas in production and development settings to support software engineering activities.
- Compose and document SQL procedures and functions.
- Design and implement quality control systems within data pipelines.
- Manage and execute automated backup processes and jobs utilizing pgAgent.
- Actively participate as a team member in an agile work environment.
- Bid and proposal support if requested.
- Other duties as assigned.
What We're Looking For
Required Qualifications:
- The ability to obtain and maintain an active secret clearance is required to be considered for this position.
- Bachelor's degree from an accredited university in Computer Science, Computer Engineering, or a related technical field is required.
- At least three (3) or more years of experience providing data engineering and database design support (experience supporting a DoN/DoD program office is preferred).
- Strong knowledge of relational databases and SQL. (SQLite, PostgreSQL).
- Strong knowledge of relational database administration.
- Experience with designing data structures and visualization algorithms.
- Comfortable with tracing data through the model-view-controller (MVC) architecture.
- Familiarity with version control systems, such as Git.
- Experience with data science tools and libraries like Pandas and NumPy.
- Familiarity with software development methodologies, such as Agile or Scrum.
- Must be legally authorized to work in the United States without the need for employer sponsorship, now or at any time in the future.
Desired Qualifications:
- Proficiency with Python coding desired.
- Familiarity with ETL processes utilizing openpyxl, xlrd, CSV, NumPy, and Pandas Python packages.
- Experience with Django migrations across production, staging, and development environments.
- Competence in managing and securing CUI data within a controlled environment.
- Experience collaborating with IT on security audits.
- Familiarity with Linux-based environments and proficiency in writing bash scripts.
- Proficiency in generating agile Key Performance Indicator (KPI) metrics like sprint burndown and velocity charts.
- Experience with containerization using containerd, nerdctl, and Docker.
- Experience with deploying database instances in cloud environments such as Azure or AWS.
INDUS aims to provide a competitive compensation package, including a strong pay for performance rewards approach. The expected base pay range for this position is $90,000. – $130,000. This position is eligible to participate in our corporate 401(k) and Employee Stock Ownership Plan (ESOP) programs, and may be eligible for performance bonuses, and other rewards and benefits (see more about our compensation package and benefits offered at Culture @ INDUS | INDUS Technology). The pay range for this role considers job-related knowledge, skills, work location, education and training, and certifications. To drive fair pay practices for employees, INDUS conducts regular comparisons across our employee groups and the industry.
INDUS is proud to be an equal opportunity employer, seeking to create a welcoming and diverse environment. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, ancestry, physical or mental disability, medical condition, marital status, genetics, age, or veteran status or any other applicable legally protected status or characteristic.
Tags: Agile Architecture AWS Azure Computer Science CSV Data Analytics Data pipelines Data quality Django Docker Engineering ETL Git Linux NumPy Pandas Pipelines PostgreSQL Python RDBMS Scrum Security SQL
Perks/benefits: Competitive pay Equity / stock options
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.