• Senior ETL Developer

    Job Locations US-IL-Downers Grove
    Requisition ID
    2018-12498
    Category
    Information Technology
  • Overview

    Summary
    Are you passionate about the retail grocery market and organic products? Are you a leader? Are you ready to join one of the fastest growing companies in the retail grocery market? If so, Fresh Thyme Farmers Market is the place for you! Our unique business model, fast paced and growing environment, promote from within culture, and excellent benefits make Fresh Thyme the best employer in the grocery market. Careers have been blooming at Fresh Thyme since our inception in 2012 - yours should be no different!

     

     

    Position Description:
    The Senior ETL Developer is responsible for providing technical leadership focusing on starting and growing the Data & Analytics program at Fresh Thyme Farmers Market (FTFM). Concentration will be on defining a data and analytics strategy roadmap for a cloud native Data and Analytics Platform. The Sr. ETL Developer will be expected to design, develop, test, debug, implement and maintain Extract, Transformation & Load (ETL) system. This role needs to understand business requirements, develop ETL solutions, aid in the development of Tableau reports and provide ongoing support for the Enterprise Data Warehouse (EDW)

     


    Essential Duties and Responsibilities

    • Database/data integration with ETL tools like Informatica, DataStage, Cleo, etc.
    • Design database schema, tables, and procedures
    • Support ETL architecture, design and development
    • Design and implement secure data pipelines into a Snowflake data warehouse from on premise and cloud data sources
    • Design and implement data pipelines to prepare, process and organize data in the warehouse
    • Creation of architecture and design artifacts and documents
    • Develop functional specifications for data acquisition, transformation and load processes
    • Conduct code reviews and participate in technical design
    • Prepare unit test, integration test plan documents and perform unit test, system integration test; document test results
    • Ensure data integration/ETL is implemented & monitored successfully to enable data quality, availability, data freshness and meet performance requirements to support reporting
    • Monitor daily/other database jobs and data loads to resolve issues pro-actively and ensure maximum uptime/availability of the databases for reporting
    • Support designing & developing database and data sourcing/ETL requirements to ensure efficient reporting and BI
    • Support the Data and Analytics team during functional, UAT, regression, and performance testing
    • Provide technical expertise and leadership for the administration of the Snowflake Datawarehouse, including design, development, installation, and maintenance, performance monitoring, backup and recovery, migration, etc;

     


    Knowledge, Skills, and Abilities
    • 5+ years' progressive experience as a database developer
    • 5+ years' experience of ETL applications design and development
    • 5+ years’ experience with several data warehouse architecture techniques such as EDWs, ODS’, Data marts using a variety of data modeling tools and techniques.
    • Demonstrated experience with ETL tools such as SSIS, Informatica, Cleo, etc
    • Excellent understanding of DW design and dimensional data modeling
    • Experience in project life cycle activities on DW/BI (Data warehouse and Business Intelligence) development and maintenance projects
    • Excellent communication and inter-personal skills
    • Ability to handle multiple projects and prioritize tasks in a rapidly changing environment
    • Previous experience of building data warehouses in a retail environment is a huge plus

     

     

    Education and Experience
    • Bachelor’s degree in Information Technology, Computer Science, Engineering or related field required

    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.