Agency:
Omnicom Specialty Marketing

Job Function:
Technology

Job Subfunction:
Software Development

Job Description:
Job Description: Senior Programmer/Analyst
Department: Information Technology
Reports to: IT Application Development Manager

What does the Senior Programmer/Analyst do?
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 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.

Experience/Qualifications:
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

Salary range for this position is 130,000- 150,000120,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