Data Modeler
Tasks
- Contribute to legacy migration and modernization of data models
- Create and maintain ERDs data flow diagrams and model documentation
- Define keys indexes constraints and referential integrity rules
- Design dimensional and normalized data models
- Develop data architecture vision and standards
- Develop testing criteria for data architecture fidelity and performance
- Ensure regulatory compliance for data strategies and architectures
- Lead data modeling and data movement initiatives
- Maintain data dictionaries business glossaries and lineage documentation
- Oversee data mapping and data movement for data quality
- Recommend scalable and high performance data solutions
- Support protection of sensitive data
- Translate business needs into conceptual, logical, and physical data models
Perks/Benefits
- N/A
Skills/Tech-stack
ANSI SQL | ANSI compliance | DCL | DDL | DML | Data Architecture | Data Flow | Data Flow Diagrams | Data Governance | Data Lakehouse | Data Migration | Data Modeler | Data Modeling | Data Quality | Data Security | Data Vault | Data Warehousing | Data profiling | Delta Lake | Dimensional Hierarchies | Dimensional Modeling | ETL | Entity Relationship Diagrams | Entity relationship | Erwin Data Modeler | Flow diagrams | HIPAA | MDM | Medallion Architecture | Metadata Management | Normalized modeling | OLAP | OLTP | PII | Parquet | Phi | Query Optimization | Relationship Diagrams | Role Playing Dimensions | Role playing | SOX | SQL Optimization | Slowly Changing Dimensions | Snowflake Schema | Star Schema | Stored Procedures | Surrogate keys
Education
N/A
Roles
Related jobs
-
ANSI SQL | Azure Data | Azure Data Factory | Azure Data Lake | Azure Data Lake Storage401k contribution | Career development opportunities | Comprehensive benefits package | Incentive and recognition programs | Remote work within United StatesSenior-level Full TimeChicago, Illinois, UNITED STATES; REMOTE R2d ago
-
Alation | Atlan | Azure Cosmos | Azure Cosmos DB | Azure DataRemote workSenior-level Full TimeBrazil R3d ago
-
Azure Cosmos | Azure Cosmos DB | Azure Data | Azure Data Lake | Azure SynapseSenior-level Full TimeIndia R3d ago
-
Data Modeler USD 131K-179KData Architecture | Data Management | Data Modeling | Data Security | Data VaultSenior-level Full TimeRemote job R4d ago
-
Data Architect/Modeler USD 120K-180KAzure Data | Azure Data Lake | Azure Synapse | Azure Synapse Analytics | Cosmos DBBenefits | Professional growth opportunities | Remote workSenior-level ContractRemote R5d ago
-
Cloud Data Architect - Data Modeler USD 169K-229KAWS | Amazon Redshift | CI/CD | Change Data Capture | Data Capture401k | Dental insurance | Health insurance | Remote | Vision insuranceSenior-level Full TimeUSA DC Home Office (DCHOME), United … R6d ago
-
Data Engineer EUR 35K-42KAmazon Web Services | Data Modeling | Data Warehouse | Lakehouse | SQLChildcare card | Employee discount portal | Fitness membership | Flexible compensation | Health insuranceMid-level Full TimeBarcelona, Spain R7d ago
-
Analytic Server Modeler USD 150K-170KAzure | Big Data | C# | C++ | DDL401k | Medical/Dental/Vision insurance | Paid time offEntry-level Full TimeRemote, United States R10d ago
-
Data Architect and Data Modeller EUR 62K-86KChange Management | Conceptual data modeling | Data Architecture | Data Governance | Data LineageSenior-level Full TimeRemote job R13d ago
-
Senior Data Architect USD 172K-203KAWS S3 | Amazon Kinesis | Apache Airflow | Apache Kafka | Apache SparkDental insurance | Employee discounts | Health insurance | Mental health resources | Paid HolidaysSenior-level Full TimeHybrid - San Francisco, California R1mo ago