Senior Programmer Analyst

Senior Programmer/AnalystIMS represents leading brands at the point of purchase – in store, online, and behind the scenes – including digital and traditional signage, print and POP, branded merchandise, and more. Our marketplace is solution agnostic, so our clients achieve best execution at lowest price throughout North America. Our integrated platform (planning, procurement, freight, warehousing, kitting, fulfillment, field execution, analytics, and program management) empowers our clients to stay at the strategic level, knowing that we can help turn their marketing vision into a reality.The Senior Programmer/Analyst's role is to define, develop, test, analyze, and support software applications in support of the achievement of business requirements. This includes designing, coding, testing, and analyzing software programs and applications. This position will proactively interface with internal customers, project managers and business analysts, and the technical/programming staff to ensure effective definition and the delivery of business applications. This position requires both business hour and off hour support for all deployed software applications and processes.Responsibilities include:Design, develop and deliver quality technical solutions that meet documented requirementsAbility to develop application solutions in an IBMi environment utilizing a mix of; RPG III/IV, RPG Free, SQL, and CLWork closely with Application Development Manager, Project Managers, Business Analysts, and other IT associates to design and develop technical solutionsParticipate in technical design and review sessions with technical and business teams, with a focus on global solutionsFocus on designing and developing integrations using API and EDI formatsAssist in the maintenance of Enterprise Data Warehouse using SQL, database triggers, and a translation toolSetup and configuration of JD Edwards Dream Writers, Data Dictionaries and MenusCreate technical estimates and manage to project designs and budgetsProvides technical support and troubleshooting as needed, including occasional off hours support using BYODDevelop technical documentation to support application development activitiesAdhere to IMS and SOX policies and procedures for compliance to ensure company wide consistent standardsProvide management with regular communication on the progress of projects and other initiativesYou have at least 5 years of experience as a Senior PA working in a supply chain and ERP environment. Ideally you have JD Edwards World experience with the Financial, EDI and Order to Cash modules. You thrive in a fast-paced and agile environment where you want to be leader in providing solutions.Traits / Behaviors Desired:Solution Oriented – you don't let constraints get in your way. You are comfortable articulating issues or consequences of decisions but are happy to find a way to make it work (for now).Collaborative – it takes a village! You eschew "us vs. them" mentality and seek to understand how all the pieces fit into place and how to lead and follow for the best team outcome.Git-R-Done – You have a bias for action and "trying it out". You realize that a fast 80% solution that answers most of the questions is better than a slow one that gets 95% of it. Sure, there are conditions – but you trust your colleagues to understand and act appropriately.Leadership – You challenge your team as well as yourself to explore new ideas and technologies, develop ways to work better and bring these to fruition.Experience/Qualifications:7+ years working in an IBM i (iSeries/AS400) environment7+ years programming and working in RPGIII/IV, RPG Free, CLP, AS/400 Query, FTP, HTML5+ years creating SQL based solutions5+ years working with J.D. Edwards World Software – with focus on Financials, Order to Cash and EDI modules3+ years working with RESTful API integrationsAdditional Desired Experience:Working knowledge of IT in a distribution environmentKnowledge of software packages used by IMS: Extol, A/R Traffic, Vertex, Aldon, ROBOT, GoAnywhere, RDiKnowledge of Data Warehouse concepts and ETL development using SQLKnowledge of programming using CGI DEV or CGI DEVIIKnowledge of EDI X12 standards and the ability to define mappings and translationsKnowledge of UPS and FedEx meters and interfacesWeb based technologies: RESTful APIs, JSON, XMLProficient with of MS Office (Excel, Word, PowerPoint, Visio, Outlook)Education:Bachelor's Degree in computer science, Information Systems, or equivalent experienceSalary range for this position is 130,000- 150,000Omnicom's policy requires employees to work in the office for a minimum of three days a week, unless additional in-office days are directed by their agency or manager. Our objective is to increase this requirement over time, and many of our agencies as well as Omnicom's corporate group already require five days of in-office attendance.Omnicom is committed to hiring and developing exceptional talent. We strongly believe that celebrating what makes us different makes us better together. Join us—we look forward to getting to know you. We will process your personal data in accordance with our Recruitment Privacy Notice.