TravelClick

  • Senior Data Engineer & Analyst

    Job Locations US-GA-Atlanta
    Job ID
    2018-2504
    Category
    IT
  • Overview

     

    The Senior Database Engineer & Analyst will be responsible for the end-to-end design, implementation, and maintenance of operational and reporting database systems that is the foundation of our BI platform. The Senior Engineer will have the business acumen to analyze and understand business processes and BI requirements and translate them to the conceptual, logical and physical data model and ETL processes following ETL and DW best practices.  A solid understanding of DW concepts (dimensional modeling, ETL process design, and enterprise data quality) is required along with hands on (DBA level) knowledge of Oracle Database PL/SQL development, tuning, Linux/Unix OS platform, as well as Shell/Perl scripting.  Exadata experience would be a plus.  The ideal candidate will be versatile across various roles including ETL Development, Data warehouse Design, Business Analysis, PL/SQL Development, Linux Scripting and Oracle DB Administration and Tuning. 

    Responsibilities

    • Engage with key business owners to understand data and BI requirements for TravelClick’s portfolio of BI products. Ability to understand business processes, data flows, and dependencies across operational systems to determine proper design for ETL and DW.  
    • Based on analysis of requirements, construct an effective DW model (star schema) and ETL process (using PLSQL and/or other ETL tools). ETL development should incorporate key ETL design principles including Full/Incremental loads, change data capture, and aggregations.  Experience with tuning SQL for Exadata is preferred. 
    • Familiarity with ETL data quality processes and design. Travelclick has a large number and variety of global data sources. As such, the DB Engineer must be able to analyze heterogeneous data sources, develop validation and data cleansing processes, and ensure ETLs properly handle data granularity, data redundancy, and ensure integrity of the target DW.  
    • With limited supervision explore current state of Enterprise architecture, sources,
    • Design and implementation of data warehouse architecture, physical model and modifications of existing databases (perform data modeling, data architecture, schema management, data object management and other necessary activities)
    • Monitor and maintain availability, reliability and overall health and solution delivery of databases
    • Design, develop and implement monitoring processes to troubleshoot/resolve any database processes.
    • As needed, tune and optimize overall database performance including tuning of database processes, SQL, table/index design, partitioning.
    • Administer DBA responsibilities when required.
    • Willingness to work other alternative data storage technologies (Hadoop, Druid, BigQuery, etc.)

    Basic Qualifications

    Experience and Qualifications:

    • 7+ years in Oracle PL/SQL including stored procedures, packages, functions and triggers for Datawarehouse and ETL processes
    • Experience with full lifecycle ETL and DW design and implementation for multiple heterogeneous data sources
    • 5+ years in building large scale ETL or ELT applications.
    • Experience with data quality, Oracle DB PLSQL tuning, and object oriented framework.
    • Oracle 10 / 11g subject matter expert (Experience with Oracle EXADATA preferred)
    • 5+ years experience working in a UNIX, Linux and Windows operating systems
    • 3+ years experience in UNIX/Linux shell scripting and PERL
    • Experience with commercially available/open source ETL tools
    • Experience with Data Modeling tolls like ErWin or DeZign
    • Experience with operation systems and scripting – (Unix/Linux)
    • Experience with troubleshooting, performance optimization
    • Experience with alternative data storage a plus (Druid, Hadoop, BigQuery, etc.)

    Personal Attributes:

    • Must have a collaborative attitude and ability to take initiative to explore existing current state architecture and business processes.
    • Candidate must have the ability to adapt to new products/solutions if needed.
    • With limited supervision plan, design, and implement performant ETL scripts per business requirements. Ability to communicate effectively with business owners and derive key requirements and ensure data quality and integrity. 
    • Candidate must be “self driven” and able to own a solution from design to delivery with minimal direction from management
    • Ability to multi-task and push forward multiple projects simultaneously
    • Excellent communication and critical thinking/problem solving skills are essential
    • Efficient time management and ability to prioritize tasks are a must
    • Work usually performed between 8:30 and 5:30 in business office environment. Minimal (if any) travel is expected
    • Ability to assume leadership the situation requires it.

    EEO Statement

    “All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.”

    Options

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