Job Description:
Position Description:
Loads, extracts, transforms, and manages data across a wide array of database schemas across diverse content using SQL, R, and Python. Designs and develops dynamic visualizations and data analysis by delivering compelling, interactive, and intuitive Business Intelligence (BI) solutions utilizing Tableau, Power BI and Salesforce. Engages with stakeholders to gather requirements, conducts thorough exploratory analysis, and efficiently uses Snowflake SQL to gather and validate data from multiple views and schemas. Utilizes Jira for story management, ensures seamless coordination and tracking throughout the project lifecycle. Develops strategic capabilities that foster a data driven culture.
Want more jobs like this?
Get jobs in Boston, MA delivered to your inbox every week.
Primary Responsibilities:
- Develops and delivers innovative data visualization and analytic tools focused on driving digitization of service delivering an enhanced customer experience and cost efficiency.
- Provides recommendations to influence strategic decision making based on insights, analysis, and subject matter expertise.
- Creates new processes, performs complex analytical calculations, identifies anomalies, and produces new reporting capabilities by analyzing large, complex data sets and showing mastery of the end-to-end BI process.
- Performs business, systems, and data analysis, detailed process design, and acceptances testing across projects that require new content.
- Plans and manages project schedules and assignments for multiple, concurrent projects that are in a fast-paced environment leading the projects to successful completion in a timely manner.
- Engages with technology partners to ensure the integrity and usability of data being sourced and incorporated into reporting artifacts.
- Resolves various project/technology issues and manages deliverables by holding accountability.
- Garners scope and requirements with stakeholders, documents process logic, and maintains coding standard that helps efficient process implementation.
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 Manager, Data Analytics and Insights (or closely related occupation) performing data analysis and generating recommendations by building BI solutions in the financial services industry, using Snowflake, Power BI, Tableau, and Python.
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 Manager, Data Analytics and Insights (or closely related occupation) performing data analysis and generating recommendations by building BI solutions in the financial services industry, using Snowflake, Power BI, Tableau, and Python.
Skills and Knowledge:
Candidate must also possess:
- Demonstrated Expertise ("DE") transforming data, analyzing data models, and delivering data visualization solutions within a financial services environment, using Tableau, Power BI, Python, MS Visual Studio, and Excel; and developing user stories and acceptance criteria using JIRA and JIRA Align, to be able to manage Kanban board and Scrum meetings as a dual hat Scrum Master.
- DE performing requirements gathering and extracting data from databases - CTEs using MS SQL Server, Snowflake, and Oracle - using SQL/SQL tools; creating reports, BI dashboards, ad-hoc analyses, scoping documentation, and facilitating discussions with business partners, using Excel and PowerPoint; and developing rapid prototyping and analyses.
- DE performing statistical and data analysis - financial transactions, assets, flows, redemptions, and product data analysis - to provide actionable insights and strategic recommendations; developing data visualizations and dynamic and interactive dashboards and analysis to support stakeholder requirements - oversight and risk ad-hoc requests, and implementation of end user adoption of online tools using Power BI.
- DE performing project life cycle execution - engaging with stakeholders to gather requirements, conducting thorough exploratory analysis using SQL, efficiently gathering, and validating data from multiple views and schemas in MS SQL Server/Snowflake, documenting code logic, and maintaining a transparent and efficient project workflow with a focus on optimizing efficiency and ensuring data integrity.
#PE1M2
Certifications:
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 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 all business days of every other week in a Fidelity office.
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.