Description
You will design and implement data models for enterprise-scale OLTP and OLAP applications.
Responsibilities
- Build enterprise data models from scratch, including the development of data dictionaries and metadata repositories.
- Collaborate with business stakeholders and analysts to translate business requirements into technical data models.
- Design schema patterns for NoSQL databases, specifically focusing on scalability, performance, and hierarchical data.
- Work with database administrators to implement models and enforce data modeling standards and best practices.
- Conduct data profiling and analysis to ensure data accuracy, integrity, and compliance with governance policies.
Required Skills
- 10+ years of experience in data model design for OLTP and OLAP applications.
- 2+ years of experience modeling NoSQL databases, specifically MongoDB and Neo4j.
- Expertise in schema design for hierarchical data, entity relationships, and embedded documents.
- Proven ability to model one-to-many and many-to-many relationships using document and graph databases.
- Experience creating design patterns optimized for performance and scalability.
- Proficiency with data modeling tools such as Lucidchart, Draw.io, or ERWIN.
- Strong analytical skills for identifying patterns and trends within complex datasets.
- Ability to travel to customer locations for workshops as required.
Preferred Skills
- Prior experience working on automobile-related projects.