Senior It Data Analyst

Position Description:

Writes queries and pulls data from relational databases using SQL using Agile methodologies and practices -- Jira/Jira Align. Gathers business requirements and translates them into data solutions. Defines use cases and simplifies complex concepts relating to data management. Defines user stories and breaks up complex work into digestible work elements. Performs data analysis and participates in projects with diverse scope, including complex business and technical requirements in a multi-platform and highly integrated data environment. Defines and communicates sophisticated concepts of data analysis to technical and non-technical audiences. Navigates integrated enterprise data by working across multi-functional teams.

.

Primary Responsibilities:

Works on various data lakes on platforms.

Collaborates to enable data driven decision making across the Fidelity Institution.

Analyzes science, engineering, business, and other data processing problems to develop and implement solutions to complex applications problems, system administration issues, or network concerns.

Performs systems management and integration functions.

Improves existing computer systems.

Reviews computer system capabilities, workflow, and schedule limitations.

Analyzes or recommends commercially available software.

Expands or modifies system to serve new purposes or improve workflow.

Consults with management to ensure agreement on system principles.

Education and Experience:

Bachelor's degree (or foreign education equivalent) in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and three (3) years of experience as a Senior IT Data Analyst (or closely related occupation) gathering business requirements, developing SQL scripts to extract complex data sets, and identifying, analyzing, and interpreting trends to inform key business decisions.

Or, alternatively, Master's degree (or foreign education equivalent) in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and one (1) year of experience as a Senior IT Data Analyst (or closely related occupation) gathering business requirements, developing SQL scripts to extract complex data sets, and identifying, analyzing, and interpreting trends to inform key business decisions.

Skills and Knowledge:

Candidate must also possess:

Demonstrated Expertise ("DE") analyzing and prioritizing business and functional requirements using Microsoft Word, Microsoft Excel (MS Excel), Power Point, and MySQL; and liaising with business partners to gather user requirements, and analyzing the scope, impact, and dependencies translating them to data solutions, ultimately landing in Amazon Redshift and Excel.

DE performing Extract Transform Load (ETL) on Cloud native data warehousing solutions using analytical tools (Alteryx) and programming languages (Python); building and maintaining data pipelines utilizing Python, CronTab, Linux server, and Jupyter Notebook; and creating scalable visual analytics dashboards using Tableau and Looker.

DE developing SQL scripts to extract large complex datasets and applying data quality checks to improve data quality, consistency, and integrity using PostgreSQL and PL/SQL; and performing advanced calculations on metrics, investigating key business trends, and providing actionable insights to support business growth and decisions using Alteryx and MS Excel.

DE building and automating ad-hoc and recurring daily, weekly, and monthly reports to provide data-driven insights to stakeholders -- sales and digital marketing teams, using MS Excel, Alteryx, Tableau and Python; and conducting performance analysis on marketing and promotional campaigns to effectively measure the return on investment based on key indicators using Google Analytics, Facebook analytics, Spotify Analytics, and YouTube Analytics.

#PE1M2

Company Overview

Fidelity 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 Us

At 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 top 10 Best Place to Work in 2024. 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.

Fidelity's working model blends the best of working offsite with maximizing time together in person to meet associate and business needs. Currently, most hybrid roles require associates to work onsite all business days of one assigned week per four-week period (beginning in September 2024, the requirement will be two full assigned weeks).

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, detailed in this document, 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.

We invite you to Find Your Fidelity at fidelitycareers.com.

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 accommodations@fmr.com, or by calling 800-835-5099, prompt 2, option 3.