Temporary - Data Engineer

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. 

The people who work at the American Cancer Society focus their diverse talents on our lifesaving mission. It is a calling. And the people who answer it are fulfilled.

ESSENTIAL FUNCTIONS:

• Design, develop, and orchestrate modern data pipelines and integrations (30%) — Architect and manage scalable data workflows usingAzure Data Factory,Snowflake,dbt, and cloud orchestration tools such asPrefect.io orAirflow, ensuring high performance and reliability.
• Implement and manage cloud-based data infrastructure (20%) — Administer and optimize data environments inMicrosoft Azure, includingCosmos DB,Snowflake, and related services, performing configuration, monitoring, and cost optimization.
• Develop and deploy advanced data engineering solutions (20%) — UtilizePython for complex data transformation, automation, and performance optimization within robustCI/CD pipelines with comprehensiveunit testing and peercode reviews.
• Integrate data from diverse sources (10%) — Leverage ingestion platforms such asFiveTran,Rivery.io, orOpenFlow 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 fordata 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
• 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

KNOWLEDGE, SKILLS, AND ABILITY:

• Advanced proficiency in cloud data engineering withinMicrosoft Azure, including services such asAzure Data Factory,Azure Databricks, andCosmos DB; experience withSnowflake 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.
• Hands-on experience with modern orchestration and ingestion platforms such asPrefect.io,Apache Airflow,FiveTran,Rivery.io, orOpenFlow, supporting automated and scalable data movement.
• Proven experience implementing CI/CD practices for data engineering — including automated testing, code reviews, version control (e.g., GitHub/GitLab), and deployment pipelines.
• Experience designing and managing large-scale, high-density data systems, includingstructured, semi-structured, and unstructured data such as genomics, imaging, and biospecimen datasets.
• Familiarity with BI and visualization tools (e.g.,Power BI,Tableau,Looker) and the ability to translate complex research or analytic requirements into optimized data models.
• Strong understanding of healthcare and research data domains, including claims, electronic health records (EHR), survey, and clinical datasets; knowledge of data governance, compliance, and privacy standards (e.g., HIPAA).
• Demonstrated collaboration skills working with data scientists, analytics engineers, and researchers to deliver high-quality, reliable, and well-documented data solutions.

TRAVEL REQUIREMENTS:

• Occasional travel- 10-15% - may be required for department or program/project meetings, vendor management, or enterprise workshops.

PHYSICAL REQUIREMENTS:

• Availability and ability to work after hours, weekends, holidays, etc. as needed, to be on call and/or to fulfill job responsibilities and requirements.

The starting rate is $45 to $48. The final candidate's relevant experience/skills will be considered before an offer is extended. Actual starting pay will vary based on non-discriminatory factors including, but not limited to, geographic location, experience, skills, specialty, and education.

ACS provides staff a generous paid time off policy; medical, dental, retirement benefits, wellness programs, and professional development programs to enhance staff skills. Further details on our benefits can be found on our careers site at:jobs.cancer.org/benefits. We are a proud equal opportunity employer.