The OpportunityWe are looking for an experienced AWS and Nucleus Implementation Specialist to join the Solution Engineering team. The ideal candidate will have strong hands-on experience building and implementing data platform solutions on AWS and Nucleus (Snowflake), with the ability to design reusable patterns, accelerators, and engineering best practices. This role will contribute to the development of innovative solutions, reference architectures, and implementation frameworks that accelerate adoption and delivery across enterprise data initiatives.
The Work Itself- Design, develop, and optimize Snowflake-based data architectures.
- Implement ETL/ELT processes using Snowflake Snowpipe, Streams, and Tasks.
- Write efficient SQL queries for data transformation and analytics.
- Develop Python scripts for automation, data processing, and integration with Snowflake.
- Work with cloud platforms like AWS for Snowflake deployment and management.
- Optimize query performance and storage costs in Snowflake.
- Ensure data security, governance, and compliance with best practices.
- Collaborate with data engineers, analysts, and business teams to meet data requirements.
Minimum Qualifications:
- 3+ years of relevant experience
- Bachelor's Degree in Computer Science, Data Engineering, or equivalent
Qualifications We're Looking For- 5+ years of hands-on experience with Snowflake data warehousing.
- Strong proficiency in SQL and performance tuning on Snowflake.
- Python programming experience for data processing and automation.
- Experience with ETL/ELT workflows and data pipeline orchestration.
- Knowledge of cloud services (AWS) and Snowflake integrations.
- Familiarity with CI/CD pipelines, version control (GitLab), and DevOps practices.
- Strong understanding of data security, encryption, and governance in Snowflake.
- Excellent problem-solving skills and the ability to work independently.
- Experience with Airflow, DBT, or other orchestration tools.
- Familiarity with API integrations and data ingestion from various sources.
- Knowledge of big data technologies like Spark or Kafka.
How We'll Have Your BackAlly's compensation program offers market-competitive base pay and pay-for-performance incentives (bonuses) based on achieving personal and company goals. Our Total Rewards program includes industry-leading compensation and benefits plus additional incentives that are designed to meet your needs and those of your family so you can get the most out of your career and your life, including:
Time Away: Program starts at 20 paid time off days in addition to 11 paid holidays and 8 hours of volunteer time off yearly (time off days are prorated based on start date and program varies based on full or part-time status and management level).
Planning for the Future: plan for the near and long term with an industry-leading 401K retirement savings plan with matching and company contributions, student loan pay downs and 529 educational save up assistance programs, tuition reimbursement, employee stock purchase plan, and financial learning center and financial coach access.
Supporting your Health & Well-being: flexible health and insurance options including medical, dental and vision, employee, spouse and child life insurance, short- and long-term disability, pre-tax Health Savings Account with employer contributions, Healthcare FSA, critical illness, accident & hospital indemnity insurance, and a total well-being program that helps you and your family stay on track physically, socially, emotionally, and financially.
Building a Family: adoption, surrogacy and fertility assistance as well as paid parental and caregiver leave, Dependent Day Care FSA back-up child and adult/elder care days and childcare discounts.
Work-Life Integration: other benefits including Mentally Fit Employee Assistance Program, subsidized and discounted Weight Watchers® program and other employee discount programs.
Other Compensations: depending on the role for which you are considered, you may be eligible for travel allowances, relocation assistance, a signing bonus and/or equity.
To view more detailed information about Ally's Total Rewards, please visit this link: https://www.ally.com/content/dam/pdf/corporate/ally-total-rewards-snapshot.pdf
Base Pay Range$85,000.00 - $150,000.00
An individual's position in the range is determined by the specific role, the scope and responsibilities of the role, work experience, education, certification(s), training, and additional qualifications. We review internal pay, the competitive market, and business environment prior to extending an offer.
Incentive Compensation: This position is eligible to participate in our annual incentive plan.