Previous Job
Previous
Sr Data Architect
Ref No.: 17-00155
Location: Pasadena, California
Position Type:Direct Placement
Experience Level: 5 Years
 Data Architect (Senior)
$$$ OPEN and High
 
100% Relocation to LA
No Visa Transfers
 
Job Description:
 
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/Duties:
 
  • 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.
 
 
Competencies:
 
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.