Senior Data Engineer (Snowflake)
Job Description:
As a Senior Data Engineer, you will utilize your strong Cloud with scripting experience to develop solutions in support of FFIO's development squads. This position involves working on an exceptionally talented team whose job is to build platforms and solutions in support of Fidelity's cloud journey.
The ideal candidate for this position will have a strong background in Snowflake, cloud technologies, and the ability to work in a fast-paced agile environment. They will be able to navigate and mange technical complexities while developing secure and scalable solutions for our customers.
The Team
FFIO Snowflake Platform Engineering (PE) team is responsible to support, maintain and govern the platform. This will accelerate build-out of subject areas within Snowflake cloud platform, while ensuring appropriate
adherence to Enterprise and Architectural standards. You will be a key member of the Platform Engineering team who is responsible for building tools and processes to advance the organization's ability to use the public cloud for solving business problems.
The Expertise You Have
- Strong working experience in Snowflake using stored procedures, streams, snow pipes, tasks, stages, storage integration, ingestion frameworks and tools etc.
- Strong hands-on experience with requirements gathering analysis, coding, testing, implementation, maintenance, and review.
- Extensive development experience using Python and other scripting languages (Perl, shell etc.)
- Strong experience in AWS services, IAM, Build Automation & Management, CloudFormation, CI/CD tools and implementing pipelines.
- Proficient in using Amazon Web Services (AWS), extensive experience focusing on services like EC2, EKS, IAM, Lambda, Auto Scaling, KMS, Cloud Watch, CloudFormation, S3 and RDS.
- Good hands-on experience on scheduling tools such as Airflow, Control M, Autosys scheduling tools.
- Good hands-on experience with PL/SQL Oracle programming. (writing sql queries, stored procedure, functions, triggers etc.)
- Strong experience with application Support & resolving production issues.
- Great customer support skills and adaptable to changing business needs.
- Possessing exceptional technical and analytical skills with strong business knowledge.
- Good project management, experience in Agile methodologies (Kanban and SCRUM), communication, and interpersonal skills.
Want more jobs like this?
Get jobs in Durham, NC delivered to your inbox every week.
The Skills You Bring
- Intellectually curious and love learning new skills and capabilities, e.g., new Cloud services
- Enjoy giving to the success of your team while solving difficult technical problems
- Enjoy finding opportunities to innovate and take thoughtful risks to get things done faster
- Truly client-obsessed and dedicated to understanding and learning about customer needs and requirements; both external and internal
- Confident working in an agile environment
- Providing support to the FFIO development community for the products and platforms built by Platform Engineering
Certifications:
Category:
Information Technology
Most roles at Fidelity are Hybrid, requiring associates to work onsite every other week (all business days, M-F) in a Fidelity office. This does not apply to Remote or fully Onsite roles.
Please be advised that Fidelity's business is governed by the provisions of the Securities Exchange Act of 1934, the Investment Advisers Act of 1940, the Investment Company Act of 1940, ERISA, numerous state laws governing securities, investment and retirement-related financial activities and the rules and regulations of numerous self-regulatory organizations, including FINRA, among others. Those laws and regulations may restrict Fidelity from hiring and/or associating with individuals with certain Criminal Histories.
Perks and Benefits
Health and Wellness
- Health Insurance
- Dental Insurance
- Vision Insurance
- Life Insurance
- Short-Term Disability
- Long-Term Disability
- FSA
- HSA
- HSA With Employer Contribution
- Fitness Subsidies
- On-Site Gym
- Pet Insurance
- Mental Health Benefits
- Virtual Fitness Classes
Parental Benefits
- Birth Parent or Maternity Leave
- Non-Birth Parent or Paternity Leave
- Fertility Benefits
- Adoption Assistance Program
- Family Support Resources
- Adoption Leave
Work Flexibility
- Flexible Work Hours
- Remote Work Opportunities
- Hybrid Work Opportunities
Office Life and Perks
- Commuter Benefits Program
- Casual Dress
- Snacks
- Company Outings
- On-Site Cafeteria
- Holiday Events
Vacation and Time Off
- Paid Vacation
- Paid Holidays
- Personal/Sick Days
- Leave of Absence
Financial and Retirement
- 401(K)
- 401(K) With Company Matching
- Company Equity
- Performance Bonus
- Relocation Assistance
- Financial Counseling
- Profit Sharing
Professional Development
- Tuition Reimbursement
- Promote From Within
- Mentor Program
- Shadowing Opportunities
- Access to Online Courses
- Lunch and Learns
- Internship Program
- Work Visa Sponsorship
- Leadership Training Program
- Associate or Rotational Training Program
Diversity and Inclusion
Company Videos
Hear directly from employees about what it is like to work at Fidelity Investments.