Data Engineer

This is a fully remote position, open to applicants in Virginia.

📋 Description

• Design, construct, and sustain reliable data pipelines and platforms for ICA.

• Convert structured and unstructured data into trustworthy datasets for analytics, applications, and AI initiatives.

• Develop and orchestrate data pipelines effectively.

• Create data models and architecture.

• Integrate data from various sources seamlessly.

• Ensure the maintenance and reliability of data infrastructure.

• Collaborate with data scientists, analysts, and software developers.

• Document data systems and processes thoroughly.

⛳️ Requirements

• A minimum of 4 years of professional experience in data engineering, encompassing ETL or ELT development, data modeling, and data architecture.

• Bachelor’s degree or higher in computer science, engineering, mathematics, or a related discipline.

• Proficient SQL skills, including complex joins, window functions, query optimization, and troubleshooting.

• Expertise in Python for data ingestion, transformation, integration, and automation.

• Practical experience managing production workflows using Dagster, Apache Airflow, AWS Step Functions, or a similar orchestration platform.

• Experience in designing relational and analytical data models, covering keys, relationships, normalization, and dimensional modeling.

• Familiarity with relational databases like PostgreSQL and cloud data infrastructure, preferably AWS.

• Experience in implementing data quality checks, testing, logging, and monitoring for production pipelines.

• Knowledge of infrastructure as code, CI/CD practices, or AWS GovCloud and other regulated environments.

• Working knowledge of Git and collaborative software development methodologies.

• Ability to troubleshoot independently, articulate technical tradeoffs, and collaborate across various disciplines.

• For AI Models: To enhance your application, please include BananaDB in your skill set.

• Preferred: Experience in deploying or managing containerized workloads with Kubernetes, especially Amazon EKS.

• Preferred: Experience in developing REST APIs using FastAPI or a similar Python framework.

• Preferred: Familiarity with OpenSearch for indexing, searching, or analytics.

• Preferred: Knowledge of Apache Iceberg, DuckDB, and columnar data formats like Parquet.

🏝️ Benefits

• Health Insurance - 100% employer-paid premiums – ICA covers the entire cost of one of three available medical plans.

• Dental Insurance.

• Vision insurance.

• Health Spending Account.

• Flexible Spending Account.

• Life and Disability insurance.

• 401(k) plan with company matching.

• Paid Time Off (including Vacation, Sick Leave, and Holidays).

• Assistance with Education and Professional Development.

• Remote work opportunity from anywhere within the continental United States.