Data Modeler

Job Description

Job Description

CLIENT

KForce

END CLIENT

USAA

POSITION

Data Modeler

LOCATION

San Antonio or Plano TX

DURATION

6 months

PAY RATE

70 / hr on w2

INTERVIEW TYPE

Video

VISA TYPE

JOB TYPE

Contract

WORK TYPE

Hybrid

REQUIRED SKILLS

Must Have : ERWIN

Nice to have

OLTP

HashMap's

Teradata

Dynamo DB

Data modeler / Data Architect

Skill Set Requirements for Application Database Administrator

1. Data Modeling Expertise :

1. Strong experience in Star-schema, 3NF, Data Vault data modeling to design optimized, scalable database structures.

2. Proficiency with Data Modeling Tools :

1. Proficient in using data modeling tools like Erwin for creating and maintaining logical and physical data models.

3. Business Process Translation :

1. Ability to understand complex business processes and translate them into accurate and efficient data models that meet organizational needs.

4. Industry Experience :

1. Experience in the insurance industry is a plus, providing valuable insight into industry-specific data structures and requirements.

5. Complex Query Handling :

1. Proficiency in working with large tables and complex joins, ensuring data integrity and optimal query performance.

6. Performance-Driven Modeling :

1. Skilled in modeling tables and database structures with a focus on delivering the best query performance and minimizing response times.

7. AWS RDS Proficiency :

1. Extensive experience with AWS RDS (Relational Database Service), including managing and optimizing relational database systems in the cloud environment.

8. SQL Tuning Expertise :

1. Strong experience in SQL tuning, with a proven ability to analyze and improve query performance to meet business needs.

9. NoSQL Database Knowledge :

1. Essential knowledge and experience with NoSQL databases, particularly DynamoDB, to support a variety of data storage requirements.

10. Communication and Interpersonal Skills :

1. Excellent communication and interpersonal skills to effectively collaborate with both business stakeholders and IT teams.

11. Developer Guidance :

1. Ability to guide developers, providing recommendations and best practices for database design, performance optimization, and data management.

12. Database Security and Compliance :

1. Familiarity with database security best practices, ensuring compliance with relevant data protection regulations and standards.

13. Disaster Recovery and Backup Planning :

1. Experience in planning and implementing robust disaster recovery and backup strategies to protect critical data assets.

14. Automation and Scripting :

1. Proficient in automating routine database administration tasks using scripting languages like Python or Bash, improving efficiency and reducing manual work.

15. Version Control Knowledge :

1. Experience with version control systems like Git for managing database schema changes and maintaining version history.

16. Capacity Planning :

1. Ability to plan and manage database capacity, ensuring scalability and availability as data volumes and transaction loads grow.

17. Problem-Solving Skills :

1. Strong analytical and problem-solving skills, with the ability to troubleshoot complex database issues and implement effective solutions.

18. Database Monitoring Tools :

1. Proficiency with database monitoring tools and techniques to ensure optimal performance and quickly identify potential issues.

19. Cross-Platform Database Management :

1. Experience managing databases across multiple platforms (e.g., Oracle, SQL Server, MySQL) and integrating them into a unified data architecture.

20. Project Management :

Basic project management skills to oversee database-related projects, ensuring timely delivery and alignment with business objectives.

Salary : $70