Job Description:
Position Description:
Identifies, promotes, and implements best practices for data modeling, using open-source database solutions and using Snowflake, Oracle, and SQL Server technologies. Performs data analysis using Business Intelligence (BI) visualization tools such as Tableau and Power BI. Facilitates the maintenance of data models within Software Development Lifecycle (SDLC) environments - Agile. Expands or modifies system to serve new purposes or improve workflow. Consults with management to ensure agreement on system principles.
Primary Responsibilities:
- Designs and implements data architecture solutions that support the organization's strategic goals.
- Works closely with business stakeholders to gather and analyze data and business requirements.
- Creates reports and dashboards using BI tools such as Tableau, Power BI, and MicroStrategy Dossier. Creates data visualizations to help business stakeholders understand their data.
- Performs complex data analysis tasks using SQL, Python, and other tools.
- Develops and maintains data quality rules and processes, identifying, and resolving data quality issues, and monitoring data quality metrics to ensure data accuracy, completeness, and consistency.
- Collaborates with cross-functional teams.
- Evaluates new trends and technologies in data analytics, evaluate their potential impact on the organization, and recommend new technologies and processes that can enhance the efficiency and effectiveness of data analytics.
- Partners with key stakeholders to understand business questions and to design and deliver analytic reports.
- Collaborates with team members to develop visualization and improve data and analytics usage across the business.
- Designs, conducts, and evaluates experimental operational models in cases where models cannot be developed from existing data.
- Performs validation and testing of models to ensure adequacy and reformulating models as necessary.
Want more jobs like this?
Get Data and Analytics jobs in Merrimack, NH delivered to your inbox every week.
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) performing business intelligence data warehousing development using Snowflake and Tableau.
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) performing business intelligence data warehousing development using Snowflake and Tableau.
Skills and Knowledge:
Candidate must also possess:
- Demonstrated Expertise ("DE") performing data conversion for defined benefits data services using Snowflake and Oracle SQL Server; using SQL Server to extract, transform, and load data from various sources to create clean and consistent datasets; using Tableau for data conversion, analysis, and visualization; analyzing data formulas within a defined benefits calculation engine, using SQL; analyzing complex data sets to identify patterns and trends using SQL, Tableau, and Power BI; and creating custom SQL queries to extract and manipulate data.
- DE designing and developing Business Intelligence (BI) solutions using Tableau and MicroStrategy Dossier; creating dashboards and reports that effectively communicate insights to clients using Tableau and Power BI; leveraging various data sources to create interactive dashboards for users, using Tableau; creating custom visualizations, calculations, and filters that allow users to easily analyze data and make informed decisions, using Tableau and Power BI; creating and managing data connections, building metrics and attributes, and customizing visualizations to meet clients' specific needs, using MicroStrategy Dossier; and delivering high-quality, client-ready reports and dashboards that drive data-driven decision-making using Tableau and Power BI.
- DE building Dynamic Row-level security (RLS) in Tableau and implementing it on Tableau Server; actively monitoring Tableau dashboards through usage metrics applications and identifying areas of improvement; managing and creating AD groups to efficiently provide access to a large group of individuals; configuring conditional access to Tableau resources through the Admin Portal to ensure secure access to data for authorized users; and using REST APIs for embedded analytics and automation.
- DE working with business users to create technical documents, project plans, and data models using confluence, SharePoint, and JIRA Align tools; gathering and analyzing requirements from stakeholders and translating them into actionable project plans and technical documentation using SharePoint and JIRA tools; performing unit, functional, and system integration testing; creating test plans, test cases, and test scripts to ensure the quality of deliverables using SharePoint data mapping documents, SQL, and Tableau tools.
#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 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.