Data Modeler

TechDigital Group; Atlanta (GA); On-site; USD 80,000 - 100,000; Full time

Job summary

A leading technology firm in Atlanta is seeking a skilled professional to develop and enhance data models across various business applications. The successful candidate will work closely with stakeholders and database administrators to ensure data integrity and compliance with organizational standards. Expertise in SQL Server and Oracle is required, along with a strong understanding of database optimization techniques. Join us to contribute to impactful data integration projects in a dynamic team environment.

Qualifications

• Proven experience in data modeling for OLTP systems.
• Strong understanding of database design principles.
• Ability to collaborate effectively with various stakeholders.

Responsibilities

• Develop and enhance data models across various applications.
• Translate business requirements into data models.
• Optimize database structures for performance.

Skills

Data modeling in OLTP systems

Database design and optimization

Data integrity and security

Data profiling and analysis

Collaboration with stakeholders

Tools

SQL Server

Oracle

Job description

Overview

Develop, maintain, and enhance conceptual, logical, and physical data models for various business domains and applications.

Responsibilities

• Experience in building data models in OLTP systems from scratch.
• Experience in building generic data models for file processing, document processing, hierarchy models, data auditing, and 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.