Location Atlanta, Georgia; Boston, Massachusetts; Chicago, Illinois; New York, New York; San Francisco, California
Position Type Full time
At the American Cancer Society, we're working to end cancer as we know it, for everyone. Our employees and 1.3 million volunteers are raising the bar every single day. We are a culture comprised of diverse backgrounds and experience, to better serve our communities.
ESSENTIAL FUNCTIONS:
- Design, develop, and orchestrate modern data pipelines and integrations (30%) — Architect and manage scalable data workflows using Azure Data Factory, Snowflake, dbt, and cloud orchestration tools such as Prefect.io or Airflow, ensuring high performance and reliability.
- Implement and manage cloud-based data infrastructure (20%) — Administer and optimize data environments in Microsoft Azure, including Cosmos DB, Snowflake, and related services, performing configuration, monitoring, and cost optimization.
- Develop and deploy advanced data engineering solutions (20%) — Utilize Python for complex data transformation, automation, and performance optimization within robust CI/CD pipelines with comprehensive unit testing and peer code reviews.
- Integrate data from diverse sources (10%) — Leverage ingestion platforms such as FiveTran, Rivery.io, or OpenFlow to streamline and automate data collection from internal and external systems.
- Collaborate with cross-functional teams (10%) — Partner with analytics engineers, data scientists, and business stakeholders to design and refine data models that power research, visualization, and machine learning initiatives.
- Support data governance, security, and documentation (10%) — Implement and enforce best practices for data security, access control, and compliance, including Snowflake user and instance management.
EXPERIENCE/QUALIFICATIONS:
- Minimum Degree Required: Bachelor's Degree in Computer Science, Engineering, Computational Biology, or equivalent experience
- Preferred Degree: Choose an item.
- Certificate(s) or License(s):
- Years of experience: : 3+ years of relevant work experience. 3+ years of building a modern data pipeline, including the ETL, cloud-storage, reporting, and deployment
- Driver’s License Requirement(s) [Included only if driving is part of the job duties]:
KNOWLEDGE, SKILLS, AND ABILITY:
- Advanced proficiency in cloud data engineering within Microsoft Azure, including services such as Azure Data Factory, Azure Databricks, and Cosmos DB; experience with Snowflake for data warehousing and administration.
- Strong expertise in SQL and Python, including development of complex ETL/ELT workflows, automation scripts, and performance-optimized data transformations.