Data Architect

Company: SGA Inc.
Location: Hoboken
Posted on: November 15, 2021

Job Description:

Software Guidance & Assistance, Inc., (SGA), is searching for a Data Architect for a Contract assignment with one of our premier Financial Services clients in Hoboken, NJ .

Responsibilities :

• Designs and develops Application Data Models.
• Designs and develops Reference and "Data Warehouse Data Models.
• Evaluates reusability of current data for separate analyses.
• Creates the process of data sheering to rid the system of old, unused or duplicate data.
• Reviews object, data models and the metadata repository; to structure the data for better management and quicker access.
• Ensures the consistent use of Enterprise Reference Data within the application and "Data Warehouse data models.
• Develops and delivers long-term strategic goals for Data Architecture vision.
• Establishes processes for governing the identification, collection, and use of corporate metadata; Identifies methods for tracking such data for quality, completeness, redundancy, and improvement.
• Strategizes what the best practices are in relation to Data Security, backup, Disaster Recovery, Business Continuity and Archiving. Ensures all strategies are in compliance with Enterprise Procedures and regulations.
• Selects/implements the appropriate tools, software, applications, and systems to support data technology goals.Drives best practice in regards to Data warehouse, Business Intelligence, and Reporting technologies.
• Collaborates and works with Project Managers; addresses data related problems in regards to systems integration and compatibility.
• Documents Enterprise Data Architectures/environments in order to maintain a current and accurate view of Global data landscape.
• Identifies and develops opportunities for data reuse, migration, or retirement.
• Responsible for managing a growing cloud-based data ecosystem and reliability of our Corporate data lake and analytics data mart
• Contribute to the continued evolution of Corporate Analytics Platform (CAP) and Integrated data model.
• Identify gaps and weaknesses in our data stack and continue to guide learning advancements for the team
• Provide technical expertise and leadership to Data Architecture team in all phases of work including analysis, design and architecture to develop and implement cutting-edge solutions.
• Negotiate and influence changes outside of the team that continuously shape and improve the data strategy
  Required Skills :
  • 7 years of experience implementing analytics data solutions by working with and leveraging Microsoft Azure resources such as Azure Data Lake Storage, Azure Data Factory, Synapse , Databricks, Logic Apps, and ML Studio
  • 7 years of experience in data warehousing with expert knowledge of dimensional modeling concepts and performance tuning
  • The ability to evaluate existing data models and physical databases for variances, discrepancies, and redundancies
  • The ability to independently perform data profiling and analysis to understand source data
  • An understanding of the role of data security and privacy compliance and related best practices in their implementation
  • 4 years of experience using Erwin Data Modeler R9.7 or later
  • Experience with data lineage and data cataloging tools such as Informatica EDC and Alation Data Catalog
  • Experience with data virtualization platforms such as Dremio or Denodo
  • Working knowledge and experience with Python, Scala, or R
  • Bachelor's Degree or equivalent experience in Computer Science, Information Systems, or related disciplines.
  • What makes you stand out?
  • Excellent communication and presentation skills
  • Domain knowledge in one or more corporate functions such as HR, Finance, Real Estate is preferred
  • Excellent problem solving skills with innovative thinking and proactive approach
  • Ability to recommend and implement best practices and processes
    
    SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let's work better together, we mean it. You'll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work. Please find us at .
    
    EEO Employer: Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status.

Keywords: SGA Inc., Hoboken , Data Architect, Other , Hoboken, New Jersey