Data Modeler

Job #: 1990
Pay Rate: Not Specified
Job type: contractor
Location: Chicago, IL

Job Responsibilities:

1. Design and develop data models that effectively support the financial firm's data management, analytics, and reporting goals.
2. Collaborate with data architects, data analysts, and business units to understand data requirements and translate them into data models.
3. Perform rigorous data analysis to understand the data nuances and apply learnings to data models and data designs.
4. Work with the business team to design conceptual and logical data models, data flows, data designs, and source-to-target data mapping.
5. Collaborate with Business teams and Data Stewards to determine and manage data cleaning requirements, data security needs, and implement security solutions as part of the data designs.
6. Develop data model designs iteratively in an agile fashion incorporating collaboration, iteration, feedback, and continuous improvement throughout the data modeling lifecycle.
7. Ensure that data models comply with financial regulations, data governance policies, and industry standards.
8. Validate data models for data integrity, accuracy, and consistency.
9. Assist in the selection and implementation of data modeling tools and methodologies.
10. Assist in defining and implementing data standards for systems and applications including data object naming conventions, data standardization, data integrity, and data usage.
11. Work closely with the Data Modeling Lead to align data models with the overall data strategy of the company.
12. Facilitate integration of data models into data warehousing, reporting, and analytics solutions.
13. Assist in defining data dictionary and business glossary to ensure consistent terminology and information across the organization.
14. Collaborate with data governance teams and data stewards to document data models including data dictionaries, data lineage, and metadata.
15. Provide input to data governance teams to ensure that data models align with data governance policies and standards.
16. Responsible for the development of the conceptual, logical, and physical data models.
17. Implementation of RDBMS, operational data store (ODS), data marts, and data lakes on target platforms.
18. Define and govern data modeling and design standards, tools, best practices, and related development for enterprise data models.
19. Hands-on modeling, design, configuration, installation, performance tuning.

Qualifications:

1. Solid experience in Data Vault modeling approach.
2. Solid experience in dimensional modeling with a proven track record of designing conformed dimensions that are applicable across various Business Units.
3. Solid experience in data modeling tools such as Erwin, PowerDesigner, IBM Data Architect, or Oracle Designer.
4. Strong Financial and Insurance industry domain knowledge.
5. Experience in data governance and data management and using tools such as Alation, Collibra, Informatica, Atlan, IBM IGC.
6. Strong experience working in data lake, data lake house, data warehouse, data mesh, and operational data stores.
7. Experience designing models to be leveraged for data as a product and data marketplace.
8. Proficiency in developing data designs, data mapping, and data flow logic to support the implementation of data structures designed.
9. Strong experience in data governance and data management.
10. Experience in a metadata field of work (ontology, taxonomy, or semantics).
11. Knowledge of W3C standards including linked and canonical data and ontologies (JSON, XML, RDF, RDFS, OWL, and SKOS).