Data Modeler

TechDigital Group; Chicago (IL); On-site; USD 80,000 - 120,000; Full time

Job summary

An established industry player is seeking a skilled Data Modeler to design and develop innovative data models that support financial analytics and reporting. This role involves collaborating with various teams to ensure data integrity and compliance with industry standards. You will be responsible for implementing data governance policies and working with cutting-edge data modeling tools. Join a dynamic environment where your expertise will contribute to the development of data strategies that drive business success. If you are passionate about data and thrive in a collaborative setting, this opportunity is perfect for you.

Qualifications

• Solid experience in Data Vault and dimensional modeling required.
• Strong experience in data governance and management is essential.

Responsibilities

• Design and develop data models supporting the financial firm's goals.
• Collaborate with teams to translate data requirements into models.

Skills

Data Vault modeling

Dimensional modeling

Data governance

Data management

Data mapping

Data flow logic

Financial industry knowledge

Insurance industry knowledge

Tools

Erwin

PowerDesigner

IBM Data Architect

Oracle Designer

Alation

Collibra

Informatica

Atlan

IBM IGC

Job description

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).