Full Stack Engineer (51387)

Index Analytics; Baltimore (MD); On-site; USD 130,000 - 170,000; Full time

Job summary

Index Analytics LLC, based in Baltimore, seeks a Senior Full Stack Engineer to build, enhance, and support cloud-based applications and data solutions across the frontend, backend, and database layers. You will turn business requirements into reliable, well-tested software and create RESTful APIs to enable integration with data platforms and enterprise systems.

You will develop ETL/ELT pipelines, build Snowflake data models, and orchestrate workflows with Apache Airflow, while collaborating with

Qualifications

• US citizen or authorized to work in the US and able to obtain a U.S. federal government badge.
• Eight+ years of relevant experience with a Bachelor’s degree, or six+ years with a Master’s degree; four years may substitute for a Bachelor's.
• Experience building full stack applications with modern frameworks, relational databases, and RESTful APIs.
• Experience with SQL and Python for development, data processing and integration tasks.
• Hands-on experience designing, building, and maintaining ETL/ELT pipelines and data workflows.
• Experience with Snowflake for data modeling, transformation, and query optimization.
• Experience using Apache Airflow for workflow orchestration, scheduling, and monitoring.
• Experience supporting AWS-based applications and data solutions, including deployment and troubleshooting.
• Strong communication skills and collaboration with analytics, application, and platform teams in Agile environments.

Responsibilities

• Build, test, maintain, and enhance full stack applications and data solutions across front end, back end, and database layers.
• Contribute across the software development lifecycle from requirements to production support.
• Develop and consume RESTful APIs to enable integration between applications and data platforms.
• Build and maintain ETL/ELT pipelines for batch and near-real-time data processing.
• Develop data models and transformations in Snowflake for scalable data processing.
• Use Apache Airflow to orchestrate, schedule, monitor, and troubleshoot pipelines.
• Collaborate with infrastructure and application teams to deploy and support solutions in AWS.
• Implement features that integrate with relational databases and AWS services (S3, etc.).
• Partner with Cloud Engineering, DevSecOps, and application teams to implement IaC and CI/CD for Snowflake objects.
• Monitor and troubleshoot issues in development and production environments; document root cause/resolution.
• Work with cross-functional teams in Agile environments to deliver solutions that meet business needs.

Skills

Full stack development

RESTful APIs

Python

SQL

ETL/ELT pipelines

Agile

Communication

Education

Bachelor's degree

Master's degree

Tools

Snowflake

Apache Airflow

AWS

Job description

Index Analytics, LLC, is a rapidly growing, Baltimore-based small business providing health-related consulting services to the federal government. At the center of our company culture is a commitment to instilling a dynamic and employee-friendly place to work. We place a priority on promoting a supportive and collegial team environment and enhancing staff experience through career development and educational opportunities.

Position Summary

We're looking for a Full Stack Engineer to help build, enhance, and support cloud-based applications and data solutions across the front end, back end, and database layers. Working closely with engineers, product stakeholders, and cross-functional partners, this person will turn business requirements into reliable, well-tested solutions; build and integrate RESTful APIs; and develop data pipelines and application workflows that support analytics and operational use cases.

Responsibilities

• Build, test, maintain, and enhance full stack applications and data solutions across the front end, back end, and database layers.
• Contribute across the software development lifecycle, including requirements analysis, technical design, implementation, testing, deployment, and production support.
• 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.
• Implement application and data pipeline features that integrate with relational databases and AWS services such as S3 and related cloud resources.
• Partners with Cloud Engineering, DevSecOps, and application teams to implement infrastructure as code (IaC) and CI/CD pipelines for Snowflake objects and deployments
• Monitor and troubleshoot application, pipeline, and integration issues in development and production environments, and document root cause and resolution steps.
• Work with cross-functional teams in an Agile environment to deliver application and data solutions that support business and user needs.

Qualifications

REQUIRED

• US citizen or Authorized to Work and lived in the US for 3 of the last 5 years. Must be able to obtain a U.S. Federal government client badge and pass a government Public Trust.
• Requires a minimum of eight (8) years of relevant experience with a Bachelor’s degree, or a Master’s degree with at least six (6) years of experience. Four (4) years of specialized experience may be substituted for a Bachelor’s degree.
• Experience building full stack applications using modern development frameworks, relational databases, and RESTful APIs.
• Experience with SQL and Python for application development, data processing, and integration tasks.
• Hands-on experience designing, building, 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 applications and data solutions in AWS, including deployment, monitoring, and troubleshooting.
• Strong communication skills and experience collaborating with analytics, application, and platform teams in an Agile environment.

PREFERRED

• Hands-on experience or extensive training in Big Data platforms and large and complex data sets.
• Familiarity with Artificial Intelligence (AI).
• Familiarity with DevSecOps practices, including secure development, access controls, and auditability.
• Familiarity with SAS is a plus.
• Prior experience with Center for Medicare Medicaid Services or other government agencies.

About INDEX ANALYTICS LLC

Why Join Index?

Index offers opportunities to reach your potential and join a community of great minds with national impact. Watch this video for a glimpse at what makes us a top-tier employer!