Overview
Remote
Depends on Experience
Contract - W2
Contract - 6 Month(s)
Skills
star schema
snowflake schema
data modeling
database design
data engineering
Redshift
Job Details
Key Responsibilities:
- Data Modeling: Design and develop conceptual, logical, and physical data models to support enterprise applications, data warehouses, and analytics platforms.
- Database Design: Create and optimize database schemas, ensuring efficient storage, retrieval, and performance for structured and unstructured data.
- Data Integration: Collaborate with data engineers to integrate data from various sources (e.g., APIs, third-party systems, internal databases) into cohesive models.
- Dependency Analysis: Analyze and document table dependencies, foreign key relationships, and referential integrity to ensure robust data structures.
- Performance Optimization: Work with database administrators to optimize queries, indexes, and partitioning strategies for high-performance data retrieval.
- Collaboration: Partner with business analysts, data scientists, and stakeholders to translate business requirements into effective data models.
- ETL/ELT Support: Provide data modeling support for ETL/ELT processes, ensuring compatibility with tools like Informatica IICS.
- Documentation: Maintain comprehensive documentation of data models, schemas, and metadata using tools like ERwin, ER/Studio, or Lucidchart.
- Platform Expertise: Work with cloud-based data platforms (e.g., Amazon Redshift) to design models optimized for scalability and performance.
- Continuous Improvement: Stay updated on emerging data modeling trends, tools, and technologies to enhance data architecture.
Qualifications:
- Education: Bachelor s degree in Computer Science, Information Systems, Data Science, or a related field. Master s degree preferred.
Experience:
- 8+ years of experience in data modeling, database design, or data engineering.
- Proven experience with relational and dimensional data modeling (e.g., star schema, snowflake schema).
- Hands-on experience with cloud data platforms like Amazon Redshift.
- Familiarity with data integration tools (e.g., Informatica IICS) is a plus.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.