Programmer/Analyst

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., * Design, develop and deliver quality technical solutions that meet documented requirements

• Ability to develop application solutions in an IBMi environment utilizing a mix of; RPG III/IV, RPG Free, SQL, and CL
• Work closely with Application Development Manager, Project Managers, Business Analysts, and other IT associates to design and develop technical solutions
• Participate in technical design and review sessions with technical and business teams, with a focus on global solutions
• Focus on designing and developing integrations using API and EDI formats
• Assist in the maintenance of Enterprise Data Warehouse using SQL, database triggers, and a translation tool
• Setup and configuration of JD Edwards Dream Writers, Data Dictionaries and Menus
• Create technical estimates and manage to project designs and budgets
• Provides technical support and troubleshooting as needed, including occasional off hours support using BYOD
• Develop technical documentation to support application development activities
• Adhere to IMS and SOX policies and procedures for compliance to ensure company wide consistent standards
• Provide management with regular communication on the progress of projects and other initiatives

Who are you?

• You 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.

• 7+ years working in an IBM i (iSeries/AS400) environment
• 7+ years programming and working in RPGIII/IV, RPG Free, CLP, AS/400 Query, FTP, HTML
• 5+ years creating SQL based solutions
• 5+ years working with J.D. Edwards World Software - with focus on Financials, Order to Cash and EDI modules
• 3+ years working with RESTful API integrations

Additional Desired Experience:

• Working knowledge of IT in a distribution environment
• Knowledge of software packages used by IMS: Extol, A/R Traffic, Vertex, Aldon, ROBOT, GoAnywhere, RDi
• Knowledge of Data Warehouse concepts and ETL development using SQL
• Knowledge of programming using CGI DEV or CGI DEVII
• Knowledge of EDI X12 standards and the ability to define mappings and translations
• Knowledge of UPS and FedEx meters and interfaces
• Web based technologies: RESTful APIs, JSON, XML
• Proficient with of MS Office (Excel, Word, PowerPoint, Visio, Outlook)

Education:

• Bachelor’s Degree in computer science, Information Systems, or equivalent experience, Accounts Receivable, Advertising, Analysis Skills, Application Programming Interface (API), Budgeting, Business Analysis, Business Solutions, CGI (Common Gateway Interface), Cargo/Freight, Computer Programming, Computer Science, Consumer Branding, Corporate Compliance, Customer Relations, Customer Relationship Management (CRM), Data Processing, Data Warehousing, Database Extract Transform and Load (ETL), Database Triggers, ERP (Enterprise Resource Planning), Electronic Data Interchange (EDI), FTP (File Transfer Protocol), Git, HTML (HyperText Markup Language), IBM AS-400 Server, IP Multimedia System (IMS), Identify Issues, Information Technology & Information Systems, Internet Technology, J D Edwards, JSON, Leadership, Marketing, Marketing Communications, Marketing Software, Media Buying and Planning, Microsoft Excel, Microsoft Office, Microsoft Outlook, Microsoft PowerPoint, Microsoft Visio, Microsoft Word, Network Connectivity, Order to Cash, POP (Post Office Protocol), Procurement Planning, Project Design, Project/Program Management, Public/Media/Press/Analyst Relations, REST (Representational State Transfer), RPG Programming Language, SQL (Structured Query Language), SQL Databases, Sarbanes-Oxley Act (SOX), Software Administration, Software Development, Staff Policies, Supply Chain, Talent Management, Team Player, Technical Delivery, Technical Support, Technical Writing, Technical/Engineering Design, Test Plan/Schedule, Testing, Warehousing, Writing Skills, XML (EXtensible Markup Language), iSeries eServers

Salary range for this position is 130,000- 150,000

120,000-160,000

Omnicom’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 agree that talent is uniquely distributed, and we’re focused on developing inclusive teams that can bring the best solutions to everything we do. 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.

Link to Recruitment Privacy Notice: https://www.omc.com/privacy-notice

For US Job Seekers:

It is the policy of Omnicom and any of its affiliates to provide equal employment opportunities to all employees and applicants for employment without regard to race, religion, color, ethnic origin, gender, gender identity, age, marital status, veteran status, sexual orientation, disability, or any other basis prohibited by applicable federal, state, or local law. EOE/AA/M/D/V/F.

IMS 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. Visit us at: www.IMSretail.com.IMS is wholly owned by Omnicom Group (NYSE: OMC), an inter-connected global network of leading marketing communication companies offering a diverse, comprehensive range of marketing solutions spanning brand advertising, customer relationship management, media planning and buying services, public relations, and numerous specialty communications services to drive bottom line results for its clients (www.omnicomgroup.com).