Sr Data Architect in Chicago, IL at Transformco

Date Posted: 10/21/2019

Job Snapshot

  • Employee Type:
  • Location:
    33 West Monroe Street
    Chicago, IL
  • Date Posted:
  • Job ID:

Job Description

Req/Job ID: 988745BR
Employing Entity: Transform SR Holding Management LLC
Employment Category: Regular, Full-time
Job Function: Analytics

The Database Administration and Architecture team manages data as a vital company asset, to ensure full data integrity, consistency and availability to support Online Business Unit applications, business consumers and customers. This function retains full integrity of data in the event of a disaster or catastrophe and adopt best practices in a conservative manner in order to deliver services to the corporation.

Job Requirements

Job Duties/Responsibilities:

•Creates technical database design specifications from Business and Technical requirements including the conceptual process flow, data flow diagram, physical data model, script creation, data capacity estimates and implementation plan.
• Determines best database technology solutions aligned to technical and functional requirements.
• Ensures PCI and SOX change controls are implemented and auditable.
• Builds protection around cardholder dataImplements Identity and Access management features.
•Develops procedure to automate and simplify user database access that; 1) protects member data, 2) provides data per application and user requirements and 3) ensures compliance to legal and company security policies.
• Ensures PCI and SOX change controls are implemented and auditable.
• Works with Legal and Risk Management and Infrastructure Security Protection groups to ensure controls around data management are in place to protect company assets.
• Leads data model design reviews Serves as a strong advocate for design and naming standards.
• Mentors DB team and Development teams in database design.

Job Requirements:

•A Bachelor's degree (graduate degree preferred) in Computer Science, a related technical or scientific field, or equivalent experience (in-industry) preferred
•6 years practical design experience
•Familiar with agile methodologies
•Familiar with the following data model concepts:
Relational ERD
Wide-column store
Key-value store
Document store
Search and Graph
Object Oriented
Native XML

#Corporate, #Technology, #SYW