Full Stack Engineer - Cloud, Data Pipelines & Snowflake

Paycom; Milford Mill (MD); On-site; USD 120,000 - 160,000; Full time

Job summary

Index Analytics, LLC is seeking a Full Stack Engineer to build and support cloud-based applications and data solutions across front end, back end, and database layers.

You will develop RESTful APIs, ETL/ELT pipelines, and Snowflake data models, using Apache Airflow for workflow orchestration and AWS for deployment and operations. Collaboration with cross-functional teams in an Agile environment is essential.

Qualifications

• Bachelor's degree or higher required with 8+ years of relevant experience.
• Experience building full stack apps with modern frameworks, relational DBs, and RESTful APIs.
• Experience with SQL and Python for development, data processing, and integration.
• Hands-on experience designing and maintaining ETL/ELT pipelines and data integration workflows.
• Experience with Snowflake for data modeling, transformation, and query optimization.
• Experience using Apache Airflow for workflow orchestration, scheduling, and monitoring.
• Experience supporting cloud-based apps and data solutions in AWS.

Responsibilities

• Build, test, maintain, and enhance full stack applications and data solutions across 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 for batch and near-real-time processing and data transformations.
• Develop and support data models, transformations, and workflows in Snowflake for scalable processing.
• Use Apache Airflow to orchestrate, schedule, monitor, and troubleshoot data pipelines and workflows.
• Collaborate with infra and application teams to deploy, support, and improve solutions in AWS.
• Implement features that integrate with relational databases and AWS services such as S3.
• Partner with Cloud Eng, DevSecOps, and app teams to implement IaC and CI/CD for Snowflake objects.
• Monitor and troubleshoot issues in dev/prod environments and document root cause/resolution.
• Work with cross-functional teams in an Agile environment to deliver solutions.

Skills

SQL

Python

Snowflake

ETL/ELT

RESTful APIs

Airflow

AWS

Data Modeling

Education

Bachelor's degree in Computer Science or related field

Master's degree preferred

Tools

Snowflake

Apache Airflow

AWS

SQL

Python

Job description

Index Analytics, LLC is seeking a Full Stack Engineer to build and support cloud-based applications and data solutions across front end, back end, and database layers.

You will develop RESTful APIs, ETL/ELT pipelines, and Snowflake data models, using Apache Airflow for workflow orchestration and AWS for deployment and operations. Collaboration with cross-functional teams in an Agile environment is essential.