Job Description :
Responsibilities:
Experience with a modeling tool (Embarcadero ER/Studio or Erwin)
Experience designing and developing logical and physical data models
Ability to evaluate DDL for completeness and accuracy before submission to a DBA
Ability to perform data analysis, and data discovery. Identifies cause of data issues and works with broader team to resolve issues.
Leads design reviews of data deliverables such as models, data flows, and data quality assessments
Provides senior level data modeling services, including updating and building logical/physical database models.
Works closely with the development and QA teams to communicate the business rules and ensure testing use cases target the quality and integrity of the data model
Works with senior DBA to identify and resolve issues or transform logical database models into physical database designs that represent the business rules while optimizing the performance and maintainability of the design in the physical database.
Uses a variety of information gathering techniques (e.g., interviews, diagrams, facilitation) to gather complex business data requirements from internal business clients and development teams.
Works closely with other application areas to ensure that data integrations are efficient, follow AA technical standards, and meet the business requirements
Ensures that all data deliverables comply with security policies and regulations (PCI, PII)
Required Skills/ Experience:
Minimum 7 years of experience in data modeling, including conceptual, logical, physical, Data Mart, Data Warehouse or Operational data store
Experience in data architecture and strong understanding of data movement and data layout
Some Technical experience in coding or database administration or system administration would be preferred
Experience working in a master data management solution or other large CRM system
Experience working with database (Oracle/SQL Server) and writing SQL
Strong facilitation experience with business stakeholders to capture data requirements
Experience in identifying and resolving data quality issues to the team and business partners
Strong analysis and deep problem solving skills. Must be a self-motivated driver to find out data issues and resolve them quickly
Must be a self-motivated driver to understand the broader system