We are looking for an experienced Data Modeller to design, develop, and maintain enterprise data models that support business intelligence, analytics, reporting, and operational applications. The role involves translating business requirements into conceptual, logical, and physical data models while ensuring data quality, consistency, scalability, and governance.
The Data Modeller will work closely with Business Analysts, Data Engineers, Solution Architects, Database Administrators, and business stakeholders to create robust and scalable data architectures.
Key Responsibilities:
Data Modelling
Strong understanding of Conceptual, Logical, and Physical Data Modelling.
Strong knowledge of Relational Data Modelling and ER Modelling.
Experience with Dimensional Data Modelling.
Good understanding of normalization and denormalization techniques.
Experience designing Star and Snowflake schemas.
Understanding of slowly changing dimensions (SCD), fact tables, dimension tables, and surrogate keys.
Database & SQL
Strong SQL skills.
Good knowledge of relational databases such as:
PostgreSQL
Oracle
SQL Server
MySQL
Snowflake
Understanding of database performance, indexing, partitioning, and query optimization.
Knowledge of database constraints and referential integrity.
Data Warehousing & Cloud
Experience with data warehouse and data lake concepts.
Understanding of ETL/ELT processes and data integration.
Experience with one or more cloud data platforms such as:
AWS
Microsoft Azure
Google Cloud Platform
Exposure to platforms such as Snowflake, Databricks, Azure Synapse, BigQuery, or Amazon Redshift is desirable.
Data Modelling Tools
Experience with one or more of the following:
Erwin Data Modeler
ER/Studio
SAP Power Designer
Oracle SQL Developer Data Modeler
Sparx Enterprise Architect
Lucid chart
Microsoft Visio
Education & Experience
Bachelor's or master's degree in computer science, Information Technology, Data Management, or a related field.
5–10 years of experience in data modelling, database design, data warehousing, or related roles.
Experience working on enterprise data platforms and large-scale data projects.
Experience working in Agile/Scrum environments is preferred.
Numbers & Facts
Location
San Francisco, California
Website
http://www.xlysi.com
Skills
Agile Programming Methodologiesunmatched
Amazon Web Services (AWS)unmatched
Business Analysisunmatched
Business Intelligenceunmatched
Business Supportunmatched
Cloud Computingunmatched
Computer Scienceunmatched
Data Lakeunmatched
Data Managementunmatched
Data Modelingunmatched
Data Modeling Toolsunmatched
Data Processingunmatched
Data Qualityunmatched
Data Warehousingunmatched
Database Administrationunmatched
Database Architectureunmatched
Database Designunmatched
Database Extract Transform and Load (ETL)unmatched
Dimensional Modelingunmatched
Embarcadero ER/Studiounmatched
Enterprise Architectureunmatched
Entity Relational (ER) Modelingunmatched
Information Technology & Information Systemsunmatched
Microsoft SQL Serverunmatched
Microsoft Visiounmatched
Microsoft Windows Azureunmatched
MySQLunmatched
Oracleunmatched
Oracle Databaseunmatched
PostgreSQLunmatched
Query Optimizationunmatched
Requirements Managementunmatched
SAPunmatched
Scrum Project Management and Software Developmentunmatched
Snowflake Schemaunmatched
Star Schemaunmatched
erwin Data Modelerunmatched
🎯
Be found by employers
5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.