• Software Developer- ETL

    Job Locations US-OH-Columbus
    Requisition ID 2018-3217
    Category (Portal Searching)
    Information Technology
  • Overview

    The Brand that Gets You to What’s Next

    Express is the vibrant, confident lifestyle brand for ambitious people, providing the latest fashion for style-obsessed men and women since 1980. Our mission is to provide inspiration and confidence through fashion to help people get to what's next in their day, and their lives. With more than 600 retail and outlet stores throughout the United States, Puerto Rico and Latin America, and a best-in-class online/mobile shopping experience at www.express.com, Express brings city-inspired style to customers across the globe.

     

    A Workplace To Match

    We think you'll like it here. 

    We offer a competitive compensation and benefits package, generous associate discount, and casual work environment. Working at Express is much more than the 9 to 5. It is an opportunity to connect and engage with some of the smartest individuals in the fashion business doing work they are passionate aboutThis is the Express Life and we’re always looking for talented leaders at all levels to join our team; if this sounds like you, we'd love to chat!

    Responsibilities

    The "Enterprise Data Warehouse and Business Intelligence" team is the technology team responsible for defining, storing, managing and provisioning the data structures required to support the enterprise with consumption through various Business Intelligence platforms in a fast-paced and fluid environment. Individuals on this team:

    • Lead Technology design, development, implementation, and support efforts to establish solutions for providing the business with consumption capabilities of structured Enterprise Information across all Functional Areas of the business
    • Monitor and manage performance of the associated technology implementation
    • Provide stable, scalable, and recoverable solutions
    • Discover and Analyze opportunities for continuous improvement
    • Communicate insights to business leaders
    • Work cross-functionally with all other areas of IT and the business

    Role:

     

    This particular individual will – 

    • Participate in full project lifecycle to understand business requirements and then complete the design, development, testing, implementation and post-production support of data engineering solutions
    • Assist end users in resolving and identifying system issues by providing application knowledge and technical expertise
    • Have high capacity for data analysis, data modeling, problem solving, accuracy and attention to detail
    • Have good understanding of multi-channel fashion retail business processes , data and reporting needs
    • Coordinate with ETL lead for escalation of support related issues

     Responsibilities –

    • Works with solution engineer and ETL lead to design and develop data engineering solutions
    • Provides support and troubleshooting for all related systems and technologies. This includes being a point of contact for business users
    • Participate in 24/7 on-call support activities
    • Operates with minimal supervision; self starter

     Technical Skills:

     

    Required –

    • Bachelor's degree in Information Systems, Computer Science, Computer Engineering or related degree or equivalent experience
    • 3+ years of proven hands-on experience with data engineering toolsets like Unix shell scripting, ODI, SSIS, Python etc.
    • Data modeling experience in designing the logical and physical data models using ERWIN, ER Studio or similar data modelling tools
    • Experience with at least one of the ETL tools between ODI, Informatica, Datastage or Ab Intio
    • Hands on experience with MPP databases like Teradata, Netezza or Redshift
    • Hands on experience with transaction databases like Oracle, SQL Server
    • Proficient in SQL
    • Experience in Data Warehousing architectures, techniques, and methodologies including: Star Schemas, Snowflake Schemas, Slowly Changing Dimensions, Aggregation Techniques, etc.

     Preferred –

    • Experience in end-to-end implementation of data engineering projects, especially ETL involving sourcing data from disparate systems, reconciling and transforming data to load into consumable, scalable and recoverable data model at varied frequency
    • Experience with one of the OO languages (JAVA, C#, C++)
    • Experience of integrating one or more systems like ERP, POS, Order Management and Hadoop with Data Warehouse
    • Knowledge of retail industry

     

     #LI-DS2

     

    Closing

    As an equal opportunity employer, Express does not discriminate in hiring or terms and conditions of employment on the basis of any federal, state, or locally protected class.  Express only hires individuals authorized for employment in the United States.

     

     

    Notification to AgenciesPlease note that Express does not accept unsolicited resumes or calls from third-party recruiters or employment agencies. In the absence of a signed Master Service Agreement and approval from HR to submit resumes for a specific requisition, Express will not consider or approve payment to any third-parties for hires made.

    Options

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

    Need help finding the right job?

    We can recommend jobs specifically for you! Click here to get started!