Fidelity needs to build structured and organized representations of data for efficient data storage and retrieval, create data mapping specifications and data models for large reporting platforms, and develop data lake solutions and data warehouses using various database technologies.
Requirements
- performing data modeling and analysis on relational databases using SQL and SAP Power Designer or ERWIN.
- creating enterprise data lakes used for analytics, Artificial Intelligence (AI), and Machine Learning (ML) capabilities on Cloud and On-Prem Platforms, using big data processing techniques and solutions.
- designing complex Dimensional and Relational Databases using Ralph Kimball (Star and Snowflake), Bill Inmon Data Vault Design, and Denormalized Analytical Based Table/View data modeling techniques to create conceptual, logical, and physical models according to standards, taxonomy, and best practices, using data modeling tools – Erwin, and SAP Power Designer in an analytics data warehouse environment in Snowflake, Oracle, and SQL Server.
- building source-to-target mapping documents, profiling, mining, specifying, extracting, cleansing, and analyzing large data warehouses, using SQL Developer, Toad, and Python; generating insights for business and end users using SQL reports; writing SQL/PL-SQL queries and views against the database (SQL Server/Oracle) and generating reports; and modifying the existing SQL queries for improving query performance.
- generating DDL scripts (Forward-engineer) and DML scripts to create/update physical databases; and performing reverse-engineering of system database to create additional external tables and columns to gather data requirements from the source databases.
- leveraging various data modeling strategies such as dimensional, relational, and unstructured.
- Confers with systems analysts and other software engineers and developers to design systems and to obtain information on project limitations and capabilities, performance requirements and interfaces.
Responsibilities
- Builds structured and organized representations of data, which serve as a blueprint for efficient data storage and retrieval using data modeling tools -- SAP Power Designer and ERWIN.
- Creates and delivers data mapping specifications and data models for large reporting platforms using Oracle, Hadoop, and Microsoft SQL Server.
- Creates new data models and software structures to detail the flow of data from origination to consumption using data platforms -- Oracle, Snowflake, Hadoop, and Microsoft SQL Server, by applying data design patterns -- OLTP Recordkeeping, ODS, MDM, Warehousing, and Data Lakes.
- Creates and delivers data lake solutions and data warehouses using database technologies Snowflake on Amazon Web Services (AWS).
- Performs database querying by leveraging SQL.
- Discovers, designs, and delivers database design solutions for key business partners.
- Develops and details data solutions to support analytics and reporting capabilities as a member of the Fidelity Data Solutions of Center of Excellence.
Other
- Hybrid, requiring associates to work onsite every other week (all business days, M-F) in a Fidelity office.
- Those laws and regulations may restrict Fidelity from hiring and/or associating with individuals with certain Criminal Histories.
