Full Stack Engineer

Powerhouse Institute Inc.; Washington (District of Columbia); Hybrid; USD 98,000 - 140,000; Full time

Job summary

Powerhouse Institute Inc. is seeking a senior software engineer for a fully remote role serving the DMV/US markets.

You will contribute across the lifecycle, design data pipelines in Snowflake, build and test full-stack applications, and collaborate with cloud engineering to deploy in AWS. The ideal candidate has 8+ years in software development, strong SQL/Python, experience with ETL/ELT, Airflow, RESTful APIs, and a track record in Agile environments.

Qualifications

• Authorized to work in the United States without sponsorship.
• Must be able to complete/pass/hold a federal public trust investigation.
• Must reside in the U.S. for at least 3 years in the past 5 years.
• 8+ years of relevant software development/engineering experience.
• Experience with relational databases, RESTful APIs, and modern development frameworks.

Responsibilities

• Contribute across the software development lifecycle from requirements to production support.
• Monitor and troubleshoot application, pipeline, and integration issues in dev and prod environments.
• Implement application and data pipeline features that integrate with relational databases and AWS services such as S3.
• Build, test, maintain, and enhance full stack applications and data solutions.
• Develop and consume RESTful APIs to support integration between applications and data platforms.
• Build and maintain ETL/ELT data pipelines for batch and near-real-time processing.
• Develop data models, transformations, and workflows in Snowflake.
• Use Apache Airflow to orchestrate data pipelines and workflows.
• Collaborate with infrastructure and application teams to deploy in AWS.
• Partner with cloud engineering and DevSecOps for IaC and CI/CD pipelines.
• Work with cross-functional teams in an Agile environment.

Skills

Full stack development

SQL

Python

ETL/ELT

Snowflake

Apache Airflow

RESTful APIs

Agile

Education

B.S./M.S. in CS/DS/Stats

Tools

Snowflake

AWS

CI/CD

Job description

Fully Remote Remote - Washington DC Metro Area (DMV), MD

Job Type

Full-time

Description

NOTE: This is a full-time employment opportunity. The candidate MUST be authorized to work in the United States without sponsorship and able to complete/pass/hold a public trust investigation. This is a remote opportunity; however, preference is given to candidate local to the DMV area; candidate must be based in the U.S.; have resided in the U.S. for at least 3 years in the past 5 years; ET time zone work schedule.

Daily Responsibilities

• Contribute across the software development lifecycle, including requirements analysis, technical design, implementation, testing, deployment, and production support.
• Monitor and troubleshoot application, pipeline, and integration issues in development and production environments, and document root cause and resolution steps.
• Implement application and data pipeline features that integrate with relational databases and AWS services such as S3 and related cloud resources.
• Build, test, maintain, and enhance full stack applications and data solutions across the front end, back end, and database layers.
• Develop and consume RESTful APIs to support integration between applications, data platforms, and enterprise systems.
• Build and maintain ETL/ELT data pipelines to support batch and near-real-time data processing and implement data transformation workflows that are performant and maintainable.
• Develop and support data models, transformations, and workflows in Snowflake to enable scalable and efficient data processing.
• Use Apache Airflow to orchestrate, schedule, monitor, and troubleshoot data pipelines and automated workflows.
• Collaborate with infrastructure and application teams to deploy, support, and improve solutions in AWS.
• Partner with cloud engineering, DevSecOps, and application teams to implement IaC and CI/CD pipelines for Snowflake objects and deployments.
• Work with cross-functional teams in an Agile environment to deliver application and data solutions that support business and user needs.

Requirements

• Must be authorized to work in the United States without sponsorship.
• Must be able to complete/pass/hold at a minimum a federal public trust investigation.
• Must reside in the U.S. for at least 3 years in the past 5 years. Candidate local to the Washington DC metro (DMV) area is preferred.
• 8+ years of relevant software development/engineering experience as outlined below.
• Experience building full stack applications using modern development frameworks, relational databases, and RESTful APIs.
• Strong hands-on experience designing, building, and maintaining ETL/ELT pipelines and data integration workflows.
• Experience supporting cloud-based applications and data solutions in AWS, including deployment, monitoring, and troubleshooting.
• Experience with SQL and Python for application development, data processing, and integration tasks.
• Experience with Snowflake for data modeling, transformation, and query optimization.
• Experience using Apache Airflow for workflow orchestration, scheduling, and monitoring.
• Excellent analytical skills, attention to detail, and strong problem-solving abilities.
• Experience with analytics, application, and platform teams in an Agile environment.
• Excellent communication and collaboration skills to communicate complex technical or analytical insights to executive and non-technical stakeholders. Ability to translate ambiguous business questions into analytical solutions.
• B.S. or M.S. degree (preferred) in data science, computer science, statistics/mathematics or related field. An additional 4 years of specialized experience may be substituted for a bachelor’s degree

These qualifications are PREFERRED

• Experience supporting federal or regulated environments (e.g., healthcare, or financial systems) is PREFERRED.
• Hands-on experience or extensive training in Big Data platforms and large and complex data sets is PREFERRED.
• Familiar with DevSecOps practices, including secure development, access controls, and auditability is PREFERRED.
• Familiar with SAS is PREFERRED.
• Familiar with Artificial Intelligence (AI) is PREFERRED.

Compensation/rate decisions depend on a wide range of factors, including but not limited to skill sets, experience and training, security clearances, licensure and certifications, and other business and organizational needs. $98k - $140k