Principal/Sr. DB Data Analyst

Company: Fidelity Investments
Location: Durham
Posted on: May 26, 2023

Job Description:

Job Description: The Role Do you enjoy the challenge of solving problems? Do you have a solid ability to identify big picture ideas/concepts and translate those into well-defined and executable solutions? Are you energized working in a fast-paced environment where no two days are the same? If so, the Principal DB Data Analyst may be the right next step in your career. The Team Data Consulting is a group within Fidelity Workplace Investing built to serve and partner with Fidelity's strategic clients on their data and technology needs. The Data Technology Team's dynamic and diverse skills are leveraged to complete sophisticated and exciting projects in partnership with both internal and external partners.We design and build customized solutions to address unique scenarios on behalf of clients. We extract data from a variety of sources (Snowflake, SQLMI, client feeds/files, etc.), transform the data, then output the results based on requirements.Our team engages across Workplace Consulting in data quality improvement efforts that span single and multiple product lines (i.e. Health and Welfare, Defined Benefit, Defined Contribution, Stock Plan Services).We are seeking an experienced Defined Benefits Analyst, however, there will be opportunities to grow your knowledge and gain experience working with the other WI products! The Expertise You Have and The Skills You Bring

• Proficient knowledge of SQL. Ability to write efficient and highly optimized queries across large volumes of data
• Proficiency with ETL methods and tools - Informatica and Snap Logic preferred; experience with cloud based ETL tools a plus (e.g. Azure Data Factory)
• Knowledge of Fidelity's backend product tables (DBR1, WIDE, Snowflake, etc.) a plus
• Proven background with Microsoft Office products
• Strong domain knowledge of the WI Defined Benefit business
• Experience in a benefit's outsourcing or consulting role
• A willingness to find uncommon solutions to fix complex problems.
• Ability to work independently with minimal oversight
• You are comfortable working with data and databases
• Your analytical and problem-solving skills are a key strength and have great attention to detail.
• You work well in teams and collaborate with others to tackle problems.
• You proactively communicate when a project deliverable or requirements are not clear.
• You take ownership of your work and complete it with quality and efficiency
• Learning new tools and innovative ways of doing things is exciting and interesting to you
• You are comfortable reviewing the output of others and providing feedback
• Knowledge of Jira is a plus The Value You Deliver
  • Build solutions that are well documented and easy to support once complete.
  • Integrating with many different systems and lines of business to solve problems and provide custom solutions to your clients' challenges.
  • Working with consultants across Data, Healthcare, Retirement, Communications and Administration consulting practices on a wide variety of projects, you will be designing and maintaining applications, identifying data issues and root cause which you will help your clients resolve. 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 Glassdoor Employees' Choice Award , 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 " Dynamic Working ". 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 , prompt 2, option 3. We welcome those with experience in jobs such as Scientist, Researcher, and Research Assistant and others in the Science and Biology to apply.

Keywords: Fidelity Investments, Durham , Principal/Sr. DB Data Analyst, Professions , Durham, North Carolina