Job#: 2023290
Job Description:
Job Description:
Product Team within the Marketing and Sales maintains foundational applications that are used to update, maintain, and distribute the core dealer contract and location information. The data the team manages is in high demand throughout the enterprise. The team is working on modernizing both the core applications to Angular and its legacy interfaces to use rest APIs and Google APIGEE. This position would involve learning the front end applications, learning the data created/provided by those applications, creating/updating product documentation for large project initiatives, understanding the business need & use of dealer data, support of data questions from downstream applications, and support of annual audits. This position is also an opportunity to work with a strong team on critical core applications across multiple technologies and provides an opportunity to modernize and shape the future of the Product.
Position Duties:
- Collaborate with both the Business and IT to document Business Requirements and translate those into IT Technical Specifications
- Application/Data Support using complex data analysis and SQL skills to manage challenging data joins across multiple applications and global countries with varying Business Rules by market
- Be a part of aproduct team and collaborate with a Product Owner, Product Manager, Anchor, and software engineers
- Create high performing complex SQL queries
- Participate in PDO product team ceremonies such as Standups, Iteration Planning, Retrospectives, and Release Planning
- Managing annual SOX/SCRP/GRC audits
Primary Skills Required:
- SQL/database experience involving multiple, complex queries
- Analytical experience of complex applications and data relationships
- Application support experience including the processing of support/help desk tickets and annual audit requirements
- Team oriented with strong interpersonal skills and able to work as part of a product team
- Strong written/oral communication skills
- Strong drive for results and ability to work independently
- Demonstrated commitment to quality and project timing
- Experience in creating and executing detailed test plans
- Strong Agile Project management capabilities
- Proficient in using Rally (or similar Agile Project Management tool) to help drive a metrics driven approach for IT team
- Ability to work independently and take initiative when solving unexpected problems
- Ability to deliver under pressure
Primary Skills Preferred:
- Business/Systems knowledge with respect to Marketing Sales and especially Dealer Systems is a plus
- Experience accessing data via API through Postman
- Experience with SOX, SCRP, and GRC Audits
- Experience with Cloud Technologies (GCP)
- Experience with Security and Code Quality Tools (i.e. 42 Crunch, Checkmarx, CyCode, etc)
- Experience in extract, transform and load (ETL) development with Oracle
- Experience in working directly with PDO teams.
- Mainframe experience managing large and complex mainframe/cobol jobs with heavy ETL to manipulate data and create downstream extracts
- Ability to bring technical experience together with business knowledge
- Prior experience working with major programs/products involving multiple stakeholders or multiple regions
Experience Required
- Strong Data and ETL experience
Experience Preferred
- Experience with java API's
- Experience with the mainframe, cobol, and DB2 databases
Education Required
- Bachelors degree in an information technology related discipline
EEO Employer
Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law.
