Principal - Data Engineer

Job Description:

Job Title – Principal – Data Engineering / Database Administration

A value focused professional who can deliver benefits to the organization and gain from the Organization’s wealth of data and experience.

The Purpose of This Role

The FFIO Data Technology Services team provides Data services to the FFIO business unit. The team provides Database support, Design and Development support to Product Development teams and manages the data environments efficiently in the Cloud and on-premise environments. Apart from this, the Data Technology Services team also builds capabilities that help in increasing efficiency of the database platforms and increases productivity of the teams.  In this role, you will be working with multiple teams including Architects, Product Development teams, Enterprise Cloud and Security teams.

The Value You Deliver

• You will use your experience and subject matter expertise to help the product teams implement the best practices from a data perspective.
• You will interact with the product teams and provide technology guidelines / capabilities that contribute to their development and support activities.
• You will leverage your experience in providing analytical inputs and insights to the team when needed and your overall guidance to the team in line with the Business Unit priorities.
• Your experience and expertise will be leveraged by teams in their areas.
• You will define, own and drive initiatives within the team that increase productivity and add value in alignment with the Business Unit and Team priorities. Some examples include self service capabilities, automation of regular activities and reporting insights regularly.
• You have a very good understanding of the Cloud environments (AWS) and have managed large scale environments in Cloud.

The Skills that are Key to this role

Technical / Behavioral

            Demonstration of Experience and Expertise in the following areas.

• Collaborate with the Architecture teams on understanding the Application / Data requirements and providing necessary inputs or seeking clarifications.
• Work with Application Development and Performance Teams on Data & Database components in the Design, Development, Testing & Deployment phases in the areas of Oracle SQL and PLSQL, Snowflake, Aurora PostgreSQL & Golden Gate
• Extensive Hands-On Experience and Subject Matter Expertise of Oracle Performance Tuning, SQL Tuning and Snowflake
• Good Understanding of the Application schemas, their contribution to the business functions and the operational aspects of the applications.
• Application Areas such as Schema Design, Data Models, Best Practices & Database Features
• Identify opportunities on the Application side where the team can contribute to the Data Engineering activities within the application through automation capabilities.
• Proactively identify opportunities for automation and Optimization
• Challenge current state where applicable and be self-motivated to contribute to the solution & collaborate with other team members.
• To identify and execute improvements in database services, through automation, self-service enablement, and process improvements.
• Participate in Design reviews specific to Data components.
• Participate in level 3 on-call rotation to support critical applications based on business requirements.
• Work with multiple projects and product teams simultaneously.
• Traditional Database Technologies – Oracle, DB2 UDB, MS SQL Server, Sybase
• Big Data Technologies Exposure – No SQL Databases such as Cassandra, MongoDB
• AWS Cloud Technologies such as RDS, EC2, EKS
• AWS Cloud Concepts
• Excellent troubleshooting and error analysis skills
• Working knowledge of Information Security concepts
• Solid understanding of software development lifecycle
• Exceptional customer service skills
• Ability to learn and adapt to new technologies.
• Ability to work in fast paced, highly demanding environment.
• Exceptional Communication skills with the ability to articulate thoughts based on the audience level (from the Developer to the Senior BU Leadership)
• Qualified applicant should have 15+ years of Database Support, Design, Performance & Tuning experience working in a complex, multi-platform environment and should have done production support.

The Skills that are Good to Have for this role.

• Strong verbal and written communication skills, both technical and non-technical
• Ability to communicate based on the target audience.
• Agile Methodology

How Your Work Impacts the Organization

The FFIO (Fidelity Fund and Investment Operations) Technology Group is responsible for delivering top quality scalable systems solutions for the Asset Management business functions within Fidelity Investments.  The FFIO Technology Platform consists of mainframe and distributed architecture including multiple interfaces both internal and external to the FFIO Organization.  The systems employed include the source fund accounting, pricing, tax, and data exchange platforms. The data is sourced from multiple accounting, trading, and reference data systems within Fidelity, stored in central database and shared with internal or external customer groups through system-to-system interfaces to support fund setup, reporting, analytic and oversight functions. The DTS team has visibility to senior management by virtue of their activities and their impact.

The Expertise We’re Looking For

• Bachelors or Masters Engineering Degree or any equivalent degree with the relevant experience.
• 12-15 years of relevant experience.

Certifications:

Category: