• Sr. Data Warehouse Developer

    Location US-CA-El Monte
    Job ID
    2018-5685
    Category
    Information Technology
    Position Type
    Full-Time
  • Overview

    For more than 40 years, East West Bank has served as a pathway to success. With over 130 locations across the U.S. and Greater China, we are the premier financial bridge between the East and West. Our teams of experienced, multi-cultural professionals help guide businesses and community members on both sides of the Pacific looking to explore new markets and create new opportunities. And our sustained growth and expertise in industries like real estate, entertainment and media, private equity and venture capital, high-tech and aviation help build sustainable businesses and expand our employees’ potential for career advancement.

    Headquartered in California, East West Bank (Nasdaq: EWBC) is a top performing commercial bank with an exclusive focus on the U.S. and Greater China markets. With assets of $37.7 billion, we’re ranked among the 30 largest banks in the United States and currently top 5 in “America’s 100 Best Banks” by Forbes, a list where we've consistently been in the top 15 since 2010. With a strong foundation, an enterprising spirit and a commitment to absolute integrity, East West Bank gives people the confidence to reach further.

     

    Summary:

     

    This position designs and constructs East West Bank enterprise-wide data and information architecture to support business intelligence and data warehouse efforts. Responsible for the design, implementation and maintenance of data warehouse and data marts. ETL development skills using Microsoft SSIS, expertise in relational structures, dimensional data modeling, and T-SQL skills are a must.  Responsibilities will include physical design and creation of physical database, Work-Load-Management/Priority Scheduling, data & user security; SQL performance tuning, and enforcement of standards, data replication and documentation. Help the Bank adopt and organize data. He or she will improve existing systems (and potentially assess new technologies) to make it easier to manage and deliver information. Combining their knowledge of technology and business management to deliver state-of-the-art business intelligence solutions, improve efficiency.

     

    Primary Duties and Responsibilities:

    • 10+ years of SQL Server ETL Development experience using SSIS. Strong ETL, data warehouse, T-SQL skills.
    • Understanding of data warehouse and data mart architecture, and Kimball methodology.
    • 8+ years of strong hands on experience building large scale databases
    • Broad understanding and experience of data modeling, data management, ETL and BI
    • Experience in building enterprise data warehousing with table partitioning, encryption and data compression
    • Experience with database migration
    • Perform ongoing monitoring, automation and refinement of reports and BI solutions.
    • Work with BI Management to identify and resolve data related issues.
    • Work with business departmental teams to help them define and document business requirements for new metrics and reports.
    • Participate in process reviews and enhancements.
    • Provide analysis and issue resolution on business reported concerns.
    • Participate in design and delivery of cubes, dashboards and various self-service business intelligence solutions.

    Other:

     

    • Enforces established documentation guidelines and best practices.
    • Maintains a high degree of business functional knowledge and current automated technologies and tools.
    • Adheres to all policies and procedures concerning all confidential information including but not limited to internal use and restricted information

     

    Qualifications:

    Required

    • Requires 10+ years of SQL Server BI development (SSRS/SSIS/SSAS) experience
    • Solid T-SQL knowledge SQL query development using MS SQL 2008 and 2012
    • Thorough understanding of relational databases and SQL.
    • Excellent communication, interpersonal and organizational skills
    • Ability to prioritize, meet deadlines and to work well under pressure
    • Must enjoy working in a fast-paced teamwork environment and dealing with a variety of people

     

     

    Desired

    • Banking systems experience.
    • Team Foundation Server or a similar source control software experience.
    • Business Intelligence (BI) tools (i.e. SAS, Tableau, PowerView, PerformancePoint)
    • Technical skills:
      1. C#, VB.NET
      2. OCX Controls and imaging
      3. MSMQ

    Options

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

    Connect With Us!

    Not ready to apply? Connect with us for general consideration.