Job Description:
The Team
Fidelity's Workplace Investing Reporting and Analytics chapter is seeking a Principal Data Engineer to play a key role in building a Power BI and snowflake-based reporting application.
Team is responsible for building reports in Power BI with Snowflake as the source of data for the reports. It will also develop lot of custom capabilities on AWS
Team needs to work closely with the Enterprise Data Lake (EDL) team for data acquisition for the reports and with the Oracle Analytics Server (OAS) team to migrate the OAS based reports to Power BI.
This person will be self-driven and work with technical partners, and assist developers and testers as needed. The role demands significant collaboration with members of various business and IT groups throughout the lifecycle of a typical project. Our engineering team is innovative, diverse, hardworking, and self-driven. We work in a very dynamic agile environment.
The Expertise You Have
- Bachelor's degree in Computer Science / similar technical subject area and 14+ years' experience.
- Extensive experience in Snowflake and AWS (ideally AWS certified).
- Extensive experience in Python.
- Extensive experience in Data engineering, Data Modeling and Data analysis in a data warehouse environment.
- Experience in Airflow, Oracle, PL/SQL, Informatica/ETL is required.
- Experience in Power BI or OAS is preferred.
- Experience in delivering DaaS (Data as a Service) is preferred.
- Functional/Domain experience of workplace investment plans such as 401k retirement plans is preferred.
The Skills You Bring
- Working in a team of developers and analysts to deliver business value by coordinating with Architects, Analysts and Product owners
- Strong collaboration skills
- Excellent communication skills required
- Strong problem resolution skills required
- Critical thinking and the ability to work in an agile environment
The Value You Deliver
- Accountable for consistent delivery of functional software - sprint to sprint, release to release
- Perfection in software development practices and procedures
- Participates in application-level architecture - able to drive the solution
- Develops original and creative technical solutions to ongoing development efforts
- Responsible for supporting implementation of initiatives
Certifications:
Category:
Information TechnologyFidelity's hybrid working model blends the best of both onsite and offsite work experiences. Working onsite is important for our business strategy and our culture. We also value the benefits that working offsite offers associates. Most hybrid roles require associates to work onsite every other week (all business days, M-F) in a Fidelity office.
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.