Snowflake AWS Data Engineer

RedSail Technologies

Spartanburg, SC

Full Time

Mid Level

8 days ago

Job Description

About the Role

The Snowflake AWS Data Engineer will play a critical role in building and maintaining modern data pipelines and infrastructure, with an emphasis on Snowflake on AWS to enable scalable, reliable, and secure access to clinical and operational data. This position is part of the Advantage Solutions Business Unit at RedSail Technologies, which focuses on creating incremental value streams through the development and activation of Clinical, Financial, and Operational Programs leveraging integrated technology platforms and targeted market segments. The role involves working in a remote environment to support data infrastructure, pipelines, and analytics for healthcare-related data systems.

Key Responsibilities

Designing and managing data infrastructure using Snowflake on AWS, ensuring performance, scalability, and data integrity across environments.
Building and optimizing data pipelines and workflows using tools such as Apache Airflow for scheduling and orchestration.
Collecting and storing data through manual and automated processes, including establishing secure connections to both static and dynamic enterprise data sources.
Improving efficiency and quality of data infrastructure through a cycle of continuous quality improvement and automation.
Developing and updating technical documentation, including data dictionaries, schema references, and pipeline documentation.
Organizing and exporting data required by external business associates, and participating in programmatic development of related solutions.
Automating data exports and reporting required by contractual obligations or for internal descriptive analytics.
Extracting, transforming, and aggregating data for business intelligence systems, including individual pharmacy dashboards.
Preparing structured and unstructured datasets to support machine learning use cases for predictive and prescriptive analytics.
Collaborating with cross-functional teams to identify data needs and translate them into scalable engineering solutions.

Requirements

Bachelor's degree in Data Engineering, Data Science, Computer Science, or a related technical field.
3+ years of experience as a Data Engineer.
Hands-on experience with Snowflake, particularly in a cloud-native AWS environment.
Proficiency in SQL and working with relational databases.
Familiarity with CI/CD tools and processes (e.g., Git, SVN).
Experience working with PHI/PII and secure data handling.
Proficiency in Python or R for data processing and scripting.
Ability to transform complex, multi-source data into actionable datasets.
Comfortable working both independently and collaboratively.

Nice to Have

Master's Degree in a related field.
Experience with healthcare data and pharmacy transaction systems.
Advanced experience with AWS services such as S3, Lambda, Redshift, or Glue.
Familiarity with object-oriented programming languages (e.g., Go, Java, C#).
Experience with data de-identification platforms, especially Datavant.
Understanding of HIPAA compliance requirements and best practices.

Working at RedSail Technologies

The position offers a flexible work environment, including remote work options, with a focus on leveraging technology and data to create value in healthcare and operational systems. The company emphasizes ethical data handling, continuous improvement, and collaboration across teams.

Apply Now