Data Architect

US-CA-Pasadena
Category
Information Technology - Common Services

Overview

The data architect provides a standard common business vocabulary, expresses strategic data requirements, outlines high level integrated designs to meet these requirements, and aligns with enterprise strategy and related business architecture.  This role demands an influential candidate that can communicate to both IT and business representatives.

Responsibilities

  • Organize and manage data architecture documentation.
  • Define standards for data management, and train staff on principles of data architecture.
  • Improve the maturity of data architecture and data governance across the enterprise.
  • Institute governance for data architecture in the Software Development Lifecycle.
  • Plan data management scenarios to support the needs of the development, QA and production environments.
  • Create and maintain conceptual, logical & physical data models for OLAP & OLTP systems.
  • Develop data quality rules and processes with the business.
  • Present to technology leaders and business executives.
  • Provide thought leadership and contribute to the firm's overall technology strategy.
  • Analyze performance and design inefficiencies.


Qualifications

Specific Technical Knowledge and Experience Required:

  • Strong understanding of the Software Development Lifecycle and experience integrating Data Architecture and Data Governance into that lifecycle to steer towards desirable outcomes.
  • Strong competency in data modeling and data design. This includes logical and physical modeling, partitioning strategies for large tables, and other database optimizations.
  • Solid experience with Relational Databases, specifically Oracle, Data Warehousing, OLAP, and Business Intelligence Reporting. Must be able to write PL/SQL Stored Procedures.
  • Solid understanding of pros and cons for different data warehouse methodologies and architectures (Kimball/Inmon/Data Lake/Hybrid).
  • Experience designing Star, Snowflake Schemas, Dimensional Data Modeling, SCD (Slowly Changing Dimensions), and CDC (Change Data Capture).
  • Exposure to emerging data technologies such as NoSQL; must understand them sufficiently to guide the organization in understanding and adopting them.
  • Experience managing data architecture documentation, and standards for data management, as well as training staff on principles of data architecture.
  • Experience with analyzing current state and conceiving desired future state, and identifying projects required to evolve.
  • Deep knowledge of Web Services (REST), Enterprise Messaging (JMS/MQ/AMQP), and ETL.
  • Experience with Apache Spark or Hadoop for solving Big Data problems.
  • Strong understanding of agile software development methodology.
  • Excel, PowerPoint, and Visio skills.

 

Specific Technical Knowledge and Experience Desired:

  • Capital Markets industry experience, especially in Asset Management
  • Database experience with MemSQL, Microsoft SQL Server, Sybase, Mongo DB, and Neo4J.
  • Experience with Tableau, Ab Initio ETL, Collibra, Liquibase, Apache Kafka, or similar software.
  • Experience with AWS and migrating databases to the cloud.
  • Experience negotiating contracts for licensing data.
  • Experience writing code in Scala, Python, R, and SAS.
  • Experience with Bloomberg, FactSet, and YieldBook.
  • Exposure to Java development and ORM frameworks like Hibernate.

 


Qualifications (minimum requirements):


  • College degree in Computing Science or Engineering required. Certifications highly desired.
  • Minimum 5 years of experience in a Data Architect role.

How to Apply

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed