Data Engineer, Python

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

📋 Description

• Design, develop, test, and maintain data pipelines and transformation workflows utilizing SQL, Python, Databricks, and cloud technologies.

• Develop and optimize PostgreSQL database objects, queries, data models, and access patterns for data retrieval.

• Construct and uphold DataConnect reporting integrations leveraging AWS QuickSight and Databricks.

• Create API services and reusable components to ensure secure data access and system integration.

• Extract, transform, and load data from diverse sources.

• Establish and maintain data quality checks, validation jobs, monitoring, and operational alerts.

• Diagnose data issues and enhance pipeline reliability, performance, availability, and refresh timing.

• Author unit and integration tests and engage in code reviews.

• Convert technical specifications and business requirements into code, data designs, and implementation documentation.

• Collaborate with DevOps engineers on CI/CD, infrastructure as code, deployment, and environment support.

• Implement security and privacy measures for data both at rest and in transit.

• Participate in Agile planning, refinement, estimation, and continuous improvement initiatives.

• Perform additional tasks as assigned.

⛳️ Requirements

• Bachelor's degree.

• 3+ years of practical experience in software development or data engineering.

• 2+ years of experience in developing data pipelines or data-processing solutions using SQL and Python or a similar programming language.

• Practical experience with PostgreSQL and a strong understanding of relational database concepts and SQL.

• Experience with cloud-based data platforms and version-controlled development workflows.

• Capability to interpret technical specifications and convert them into functional code and documentation.

• Ability to obtain and maintain a Public Trust clearance.

• Must reside in the United States, be authorized to work in the United States, and have lived in the United States for three full years out of the last five years.

• Preferred: experience with Databricks, AWS QuickSight, Spark, Airflow, AWS data services, REST APIs, TypeScript, CI/CD, GitHub Actions, Terraform, data governance, metadata, data lineage, secure data sharing, Agile teams, and test-driven development.

🏝️ Benefits

• Equal opportunity employment.

• Reasonable accommodations for disabilities, disabled veterans, and sincerely held religious beliefs.

• Benefit offerings referenced under the Transparency in Coverage Act.