Fidelity Corp
Data Modeler
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. Primary Responsibilities: 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. Maintains technical requirements in a multi-platform and highly integrated data environment by 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. Designs and oversees data validation procedures, ETL development, and data modeling and mapping documentation Education and Experience: Bachelor's degree (or foreign education equivalent) in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, International Business, or a closely related field and five (5) years of experience as a Principal Data Modeler (or closely related occupation) performing data modeling and analysis on relational databases using SQL and SAP Power Designer or ERWIN. Or, alternatively, Master's degree (or foreign education equivalent) in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, International Business, or a closely related field and three (3) years of experience as a Principal Data Modeler (or closely related occupation) performing data modeling and analysis on relational databases using SQL and SAP Power Designer or ERWIN. Skills and Knowledge: Demonstrated Expertise ("DE") 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. DE 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. DE 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. DE 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.
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. Primary Responsibilities: 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. Maintains technical requirements in a multi-platform and highly integrated data environment by 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. Designs and oversees data validation procedures, ETL development, and data modeling and mapping documentation Education and Experience: Bachelor's degree (or foreign education equivalent) in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, International Business, or a closely related field and five (5) years of experience as a Principal Data Modeler (or closely related occupation) performing data modeling and analysis on relational databases using SQL and SAP Power Designer or ERWIN. Or, alternatively, Master's degree (or foreign education equivalent) in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, International Business, or a closely related field and three (3) years of experience as a Principal Data Modeler (or closely related occupation) performing data modeling and analysis on relational databases using SQL and SAP Power Designer or ERWIN. Skills and Knowledge: Demonstrated Expertise ("DE") 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. DE 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. DE 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. DE 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.