Job Description: Senior Programmer/Analyst
Department: Information Technology
Reports to: IT Application Development Manager
Who we are:
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).
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 job is $125k to $150k - The salary range provided in this job posting is an estimate based on market data and internal equity. Final compensation will be determined based on knowledge, skills, experience, location, and other relevant factors, such as certain certifications that may be desired for this role.
