Engineer III - Data Cloud (Memphis, TN)

At ALSAC you do more than make a living; you make a difference.

We like people who are different…because we’re different, too. As one of the world’s most iconic and respected nonprofits, we know what it’s like to stand out. That’s why we’re looking at you. Your background, perspective, and desire to make an impact set you apart. As we work to help St. Jude cure childhood cancer, we're calling on the game-changers, innovators and visionaries to join our family. Not just for the kids of St. Jude, but also for you. Because at ALSAC, we develop and celebrate our employees. So, bring your whole, authentic self and become part of our shared mission: Finding cures. Saving children.®

Job Description

As an ALSAC Cloud Data Engineer III, you will design, develop, and maintain scalable data processing software, data modeling, pipelines, transformations, databases, and supporting cloud infrastructure to solve unique and complex business problems. Leveraging the latest AWS cloud technologies and supporting tools, you will drive the development of data engineering solutions, optimize big data pipelines, and ensure security, compliance, and operational efficiency. This role involves collaborating with ALSAC leadership, Data & Analytics teams, Information Technology (IT) Architecture teams, and other stakeholders to create a cloud-native data infrastructure that enhances business value, accelerates time-to-insight, and supports donor acquisition and operational excellence.

You will act as a strategic contributor to the Business Intelligence (BI) Cloud Platform team, providing mentorship to junior engineers (DE I and DE II), recommending reference architectures, and promoting best practices in data lifecycle management, information security, data privacy, and cloud migration strategies. This position requires a balance of hands-on technical expertise, analytical problem-solving, and the ability to distill complex technical concepts for diverse audiences, including business partners with varying levels of technical understanding.

Essential Job Functions:

1. Data Infrastructure Development: Develop and maintain data processing software, dimensional data modeling, big data pipelines, transformations, and related databases using AWS services (e.g., Redshift, S3, Glue, Athena, Lambda) and complementary tools and languages (e.g., Kafka, Spark, Airflow, Python, dbt, CData).

2. Cloud Architecture Design: Lead the design and development of cloud-native architectures, promoting the adoption of AWS services (e.g., RDS, EMR, EC2, DMS) and hybrid strategies for on-premise-to-cloud migrations, including phased cutovers and parallel environments. The ideal candidate will have experience with migration from Microsoft SQL Server to AWS.

3. Strategic Consultation: Provide strategic guidance to Data & Analytics teams, Data Science teams, IT leadership, and business partners on cloud architecture benefits, data protection, capabilities, scalability, and infrastructure needs. Recommend policies, standards, and guidelines to align with ALSAC’s technical and business objectives. This would include collaborating closely with a dynamic Data Governance framework.

4. Data Optimization & Analytics: Build and optimize large datasets and big data pipelines to support self-service analytics, data science use cases, and performance metrics (e.g., operational efficiency, donor acquisition, time-to-insight). Perform root cause analysis to identify improvement opportunities and be intensely focused on quality engineering.

5. Mentorship & Leadership: Act as a lead to Data Engineer I and II, providing training, mentoring, and knowledge transfer on current and target-state data platforms, standard operating procedures (SOPs), and best practices.

6. DevSecOps Implementation: Advise and prototype software, infrastructure, and data engineering delivery through automation, incorporating testing, quality assurance, compliance, and data protection measures for cloud, hybrid, and on-premise workloads.

7. Stakeholder Collaboration: Partner with data, design, product, leadership, and IT teams to resolve complex technical issues, align with enterprise strategies (e.g., Office365, mobility, unified communications), and enhance data availability for customer insights.

8. Risk Mitigation: Identify and mitigate risks to data strategy, privacy, and sustainability, ensuring compliance-aware applications using AWS security services (e.g., IAM, CloudWatch, CloudTrail, KMS, Cyberark).

9. Innovation & Trends: Research emerging technologies, industry trends, and market developments to support product/process/data innovation and operational support activities. Simplify and automate access, deployments, reporting, audits, and data-driven tasks.

10. Communication: Distill and communicate the value of cloud-enabled tools and architectures to audiences of all technical depth, producing written recommendations and insights for senior leadership.

Job Requirements:

• Proficiency in SQL for development and analysis.

• Expertise in dimensional data modeling, data warehousing, and big data pipeline optimization.

• Hands-on experience with AWS core services (e.g., AppFlow, Redshift, S3, Glue, IAM, Athena, Lambda, Step Functions, DMS, CloudWatch).

• Strong knowledge of API integration and ETL/ELT processes within a data lake ecosystem (e.g., AWS Lambda, Mulesoft, SSIS, PySpark, Confluent).

• DevOps experience with CI/CD processes, database source control (e.g., Liquibase, DB Up, SSDT, BitBucket, Flyway), and deployment techniques.

• Familiarity with big data tools, relational/NoSQL databases, and workflow management tools (e.g., Kafka, Spark, MongoDB, DynamoDB, SQL Server, Airflow, Luigi, Azkaban).

• Understanding of stream-processing systems and object-oriented scripting languages (e.g., Spark-Streaming, Kafka Streams, Scala, C++, Java, Python).

• Be a key leader in the growth of the cloud engineering practice at ALSAC.

• Bachelor's Degree with 5-8 years of experience in designing and implementing Infrastructure Architecture for enterprise-grade applications.

• Excellent communication, interpersonal, and organizational skills. Highly self-motivated with strong customer service orientation and team collaboration experience.

• Experience with dbt, Apache Airflow, CData, SageMaker, SQL Server 2019+, and security frameworks/patterns.

• Knowledge of additional AWS services (e.g., CloudTrail, DynamoDB, Parameter Store/Secrets Manager, EMR, AppFlow, SQS, SNS, Kinesis, KMS).

• Background in migrating on-premise SQL Server to AWS and managing VPC configurations.

• Experience with cost management and optimization within the AWS ecosystem.

Location:

• This position will be based at our National Executive Office in Memphis, TN

• The position will be eligible for a hybrid work schedule.

#LI-TM1

Benefits & Perks

The following Benefits & Perks apply to Full-Time Roles Only.

We’re dedicated to ensuring children and their families have every opportunity to enjoy life’s special moments. We’re also committed to giving our staff excellent benefits so they can do the same.

• Core Medical Coverage: (low cost low deductible Medical, Dental, and Vison Insurance plans)​
• 401K Retirement Plan with 7% Employer Contribution
• Exceptional Paid Time Off
• Maternity / Paternity Leave
• Infertility Treatment Program
• Adoption Assistance
• Education Assistance
• Enterprise Learning and Development
• And more

ALSAC is an equal employment opportunity employer. 

ALSAC does not discriminate against any individual with regard to race, color, religion, sex, national origin, age, sexual orientation, gender identity, transgender status, disability, veteran status, genetic information or other protected status.

No Search Firms:

ALSAC does not accept unsolicited assistance from search firms for employment opportunities.  All resumes submitted by search firms to any ALSAC employee or ALSAC representative via email, the internet or in any form and/or method without being contacted and approved by our Employee Experience team and without a valid written search agreement in place will result in no fee being paid if a referred candidate is hired by ALSAC.