Objectives and Key Deliverables
Our client delivers the industry’s most powerful End-to-End Merchandise Optimization solution, enabling retailers of all sizes to execute a fact-based Omni-channel merchandising strategy utilizing the most comprehensive set of shopper demand signals to enhance financial performance with improved customer satisfaction. Ouc clients’ solutions leverage advanced predictive analytics and demand-based science to ensure retailers have the right product, price, promotion, placement and space allocation for optimal results across all touch points in the Omni-channel shopping episode – online, in-store, social and mobile. Offered on a scalable, high performance Cloud-based SaaS platform, these solutions future-proof retailers from Big Data/Fast Data challenges, while providing speed-to-ROI. Over 33,000 retail locations and $140+B in annual revenue across grocery, drug, building materials, convenience, general merchandise, discount, sporting goods stores and eCommerce sites optimize with our clients’ solutions. Our client has been recognized as a 2012 Deloitte Technology Fast 500™, Red Herring Top 100 Global, Red Herring Top 100 Americas
Roles and Responsibilities: Our client has an immediate opening for a Systems Engineer to support their global expansion. The successful candidate will exhibit strong software and retail or consumer package experience. The position is suited for a highly motivated, highly technical individual with the ability to professionally interface with customers. The individual will have hands on ETL or Informatica development experience with a proven record of building and coding the framework necessary for data integration and process workflow. The individual will also have a proven ability to work within a team in a demanding environment and must demonstrate leadership skills working with multiple people, projects and cutting edge technology, while maintaining a high level of execution. Master Informatica Power Center Work with customers remotely and on site to assist them with data integration activities. Respond to customer change requests, support calls and production issues Coordinate with and manage data Integration services business partnersEnsure the timely and accurate customer data collection process from multiple disparate sources into a single manageable customer database environment based on Microsoft SQL Server. Engage in data collection, cleansing and mapping. Review incoming files and provide feedback on the level of data quality and completeness based on Revionics data specification standards. Configure customer database in preparation for weekly price optimization analysis. Document customer system data flows and data integration requirements specifications Configure database settings and develop data integration mappings and workflows.Design, develop and maintain Data Integration processesCollaborate with Product Development and Customer Service teams.Provide regular reports on data collection activities and progress Requirements: Strong T-SQL skills (Queries, Triggers, Stored Procedures, etc)Understanding of common Internet-based file transfer techniques.Proven computer skills with common Microsoft tools such as Windows, Office, Visio, Project, and SQL Server. Superb customer communications skills, written, oral and face-to-faceAbility to turn business issues into technical solutionsAbility to develop collaborative relationships both internal and external Ability to navigate and manage technical issues internally and externally Demonstrated passion and enthusiasmExtreme attention to minute detail Superb organization and time management skillsHighly logical and technical personWell-developed team leadership skills A team player that can add value technically and personallyKnowledge of European languages other than English Preferred Candidate Attributes: Understanding of data formats and prevalent commercial databasesMinimum of 2 years of experience in data management and synchronization. 5 years of experience with ETL2 years programming experience or equivalent education is required. Knowledgeable with retail item catalogs and related master files1 years proven Power Center, Data Transformation Development and/or Informatica Administration experience Knowledge of T-SQL (Bulk Copy Program – BCP, Stored Procedures) Data Warehousing and Business IntelligenceFamiliar with data cleansing and manipulation techniquesVarious Text editors and their functionalityRegular ExpressionsInterpreting data specification documentsXML Grocery Store Back Office SystemsDOSWebExScripting experience/skillsFTP Data reporting and storage techniquesThis individual is ideally based in London. Other locations will also be considered for suitable candidates.