Country:

United States

Cities:

Chicago, Stamford

Area of expertise:

Analytics

Job Description

Role Summary:

The candidate will build, optimize and maintain conceptual and logical database models. The data architect will serve as a vital bridge from the business applications to technology architecture (TOGAF Architecture Development Method). The data architect will develop database solutions to ensure company information is stored effectively and securely. The data architect will work closely with IT and functional teams to recommend database structures based on the data storage and retrieval needs within each data domains. The Data Architect will need to develop intimate knowledge of SYF key data domains (originations, loan activity, collection, etc.) and Maintain a holistic view across SYF functions to eliminate redundancies in data and data processing.


Day to day you may:

  • Define logical, physical data model structure, integrate, govern, store, describe, model, and maintain data in the enterprise for accuracy and usage maintaining current state
  • Keep integrity in data derivation across Synchrony functions for a consistent view
  • See opportunities to reuse existing data structures
  • Identify impact on existing model / solution triggered by new / changed requirements keeping integrity of models
  • Establish mechanism to validate source data populated into integrated data repositories
  • Work as one team with peer architects, modelers, and data engineers
  • Work in collaboration with Provisioning / ETL architect, System Architect and Reporting architects to strategize and execute on target data architecture, standardize and manage key dimensions
  • Map to information entities that can define how information should flow and be consumed by various business functions and IT customers
  • Document data flow diagrams to determine what can be measured, when and how
  • Ensure discipline in the creation of Logical Data Models and their later implementation as Physical Data Structures
  • Ensure all data is properly catalogued, and resolve issues around outdated data structures
  • Provide insight into the changing database storage and utilization requirements for the company and offer suggestions for solutions
  • Analyze database implementation methods to make sure they are in line with company policies and any external regulations that may apply
  • Develop database design and architecture documentation for the management and executive teams
  • Help maintain the integrity and security of the company database

You are likely to have:

  • Bachelor’s Degree in Computer Engineering or related field required (Master’s degree preferred)
  • 5+ years’ experience on Hadoop big data platforms in –
  • Data analysis and profiling
  • Data modeling – logical and physical
  • Hands-on experience in Hive, HiveQL, Spark.
  • Strong familiarity with HDFS, Kafka, Hbase and other Data Lake technologies and techniques.
  • Strong familiarity with data governance, data lineage, data processes, DML, and data architecture control execution
  • Solid experience with business analysis - Requirements analysis and conversion to data models.
  • Must be able to develop creative solutions to problems.
  • Strong verbal and written communication skills

Desired Characteristics:

  • Credit card/payment experience
  • Background in Financial Services
  • Some familiarity with TOGAF / leading data architecture framework
  • Demonstrated experience building strong relationships with colleagues and partners

Apply now

Share this job:

Share Facebook Twitter Email

About Avanade

Avanade leads in providing innovative digital services, business solutions and design-led experiences for its clients, delivered through the power of people and the Microsoft ecosystem. Our professionals combine technology, business and industry expertise to build and deploy solutions to realize results for clients and their customers. Avanade has 29,000 digitally connected people across 23 countries, bringing clients the best thinking through a collaborative culture that honors diversity and reflects the communities in which we operate. We welcome all, and seek talented individuals who can bring their whole self to work, build inclusive teams and encourage diversity inside and outside the organization. Majority owned by Accenture, Avanade was founded in 2000 by Accenture LLP and Microsoft Corporation. Learn more at www.avanade.com.