Data Modeling Analyst

Job Title: Data Modeler / Data Modeling Analyst

Location: Stockholm, Sweden / Copenhagen, Denmark (Hybrid)

Job Type: Permanent / FTC

Job Description:

Create and maintain conceptual logical and physical data models for databases and data warehouses

Optimize data structures for performance scalability and reliability

Work closely with business analysts data architects and software developers to understand data needs

Collaborate with stakeholders to gather and analyze requirements for data related projects

Define database structures to support business operations and analytics

Develop and maintain data dictionaries and metadata

Provide guidance on data storage solutions e g hive or cloud based databases

Ensure data models align with organizational standards and governance policies

Identify and resolve data inconsistencies and redundancy

Document all data models and ensure they are up to date

Develop and enforce data modeling best practices and standards

Use data modeling tools such as Erwin or IBM Data Architect to create models

Implement data solutions on platforms like Hadoop or Hive tables

Analyze data models for performance bottlenecks and recommend optimizations

Required Skills and Qualifications

Education Bachelors or Masters degree in Computer Science Information Systems Data Science or a related field

Experience Proven experience in data modeling database design or related roles

Technical Skills

Proficiency in data modeling tools e g Erwin IBM Data Architect

Expertise in Big data database systems e g Hive Impala

Expertise in Relational database systems e g Oracle

Familiarity with ETL processes data warehousing and cloud technologies

Knowledge Areas

Data governance frameworks and best practices

Advanced knowledge of normalization denormalization and schema design patterns

Understanding of modern data architectures such as data lakes and lakehouses

Soft Skills

Strong analytical and problem solving abilities

Excellent communication and stakeholder management skills

Ability to work collaboratively across teams

Preferred Qualifications

Experience with big data technologies e g Hadoop Spark

Skills

Mandatory Skills : Data Vault (ODS) Modeling, Dimensional Data Modeling, ER Studio, MS SQL Server

Good to Have Skills : ANSI-SQL