Data Modeler

TechDigital Group; Minneapolis (MN); On-site; USD 80,000 - 120,000; Full time

Job summary

An established industry player is seeking a skilled Data Architect to join their innovative team. This role involves analyzing data requirements, designing data architecture, and utilizing advanced modeling techniques to create effective data solutions. You will leverage your expertise in SQL and Entity-Relationship modeling to translate complex business needs into actionable data strategies. With a focus on the healthcare domain, you will contribute to impactful projects that enhance data management and analytics capabilities. If you are passionate about data and eager to make a difference, this opportunity is perfect for you.

Qualifications

• Expert in SQL and Entity-Relationship modeling for data analysis.
• Advanced experience in Master Data Management and Reference Data Management.

Responsibilities

• Analyze data requirements and create high-level process models.
• Design Data Architecture and Strategy for effective data analysis.

Skills

Data Analysis

SQL

Entity-Relationship Modeling

Data Profiling

Business Needs Translation

Data Normalization

Master Data Management

Healthcare Domain Knowledge

Tools

IBM UDMH Model

IDA

ERWin

ER-Studio

Job description

• Client, analyze, and scope data requirements; create high-level process models to represent processes for the area under analysis.
• Analyze existing business system data, data profiling, and source analysis.
• Create detailed mapping documents covering source to target mapping, transformation logic, and harmonization.
• Design Data Architecture and Strategy; employ "Entity-Relationship" modeling with the intent of producing a design best suited for retrospective analysis of data.
• Determine the right set of facts and surrounding dimensions suited to perform the desired type of analysis or queries against the data.
• Arrive at data solution diagrams including data flow diagrams, use case models, etc.
• Skilled in analyzing existing business system data, data profiling, and source analysis.
• Expert using SQL.
• Experts in understanding business needs to translate those needs into an effective model.
• Expert in Entity-Relationship modeling, with specific expertise in Star/Snowflake Schema modeling.
• Experience implementing IBM UDMH Model - Atomic or Dimensional Model.
• Exposure to one or more enterprise-level modeling tools, IDA, ERWin, ER-Studio, etc.
• Healthcare Domain Knowledge is a must; exposure to HL7, FHIR, OMOP will be a plus.
• Advanced understanding of data normalization and denormalization techniques.
• Expert in Metadata management and tools.
• Advanced experience in Master Data management/systems and Reference Data management/systems.
• Advanced experience with modeling process creation and implementation.
• Experts in understanding business needs to translate those needs into an effective model.