Senior Data Modeler Consultant
USD 114K-170K (estimate) Senior-level Full Time
Tasks
- Classify data by sensitivity
- Create OLAP models
- Create OLTP models
- Define data security and compliance rules
- Design conceptual, logical, physical data models
- Design enterprise data lakehouse models
- Develop ETL transformation rules
- Document data for technical and non technical users
- Establish data governance and data naming standards
- Implement data vault 20
- Improve query performance with indexing and partitioning
- Maintain data maps and metadata diagrams
- Maintain data schemas with modeling tools
- Model dimensional data with star schema
- Model transactional databases in 3NF
- Review current data models
- Transform unstructured data into structured data
- Translate business requirements into data requirements
- Use materialization strategies
Perks/Benefits
- N/A
Skills/Tech-stack
3NF | BigQuery | Cassandra | DBT | Data Architecture | Data Governance | Data Quality | Data Security | Data Vault | Data Vault 20 | Databricks | Dimensional Modeling | ER/Studio | ERD | ETL | Enterprise Data | Enterprise Data Architecture | Erwin | Hadoop | Indexing | JSON | Lakehouse | Materialized views | Microsoft SQL | Microsoft SQL Server | MongoDB | NoSQL | OLAP | OLTP | Parquet | Partitioning | Query Optimization | SQL | SQL Server | Snowflake | Star Schema
Education
Regions
Countries
States
Cities
Related jobs
-
SAP MDG (Master Data Governance) USD 124K-200KData Governance | Data Modeling | Data integration | Data replication | Master DataSenior-level Full TimeRiyadh, Riyadh Province, Saudi Arabia1d ago
-
Business Intelligence | Data Visualization | Data analytics | Descriptive Analytics | HadoopCoaching and mentoring | Flexible global team collaboration | Travel opportunitiesMid-level Full TimeRiyadh, Saudi Arabia7d ago
-
Consultant — Research and Analytics USD 72K-100KCross-tabulation | Data Analysis | Data Integrity | Data Validation | Exploratory Data AnalysisCritical illness insurance | Employee assistance program | Employee stock ownership program | Family building benefits | Health insuranceMid-level Full TimeRiyadh8d ago
-
AWS | Advanced Analytics | Cloud Computing | Cloud platform | Data EngineeringSenior-level Full TimeRiyadh, Saudi Arabia16d ago
-
Data Modeler USD 103K-147KDWH | Data Modeling | Data Warehousing | Dimensional Modeling | ER ModelingMid-level Full TimeSaudi Arabia, Saudi Arabia22d ago
-
Data Modeler / Big Data Engineer USD 95K-144KApache Hadoop | Apache Hive | Apache Iceberg | Apache Impala | Apache SparkMid-level Full TimeRiyadh, Riyadh Province, Saudi Arabia1mo ago
-
Audit Support | Compliance Management | Data Classification | Data Governance | Data PrivacyTeam leadershipSenior-level Full TimeRiyadh, Riyadh Province, Saudi Arabia1mo ago
-
Data Governance Consultant USD 113K-159KBusiness Analysis | Change Management | Data Governance | Data Maturity | Data ModelingMid-level Full TimeRiyadh, Riyadh Province, Saudi Arabia1mo ago