Data Modeler

Job Title: Data Modeler
Location: 1475 Peachtree St NE, Atlanta, GA 30309 (Onsite 4/5 days a week)
Contract Duration: Initial 6 months (with the possibility of extension)
Start Date: ASAP
Interview Process: Max 2 rounds, virtual (OLTP exercise as part of the interview)

Project Overview:
The Federal Home Loan Bank of Atlanta is developing a new Collateral Management System to manage collateral at the bank, as the current platform license is expiring. The new platform is being built from scratch, and this role will focus on architecting how data needs to be stored within the application, specifically through OLTP modeling.

Role Summary:
This is a purely design role, focused on data modeling for the application side, rather than data engineering or analytical modeling. The Data Modeler will be responsible for designing data storage structures for OLTP systems, ensuring that the data models align with the business requirements and organizational standards.

Key Responsibilities:

• Develop, maintain, and enhance conceptual, logical, and physical data models for business domains and applications.
• Build data models from scratch for OLTP systems, ensuring they are optimized for transactional processing.
• Design generic data models for use in file processing, document processing, hierarchy models, data auditing, and notifications.
• Translate business requirements into well-structured data models while ensuring structural integrityand compliance with standards.
• Optimize database structures for efficient data storage, retrieval, and analysis.
• Collaborate with database administrators and developers to implement data models in systems such as SQL Server and Oracle.
• Ensure data integrity, security, and performance through sound design and optimization techniques.
• Perform data profiling, analysis, and validation to identify inconsistencies and anomalies.
• Create comprehensive documentation, including entity-relationship diagrams, data dictionaries, and metadata.
• Support data integration projects by mapping data sources to target data models and designing data transformation processes.
• Facilitate data migration from legacy systems to new environments.
• Collaborate with business analysts, developers, and project managers to align data modeling efforts with project timelines and goals.
• Conduct quality assurance reviews to ensure data models are accurate and usable.
• Identify and resolve data model-related issues, such as performance bottlenecks and schema conflicts.

Required Skills:

• Proven experience in building data models for OLTP systems from scratch.
• Experience with file and document processing data models, hierarchy models, and data auditing.
• Expertise in SQL Server and Oracle
• Strong understanding of data modeling principles, including entity-relationship diagrams, data integrity, and optimization.
• Ability to translate business requirements into scalable and optimized data models.
• Excellent documentation skills for data models and related diagrams.
• Ability to work collaboratively with cross-functional teams to deliver high-quality solutions.

Preferred Qualifications:

• Experience in the banking or financial services industry is a plus.
• Strong problem-solving skills and attention to detail.
• Familiarity with data migration processes from legacy systems.

This is an exciting opportunity for a skilled Data Modeler to play a key role in building a critical application from scratch at a leading financial institution.

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.