Principal, Data Engineer

Company: Fidelity Investments
Location: Durham
Posted on: September 18, 2023

Job Description:

Job Description:
Implementation Lead The RoleWe have an outstanding technology opportunity in the Data Engineering Chapter to deliver modern data solutions to the Fidelity Corporate Technology Group (CTG). As Principal Data Engineer you will lead the design and development of data services in support of Compliance, Risk & Audit, Surveillance & Supervision applications.
The Expertise and Skills You Bring

• Bachelors or Masters in a technology related field (e.g. Computer Science, Engineering etc.) required.
• 12+ years of related experience in data engineering, analysis, data warehouses, data lakes. Specialist understanding and experience of methodologies like data warehousing, data visualization and data integration.
• Strong experience with relational database technologies (Oracle SQL & PL/SQL or similar RDBMS), preferably Snowflake or other Cloud Data warehousing services.
• Strong expertise in all aspects of data movement technologies (ETL/ELT) and experience with schedulers.
• Practical experience delivering and supporting Cloud strategies including migrating legacy products and implementing SaaS integrations.
• Proven experience in understanding multi-functional enterprise data, navigating between business analytic needs and data, and being able to work hand-in-hand with other members of technical teams to complete product roadmaps to enable new insights with our data.
• Crafted and implemented operational data stores, as well as data lakes in production environments.
• Experience with DevOps, Continuous Integration and Continuous Delivery. Developing and deploying pipelines. Deploying within a cloud native infrastructure would be advantageous.
• Able to work collaboratively with a geographically diverse team.
• Proven track record of working in collaborative teams to deliver high quality data solutions in a multi-developer agile environment following design & coding best practices.
• Outstanding SQL skills and experience performing deep data analysis on multiple database platforms.
• Ability to develop ELT/ETL pipelines to move data to and from Snowflake data store using combination of Python and Snowflake SnowSQL.
• Knowledge and expertise of data modelling techniques and best practices (Relational, Dimensional), plus any prior experience with data modelling tools (eg. PowerDesigner).
• Prior experience with Data ingestion tool sets (e.g Apache NiFi, Kafka) is required.
• Experience in working with AWS, MS Azure or other cloud providers. Experience with AWS services such as Lambda or S3, AWS Certification.
• Experience in Data Architecture (Database design, performance optimization).
• Prior experience in setting up reliable infrastructure (Hardware, Scalable data management systems, and frameworks) to perform data-related tasks, particularly with Kafka.
• Understanding basics of distributed systems and Kubernetes.
• Strong Focus on resiliency & reliability.
• You have excellent written and oral communication skills.
• Nice to have: Scripting/coding experience in any of the following: Python, Unix, Java.
• Simplifying and effectively communicating technical challenges, solutions options, and recommendations to business partners and technology leadership.
• Provide technical leadership and support in data and solutioning to team members (coaching others to their full potential).
• Produce scalable, resilient, cloud-based systems design aligned with our long-term strategy.
• Collaborate with chapter leads, squad leads, tech leads and architects on setting the technical roadmaps.
• Recognizing opportunities to bring emerging technologies to deliver innovative solutions to meet business challenges.
• Understand detailed requirements and deliver solutions that meet or exceed customer expectations.
• Take ownership and accountability.
• Adaptability to a changing and challenging workload.
  
  Company Overview At Fidelity, we are passionate about making our financial expertise broadly accessible and effective in helping people live the lives they want!\u00A0 We are a privately held company that places a high degree of value in creating and nurturing a work environment that attracts the best talent and reflects our commitment to our associates. We are proud of our diverse and inclusive workplace where we respect and value our associates for their unique perspectives and experiences. For information about working at Fidelity, visit FidelityCareers.com.\u00A0 Fidelity Investments is an equal opportunity employer.Fidelity will reasonably accommodate applicants with disabilities who need adjustments to complete the application or interview process. Please email us at or call 800-835-5099, prompt 2, option 2 if you would like to request an accommodation.
  Please see below for the salary range for work locations in Colorado only:N/A
  
  Please see below for the salary range for work locations in New York City, Westchester County, NY and Jersey City, NJ only:N/A
  
  Please see below for the salary range for work locations in California only:N/A
  
  Please see below for the salary range for work locations in Washington only:N/A
  
  Certifications:
  Company OverviewFidelity Investments is a privately held company with a mission -to strengthen the financial well-being of our clients. -We help people invest and plan for their future. We assist companies and non-profit organizations in delivering benefits to their employees. And we provide institutions and independent advisors with investment and technology solutions to help invest their own clients' money.Join UsAt Fidelity, you'll find endless opportunities to build a meaningful career that positively impacts peoples' lives, including yours. You can take advantage of flexible benefits that support you through every stage of your career, empowering you to thrive at work and at home. Honored with a -, we have been recognized by our employees as a Best Place to Work in 2023. And you don't need a finance background to succeed at Fidelity-we offer a range of opportunities for learning so you can build the career you've always imagined.At Fidelity, our goal is for most people to work flexibly in a way that balances both personal and business needs with time onsite and offsite through what we re calling \u201C\u201D. Most associates will have a hybrid schedule with a requirement to work onsite at a Fidelity work location for at least one week, 5 consecutive days, every four weeks. These requirements are subject to change.We invite you to -Find Your Fidelity -at -.Fidelity Investments is an equal opportunity employer. We believe that the most effective way to attract, develop and retain a diverse workforce is to build an enduring culture of inclusion and belonging.Fidelity will reasonably accommodate applicants with disabilities who need adjustments to participate in the application or interview process. To initiate a request for an accommodation, contact the HR Accommodation Team by sending an email to -, or by calling 800-835-5099, prompt 2, option 3.At Fidelity, we value honesty, integrity, and the safety of our associates and customers within a heavily regulated industry. Certain roles may require candidates to go through a preliminary credit check during the screening process. Candidates who are presented with a Fidelity offer will need to go through a background investigation and may be asked to provide additional documentation as requested. This investigation includes but is not limited to a criminal, civil litigations and regulatory review, employment, education, and credit review (role dependent). These investigations will account for 7 years or more of history, depending on the role. Where permitted by federal or state law, Fidelity will also conduct a pre-employment drug screen, which will review for the following substances: Amphetamines, THC (marijuana), cocaine, opiates, phencyclidine.

Keywords: Fidelity Investments, Durham , Principal, Data Engineer, Engineering , Durham, North Carolina