• Sr. Software Developer - Data Warehouse-ETL

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

    A Brand That's What's Now

    Express is the sexy, sophisticated lifestyle fashion brand for every occasion: work, weekends, or nights on the town.  Our brand is what's new and what's now for young fashion-forward men and women.  We have more than 600 retail and outlet stores throughout the United States and Puerto Rico, as well as franchise stores in Latin America.  We also have a best-in-class online/mobile shopping experience at www.express.com that allows our customers to shop whenever and wherever they like.  


    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 about.  This 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!


    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


    Job Requirements


    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, technical expertise and recommend appropriate solutions
    • 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
    • Participate in discussions concerning innovative, cost effective ways to implement new technologies to lead in the evaluation of new products, platforms, and technologies leveraging best practices based on industry standards and lessons learned while taking initiatives.
    • Coordinate with any vendors for escalation of support related issues

    Responsibilities –

    • Determines feasibility of requests, identifies best approach to provide technology solutions to meet business needs and provide detailed estimations (time, cost, resources)
    • Works with solution engineer to design and architect solutions and lead the implementation and delivery
    • Provides recommendations for enterprise data and ETL architecture.
    • Provides support and troubleshooting for all related systems and technologies. This includes being a point of contact for business users
    • Leads 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 a related degree, or equivalent experience
    • Knowledge of retail industry
    • 5+ years of systems analysis and programming experience; minimum four years of lead data engineering design activities
    • 5+ 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.
    • Extensive 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 some of the ETL tools between ODI or Ab Initio 
    • Hands on experience with MPP databases like Teradata, Netezza or Redshift is a definite must
    • Hands on experience with transaction databases like Oracle, SQL Server.
    • Highly proficient in SQL.
    • Experience in Data Warehousing architectures, techniques, and methodologies including: Star Schemas, Snowflake Schemas, Slowly Changing Dimensions, Aggregation Techniques, etc.
    • Experience in upgrading EDW platforms.
    • Experience in customer-facing discussions for requirements gathering and architecting solutions for data engineering projects. Ability to train and mentor team members users. Good analytical, inter-personal & communication skills, with proactive attitude
    • Experience with Performance Optimization tuning and techniques

    Preferred –

    • Experience in integration with Hadoop and other big data platforms
    • 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
    • Teradata database administration experience or knowledge
    • Experience with designing job schedules using BMC Control-M or CA Automic











    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.


    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!