Data Modeler

Job Title: Data Modeler

Location:: Hybrid San Antonio or Plano TX

Job Summary:

Must Have:

ERWIN

SQL

Data modeler/ Data Architect

Skill Set Requirements for Application Database Administrator

1. Data Modeling Expertise:

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

1. Proficiency with Data Modeling Tools:

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

1. Business Process Translation:

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

1. Industry Experience:

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

1. Complex Query Handling:

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

1. Performance-Driven Modeling:

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

1. AWS RDS Proficiency:

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

1. SQL Tuning Expertise:

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

1. NoSQL Database Knowledge:

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

1. Communication and Interpersonal Skills:

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

1. Developer Guidance:

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

1. Database Security and Compliance:

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

1. Disaster Recovery and Backup Planning:

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

1. Automation and Scripting:

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

1. Version Control Knowledge:

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

1. Capacity Planning:

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

1. Problem-Solving Skills:

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

1. Database Monitoring Tools:

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

1. Cross-Platform Database Management:

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

1. Project Management:

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