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 DescriptionThe Cloud Data Engineer III is responsible for developing and maintaining data processing software, data modeling, pipelines, transformations, related databases, and supporting infrastructure. Duties include coordinating with ALSAC leadership and other professionals to create data infrastructure, running tests on designs to isolate errors, and updating systems to accommodate changes in technical and business needs.
- Familiarity with and implementation of dimensional data modeling techniques and data warehousing concepts
- Ability to build and optimize data sets, 'big data' data pipelines and architectures
- Ability to perform root cause analysis on external and internal processes and data to identify opportunities for improvement and answer questions
- Must be proficient with SQL for development and analysis
- Excellent analytic skills associated with working on unstructured datasets
- Ability to build processes that support data transformation, workload management, data structures, dependency and metadata
- Strong hands on knowledge of API integration using services such as AWS Lambda, Mulesoft, SSIS, or Confluent
- Background of sourcing complex data from numerous sources for central processing and analysis within a data lake eco system (ETL / ELT)
- DevOps experience with solid knowledge of CI/CD processes for API deployment and application integration, database source control (Liquibase, DB Up, SSDT) and deployment techniques
- Security minded with experience building compliance aware applications using core AWS data services including S3, Lambda, Glue, Athena, Cloudwatch/Cloudtrail, and VPC configurations
- Extensive understanding and experience in architecting data structrures and dimensional data modeling between and with BOTH SQL Server and AWS (Redshift, etc.).
- Experience working with hybrid DevOps deployments, IaaS TerraForm automation).
- Significant experience managing security structures and protocols in AWS and SQL Server (incl. table and row-level access security)
- Experience building analytical data products from discovery to implementation across business and technical domains.
- Knowledge of data warehousing structures and methodologies including star schemas and data marts
- Technical knowledge of database operations and structures for performant, reliably analytics and reporting
- Strong communication and technical documentation skills including conceptual, logical, and physical modeling.
- Bachelor's Degree with related Engineering and/or information technology preferred.
- Master's Degree with experience working with stakeholders including data, design, product and executive team and assisting them with data-related technical issues preferred.- Experience with Microsoft SQ Server, Airflow, dbt, CData, preferred.- Knowledge of API integration using services such as AWS Lambda, Mulesoft, SSIS, or Confluent, preferred.
- The position will be hybrid at NEO in Memphis, TN, or Remote in the USA)
Benefits & PerksThe following Benefits & Perks apply toFull-Time Roles OnlyWe'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.