Match score not available

Cloud Data Engineer III (Memphis TN or Remote in USA)

EXTRA HOLIDAYS - EXTRA PARENTAL LEAVE

Remote:

Full Remote

Contract:

Full time

Experience:

Mid-level (2-5 years)

Work from:

Tennessee (USA), United States

Offer summary

Qualifications:

Bachelor's Degree in Engineering or IT preferred, Master's Degree with stakeholder experience preferred, Proficient in SQL for development and analysis, Hands-on knowledge of AWS services, Experience with data warehousing structures.

Key responsabilities:

Develop and maintain data processing software
Create and optimize data pipelines and architectures
Perform root cause analysis for improvements
Build and manage data transformation processes
Coordinate with leadership on infrastructure needs

St. Jude Children's Research Hospital - ALSAC Non-profit Organization - Charity Large https://www.stjude.org/

1001 - 5000 Employees

See more St. Jude Children's Research Hospital - ALSAC offers

Job description

Your missions

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

The 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 & 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.