Lead Data Architect (Informatica ETL)

Title- Lead Data Architect

Location- West Los Angeles, CA (hybrid 3 days a week)

Key Responsibilities

• Architecting and maintaining Operational data stores (ODS), Enterprise Data Warehouse (EDW) and associated data intelligence environments including data lakes, data marts, and metadata repositories.
• Designing and implementing high performance data movement pipelines using multiple ETL tools (Informatica, Azure Data Factory, SQL Packages, etc) with batch and real-time event data streams.
• Developing scalable and re-usable frameworks for ingestion of structured and semi-structured data; and implementing various large-scale settlement and reconciliation frameworks.
• Designing and creating data architecture and data flow diagrams and collaborating with peers to translate requirements into logical and physical data models.
• Ensures data warehouse features and capabilities are incorporated into data model designs to optimize performance, resiliency, and scalability.
• Delivering and presenting proofs of concept to of key technology components to project stakeholders and internal technology leaders.
• Leading and coordinating the design and operationalization of Data Governance capabilities like data lineage, data catalog, data quality, etc.

Required Qualifications

• 8+ years of overall software development experience is required primarily with Data warehouse applications, with 3+ years in a technical leadership role.
• 3+ years of hands-on development experience in Cloud-based data warehouse platform (AWS Redshift preferred) and experience with ETL tools.
• 3+ years of development experience with Python scripting experience.
• Strong knowledge and experience in OLAP data modeling & design.