Hybrid Work - Need Data Modeler in Atlanta GA

Position

Data Modeler

Employment Type (C, CTH, DH)

Contract;18 months

Remote/Hybrid/On-site

Hybrid – 3-4 days/week onsite (except Fridays) - 1475 Peachtree Street NE Atlanta Georgia 30309 United States

What We Like About This Opportunity

Cool opportunity to work with a pretty big financial institution on a project to rearchitect/rebuild a critical business application over a 2 year period.

Business Objectives & Key Project Details

• Client is engaging on a project to build a new collateral system (which is mostly file-based).
• Current state is a third-party vendor application that gets sunset by end of 2025.
• Need to get a POC by beginning of 2025, implemented by end of 2025, plus at least another 18 months of enhancements, etc.
• Started at the end of March, so are about 2 months in. Started requirements with the business and goes through August. August/September would be POC time for some of the modules they would like the business to see (clickable prototypes). Still in requirements phase.
  
  

% breakdown of what they will be doing

• Application Modeling, NOT Database Modeling
• Notifciation data modeling
• OLTP - Transactional Processing System
• Creation of logical, conceptual, and physical data models
• Creation of data dictionary for the attributes in the data model, development, and deployment of data model into the databases.
• Leading the effort in migration of historical data from Rockall into CMS, communicating and coordinating the ETL work with the Data Management teams, creation of predefined reports and dashboards facing Internal customers in Power BI. Number of reports should be finite and pre-defined(20-40).
  
  

Required Skills

• See JD – technology agnostic because the application is a file-based system
• Strong understanding of Data Warehouse concepts (ETL, Star Schema, slowly changing dimensions)
• Strong knowledge of relational databases, Data Warehouse, and business Intelligence solutions
• Excellent teamwork and collaboration skills
• Understand existing data model, collaborate with client business & technical teams to develop the target state data model
• Develop Logical, Physical data models and build tables, indexes, database objects
  
  

KnockOut Questions

Creating Process Flows For Application Models

• Can you walk me through the process of gathering historical records for our application models?
• What tools or techniques do you use to document and visualize process flows in application modeling?
• Can you discuss a challenging scenario you encountered while creating process flows for application models and how you resolved it?
• How do you ensure that the process flows you create align with business requirements and objectives?
• How do you ensure that the process flows remain up-to-date as the application evolves over time?
  
  

Building Class Diagrams

• What methodologies or standards do you follow when building class diagrams for application models?
• Can you discuss the role of abstraction in class diagram design and how it applies to application modeling?
• What strategies do you use to identify and prioritize classes and their relationships in a complex application model?
• How do you validate the accuracy and completeness of a class diagram?
• Can you explain the difference between aggregation and composition in the context of class diagrams?
• How do you handle situations where there are multiple valid ways to represent a concept in a class diagram?
• Can you describe a time when you had to refactor a class diagram to accommodate changes in application requirements or design?
  
  

Notification Data Modeling

• What factors do you consider when modeling notification data for an application?
• How do you determine the appropriate timing and frequency for notifications in a data model?
• Can you discuss the trade-offs between push notifications and pull notifications in terms of data modeling?
• How do you handle scenarios where users have different preferences or requirements for receiving notifications?
• What strategies do you use to ensure that notification data models are scalable and efficient?
• Can you describe a situation where you had to integrate notification data models with external systems or services?
  
  

Client’s Job Description

Responsibilities will include, but not limited to:

• Creation of logical, conceptual, and physical data models
• Creation of data dictionary for the attributes in the data model, development, and deployment of data model into the databases.
• Leading the effort in migration of historical data from Rockall into CMS, communicating and coordinating the ETL work with the Data Management teams, creation of predefined reports and dashboards facing Internal customers in Power BI. Number of reports should be finite and pre-defined(20-40).
  
  

Skills Required

• Strong understanding of Data Warehouse concepts (ETL, Star Schema, slowly changing dimensions)
• Strong knowledge of relational databases, Data Warehouse, and business Intelligence solutions
• Excellent teamwork and collaboration skills
• Understand existing data model, collaborate with client business & technical teams to develop the target state data model
• Develop Logical, Physical data models and build tables, indexes, database objects
  
  

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.