Job Description:
Position Description:
Transforms data into information for decision support through the development of reports and dashboards using Business Intelligence software and supporting the underlying technology infrastructures. Designs, develops, and delivers high quality, timely, and maintainable software solutions in an Agile environment. Designs and delivers data lake, data warehouses, and reports platforms using SQL and Python. Transforms data into actionable insights and reports using Tableau, Power BI, and OBIEE or similar BI tool like Business Objects. Generates reports from data warehouses and Business Intelligence (BI) tools. Architects and navigates database tables and objects.
Primary Responsibilities:
Want more jobs like this?
Get jobs in Merrimack, NH delivered to your inbox every week.
- Complete report development, business analytics, business intelligence or comparable data engineering.
- Development and delivery of high quality, timely, and maintainable reporting capability in an agile environment to meet functional and non-functional business requirements.
- Develop dashboards, reports, tables, graphs and charts with OBIEE and BI Publisher.
- Complete database analysis using SQL and procedural logic (PL/SQL, T-SQL).
- Work with Data Warehouse and Dimensional Modeling (star-schema).
- Participate in the definition of the BI delivery strategy, standards and support tools.
- Complete statistical analysis using R or Python scripting.
Education and Experience:
Bachelor's degree (or foreign education equivalent) in Computer Science, Engineering Management, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and three (3) years of experience in the job offered or three (3) years of experience performing Business Intelligence reporting and platform maintenance using OBIEE or similar BI tools - Business Objects in a financial service environment.
Or, alternatively, Master's degree (or foreign education equivalent) in Computer Science, Engineering Management, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and one (1) year of experience in the job offered or one (1) year of experience performing Business Intelligence reporting and platform maintenance using OBIEE or similar BI tools - Business Objects in a financial service environment.
Skills and Knowledge:
Candidate must also possess:
- Demonstrated Expertise ("DE") creating, testing and automation of reports, graphs, and dashboards; and scheduling automation jobs on server, understanding platform security and maintaining user access management in OBIEE or BI similar tools - Business Objects.
- DE understanding the Data Warehouse architecture and Dimensional Modeling concepts (STAR, Snowflake Schemas) to deliver clean and consistent data; and design, implement and support platforms that provide users access to large datasets.
- DE using SQL(T-SQL) programming language for developing new requirements and data analysis; and querying data from databases - Oracle or Snowflake - and connect to BI tools to convert data into information.
- DE analyzing, planning, designing, developing, testing, deploying, and supporting legacy and dimensional data warehouse, using BI tools- PowerBI or OBIEE or similar BI tools - Business Objects.
#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. Having the majority of our associates work onsite is important for our business strategy and our culture. We also value the benefits that working offsite offers associates. Most roles listed as Hybrid will require associates to work onsite all business days of every other week in a Fidelity office. This does not apply to roles listed as Remote or Onsite.
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.