Clay modeler Jobs in Chicago il

Job Description :

Pay Range $50hr - $55hr

• Design and develop data models that effectively support the financial firm's data management, analytics, and reporting goals.
• Collaborate with data architects, data analysts, and business units to understand data requirements and translate them into data models.
• Perform rigorous data analysis to understand the data nuances and apply learnings to data models and data designs.
• Work with the business team to design conceptual and logical data models, data flows, data designs and source-to-target data mapping.
• 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.
• Develop data model designs iteratively in an agile fashion incorporating collaboration, iteration, feedback, and continuous improvement throughout the data modeling lifecycle.
• Ensure that data models comply with financial regulations, data governance policies, and industry standards.
• Validate data models for data integrity, accuracy, and consistency.
• Assist in the selection and implementation of data modeling tools and methodologies.
• Assist in defining and implementing data standards for systems and applications including data object naming conventions, data standardization, data integrity, and data usage.
• Work closely with the Data Modeling Lead to align data models with the overall data strategy of the company.
• Facilitate integration of data models into data warehousing, reporting, and analytics solutions.
• Assist in defining data dictionary and business glossary to ensure consistent terminology and information across the organization.
• Collaborate with data governance teams and data stewards to document data models including data dictionaries, data lineage, and metadata.
• Provide input to data governance teams to ensure that data models align with data governance policies and standards.
• Responsible for the development of the conceptual, logical, and physical data models.
• Implementation of RDBMS, operational data store (ODS), data marts, and data lakes on target platforms.
• Define and govern data modeling and design standards, tools, best practices, and related development for enterprise data models.
• Hands-on modeling, design, configuration, installation, performance tuning.
• Solid experience in Data Vault modeling approach.
• Solid experience in dimensional modeling with a proven track record of designing conformed dimensions that are applicable across various Business Units.
• Solid experience in data modeling tools such as Erwin, PowerDesigner, IBM Data Architect, or Oracle Designer.
• Strong Financial and Insurance industry domain knowledge.
• Experience in data governance and data management and using tools such as Alation, Collibra, Informatica, Atlan, IBM IGC.
• Strong experience working in data lake, data lake house, data warehouse, data mesh, and operational data stores.
• Experience designing models to be leveraged for data as a product and data marketplace.
• Proficiency in developing data designs, data mapping and data flow logic to support the implementation of data structures designed.
• Strong experience in data governance and data management.
• Experience in a metadata field of work (ontology, taxonomy, or semantics).
• Knowledge of W3C standards including linked and canonical data and ontologies (JSON, XML, RDF, RDFS, OWL, and SKOS).