Hands on data warehouse manager from asset management

03 Feb 2025

Vacancy expired!

We are searching for a manager with a solid understanding of the concepts and best practices of data warehouses and lakes, data architecture, governance, batch processing and ETL who will be able to apply these skills appropriately to this organization. This position offers a unique opportunity for individuals who are willing to commit to solving complex data integration, aggregation and automation challenges to enable our journey to a more data driven enterprise and to lead a team.Required Skills

  • 6+ years of experience with data warehouses. Designing custom or implementing vendor package. Experience building or implementing vendor systems within last 5 years.
  • Significant experience with ETL (Extract Transform Load) and ELT (Extract Load Transform) patterns and custom or vendor solutions to implement.
  • 5+ of management and working for an asset manager
  • 5+ years of experience with enterprise batch schedulers. (Active Batch is our platform)
  • 10+ years of experience with understanding Entity Relationship Diagrams, SQL schema design and database architectures (normalized structures, star schemas, ODS, data marts and warehouses)
  • 10+ years of hands-on SQL
  • 3+ years of exposing data services/API for consumers (web service or database objects) and integrating with vendor data APIs
  • Familiarity with data visualization tool (Tableau preferred)
  • Demonstrated expertise around the Microsoft SQL server technologies (SSIS SSRS, SSAS)
  • Bachelor’s degree in Computer Science, Mathematics, Electrical Engineering, or related technical discipline
  • 5+ years of Fixed Income experience in asset management. Experience with taxable (Sovereigns, Corporates, Bank Loan, Structured Securities (MBS, ABS, CMOs ) and tax-exempt securities. Specifically, as it relates to characteristics and analytics
  • Strong foundation and hands on experience with core data concepts: SMF (Security Master), portfolios, holdings, lots, trades, benchmarks and issue/issuer relationships.
  • Ability to execute multiple project simultaneously and independently.
  • Ability to balance tactical and business as usual needs while still progressing on strategic implementations
  • Strong analytical thinking and problemsolving skills

  • ID: #48989363
  • State: New York New york city 10017 New york city USA
  • City: New york city
  • Salary: $180,000 - $300,000
  • Job type: Permanent
  • Showed: 2023-02-03
  • Deadline: 2023-03-28
  • Category: Et cetera