Supports all reporting platforms using Tableau, Power BI, and OBIEE. Performs Proof of Concept (POC) for new tools in the semantic and reporting layers. Deploys reports, dashboards, and changes to semantic layer using data analytics, data visualization, and business intelligence tools. Constructs SQLs against Snowflake and Oracle databases in a scaled Agile environment.
Requirements
- administering and coordinating Business Intelligence (BI) solutions using Analytic Tools (SAP Business Objects, Oracle Advanced Services (OAS, formerly OBIEE), Tableau, Microsoft Power BI, Report Builder, SAP BW, and SAP BO)
- performing security implementations by installing and optimizing configurations for BI servers, components, and processes using BI access roles, groups, and permissions
- migrating BI content to Snowflake Cloud data warehouses
- evaluating Cloud offerings for BI tools, and migrating BI platforms to public Cloud and Amazon Web Services platform using AWS EC2, S3, IAM, GitHub, and Jenkins pipelines
- conducting data analysis, data exploration, and data lineage of financial data on Oracle, Snowflake, IBM DB2, AtScale (Universal semantic layer), SAP BW, and Tableau metadata
- writing SQL queries and scripts to extract data from large data sets within RDBMS Oracle and IBM DB2
- writing stored procedures to insert and maintain data using SQL queries
Responsibilities
- Creates complex dashboards and reports.
- Maintains connections to data and semantic layers.
- Deploys reports and dashboards to production.
- Creates and maintains connections to the data layer.
- Performs regression testing for server upgrades and patches.
- Develops complex data integration reporting solutions resulting in advanced analytic capabilities.
- Constructs SQLs against Snowflake and Oracle databases
Other
- Partners closely with a diverse set of business collaborators to deliver reporting solutions.
- Confers with data processing or project managers to obtain information on limitations or capabilities for data processing projects and determines system performance standards.
- creating projects stories, epics, backlogs, and references using enterprise tools (JIRA and Confluence) to execute project deliverables.
- Most roles at Fidelity are Hybrid, requiring associates to work onsite every other week (all business days, M-F) in a Fidelity office.
- Fidelity’s business is governed by the provisions of the Securities Exchange Act of 1934, the Investment Advisers Act of 1940, the Investment Company Act of 1940, ERISA, numerous state laws governing securities, investment and retirement-related financial activities and the rules and regulations of numerous self-regulatory organizations, including FINRA, among others. Those laws and regulations may restrict Fidelity from hiring and/or associating with individuals with certain Criminal Histories.
