Data Modeler

Job Title: Data Modeler Location: San Antonio, TX Duration: Long-term Contract Start Date: ASAP Work Authorization: Open (must be eligible to work in the U.S.) Job Description: We are seeking an experienced Data Modeler to join our team for a long-term project in San Antonio, TX. The ideal candidate must have strong expertise in data modeling and hands-on experience with ERwin Data Modeler. This role requires a candidate who can work closely with business and technical teams to design, implement, and maintain logical and physical data models that support business intelligence and data integration initiatives. Key Responsibilities: • Design and develop logical and physical data models for OLTP and OLAP systems. • Collaborate with data architects, business analysts, and DBAs to understand requirements and translate them into data models. • Use ERwin to build, maintain, and publish data models. • Ensure data models support data governance, data quality, and data management standards. • Review and optimize existing models to improve performance and data quality. • Create and maintain documentation related to data models and metadata. • Support data integration and ETL processes by providing data structure guidance. • Participate in data strategy discussions and contribute to data architecture decisions. Required Skills: • 5+ years of experience in data modeling and database design. • Strong proficiency with ERwin Data Modeler (experience with forward/reverse engineering). • Solid understanding of relational and dimensional data modeling techniques. • Experience working with enterprise data warehouses, data lakes, or data marts. • Familiarity with RDBMS platforms such as SQL Server, Oracle, or Teradata. • Strong SQL skills and understanding of data integration concepts. • Ability to interpret complex business requirements into scalable data models. • Strong communication and documentation skills.