Job Title :
- Data Modeler - Teradata Location : Lansing, MI Job Summary We are seeking an experienced Data Modeler with strong expertise in Teradata and Erwin Data Modeler tools.
- The ideal candidate will be responsible for designing, implementing, and maintaining enterprise data models that support analytical, operational, and reporting needs.
- This role requires close collaboration with business analysts, data architects, ETL developers, and database administrators to ensure data integrity, scalability, and performance.
- Key Responsibilities Design, develop, and maintain logical and physical data models for Teradata-based data warehouses and data marts.
- Use Erwin Data Modeler to create, update, and maintain data models, metadata, and data dictionaries.
- Analyze business requirements and translate them into effective database designs.
- Define and implement data modeling standards, best practices, and naming conventions.
- Collaborate with data architects and ETL teams to ensure consistency between data models and ETL processes.
- Perform data profiling, data analysis, and impact analysis on data model changes.
- Optimize data structures for performance, scalability, and maintainability in the Teradata environment.
- Support data governance and metadata management initiatives.
- Participate in code reviews, design sessions, and data quality assessments.
- Provide documentation and support for production and development teams.
- Required Qualifications Bachelor’s degree in Computer Science, Information Systems, or related field. 5+ years of experience in data modeling for large-scale data warehouse environments.
- Strong experience with Teradata databases and architecture.
- Expertise in Erwin Model Mart.
- Strong understanding of normalized and dimensional modeling techniques.
- Experience with ETL design concepts, data governance, and metadata management.
- Solid understanding of SQL and database performance tuning.
- Excellent analytical, communication, and documentation skills.
- Preferred Qualifications Experience in cloud data platforms (AWS, Azure, GCP) and integration with Teradata.
- Familiarity with BI / reporting tools (Tableau, Power BI, SAP Business Objects, etc.).
- Exposure to Agile / DevOps methodologies.
Benefits at IntelliBee Long-Term Stability :
Join us on a multi-year opportunities with room to grow.Comprehensive Health Coverage :
Access quality healthcare benefits to keep you and your family well.Future Planning :
Enroll in our 401(k) program and invest in your financial security.GC Assistance :
We support immediate Green Card processing, if required.Please apply on our secured job site at <
/ / intellibee.my.salesforce-sites.com / apps / jobs?id=a0AUU000004Xx2D>or email careers@intellibee.com Powered by JazzHR