• Senior Data Engineer

    Location US-CA-Palo Alto
    Job ID
    Information Technology
    Position Type
  • Overview

    East West Bank is seeking a Senior Data Engineer.


    The Senior Data Engineer 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.


    • Build custom data-driven frameworks and solutions, and leverage off-the-shelf data products and tools.
    • Create extract, transform and load (ETL) processes based on mapping specification documents (STMs).
    • 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.
    • 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



    • 5+ years of experience as a Software Engineer, Database Engineer, Systems Engineer or related occupation, including experience in building and maintaining data-intensive systems and data warehouses using advanced SQL or ELT/ETL tools (including SSIS, Talend, Pentaho), OLTP, OLAP, and MDM, dimensional data modeling.
    • Broad understanding and experience of data modeling, data management, ETL and BI
    • Solid T-SQL knowledge SQL query development using MS SQL 2008 and 2012
    • Thorough understanding of relational databases and SQL.
    • Experience working with any scripting languages like Bash, Powershell, Python, and Ruby, etc...
    • Ability to use multitude of technologies to automate processing of the similar data structures.
    • Experience creating metadata driven processes to manipulate the data.
    • Ability to learn new technologies without a formal training.
    • Understanding of dimensional modelling using Kimball methodology.
    • Understanding of schema on read modelling approaches.
    • Understanding of the Data Warehouse Data Vault methodology.
    • Enjoying working with the data and processes around it.
    • 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 Banking systems experience.



    • Experience in cloud computing and big data analytics
    • AWS, MS Azure, Eucalyptus, OpenNebula, CloudStack and OpenStack

    • Hadoop

    • MapReduce model

    • Google File System

    • Experience with Amazon RedShift or Azure SQL Data Warehouse

    • Experience in building enterprise data warehouse
    • Experience working in Agile teams utilizing Atlassian products, e.g. Confluence, Jira.
    • Experience in Predictive, Prescription, and Descriptive Analytics
    • Technical skills:
      • C#, VB.NET


    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.