| Start Date: | |
| Interview Types |
| Skills | Data Modeler |
| Visa Types | H1B, Green Card, US .. |
|
Employment Type:
|
Contract
|
|
|
Client:
|
Federal
Home Loan Bank of Atlanta
|
|
|
City:
|
Atlanta
|
|
|
State:
|
Georgia
|
|
|
Status:
|
Accepting Candidates
|
|
|
Description:
|
** position is open because team member is having to move out of
US without return plans
We are developing a new application to manage collateral at the bank (about a year into it at this point) Collateral Management System Current license being expired, the new platform is being created from scratch This person will be architecting how data needs to be stored Not needing someone on analytical side Need to be experienced on the application side of data modeling OLTP modeling is REQUIRED - not OLAP A lot of people in the market are data engineers We need data modeler Not needing bring and store and design data We need architect that designs it, not building data structures Purely design role Ideal start date asap Oltp exercise as apart of the interview Normally we do 2 separate interviews Max 2 rounds, virtual Term: Initial 6 months contract with possibility of extension Start date: Asap Location: Onsite Mon – Thurs; Fri Remote Interview dates: Ongoing until we find suitable candidates Interview Info: Stage 1 – Remote, if shortlisted then Stage 2 – Onsite Data Modeler Job Description • Develop, maintain, and enhance conceptual, logical, and physical data models for various business domains and applications. • Experience in building Data models in OLTP Systems from the scratch. • Experience in building generic DATA models for File Processing, Document Processing, Hierarchy models, Data Auditing, Notifications. • Translate business requirements into data models ensuring structural integrity and compliance with organizational standards. • Design and optimize database structures to support data storage, retrieval, and analysis. • Collaborate with database administrators and developers to implement data models in database systems (SQL Server, Oracle). • Ensure data integrity, security, and performance through proper database design and optimization techniques. • Perform data profiling, analysis, and validation to identify inconsistencies and anomalies. • Collaborate with stakeholders to elicit, analyze, and document data requirements. • Create clear and comprehensive documentation of data models, 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 efforts, ensuring seamless transition of data from legacy systems to new platforms or environments. • Work closely with business analysts, developers, and project managers to align data modeling efforts with project timelines and objectives. • Conduct quality assurance reviews of data models to ensure accuracy, completeness, and usability. • Identify and resolve data model-related issues, such as performance bottlenecks, data anomalies, and schema conflicts. • Contribute to the overall success of the team by actively participating in meetings, sharing insights, and contributing innovative ideas. |