YRC Freight Systems Analyst 2 in Overland Park, Kansas
Responsible to build, enhance and support Pricing systems that allow the Pricing Managers and Pricing Analysts to grow revenue and profit and improve efficiency in their analysis.
Under moderate supervision, complete medium to high complexity projects. Complete assigned projects, develop, document, and implement Pricing systems, tools and applications. Communicate with the customers, management, and team.
Responsible for review, design, analysis, new development, on-going support and modification of the Pricing systems. Responsible for the optimization and performance improvements of the new and existing code base. Responsibility include design and development of integration processes, Pricing systems solutions, development in heterogeneous databases environment, navigation through medium complex systems configuration.
ESSENTIAL DUTIES AND RESPONSIBILITIES
Ensure accuracy and integrity of the data and Pricing systems applications through analysis, coding, writing clear documentation and problem resolution.
Analyze data structures content and ensure performance validity.
Design, code, test, and implement data integration solutions using modern techniques and programming language.
Design, code, test, and implements Pricing systems solutions, including report, dashboards, notifications, in support of the business requirements.
Provide database development assistance in creating specific applications for the Pricing & Yield Management department.
Participate in research and apply innovation at all levels of the software development process.
Work on multiple projects simultaneously.
Work harmoniously in a cross-functional teams including Pricing Systems team members, other business resources as well as IT department.
Perform the role of the designer responsible for moderately complex systems and their subsystems employing knowledge of current technology and tools, as well as relevant systems that are already existing.
Provide excellent customer service by responding to and assisting with resolving issues and system outages.
Contribute to production support activities and processes.
Follow existing development standards and participate in standards reviews and renovation.
Adaptability - Maintaining effectiveness when experiencing major changes in work responsibilities or environment (e.g., people, processes, structure, or culture); adjusting effectively to change by exploring the benefits, trying new approaches, and collaborating with others to make the change successful.
Building Trusting Relationships - Using appropriate interpersonal styles to establish effective relationships with customers and internal partners; interacting with others in a way that promotes openness and trust and gives them confidence in one’s intentions.
Collaborating - Working cooperatively with others to help a team or work group achieve its goals.
Communication - Conveying information and ideas clearly and concisely to individuals or groups in an engaging manner that help them understand and retain the message; listening actively to others.
Continuous Learning - Actively identifying new areas for learning; regularly creating and taking advantage of learning opportunities; using newly gained knowledge and skill on the job and learning through their application.
Initiating Action - Taking prompt action to accomplish work goals; taking action to achieve results beyond what is required; being proactive.
Work Standards - Setting high standards of performance for self and others; assuming responsibility and accountability for successfully completing assignments or tasks; self-imposing standards of excellence rather than having standards imposed.
Bachelor’s degree specializing in computer science or equivalent work experience required.
Three (3) or more years of experience with RDBMS, and related areas Transact-SQL, SSIS, Stored Procedures, Views, etc.
Two (2) or more years work experience in transforming XML, Flat files, or other delimited formats into RDBMS.
Sound knowledge of traditional as well as agile software development methodologies.
Ability to apply Database Design Principles.
Strong ability to carry out research and innovation.
Highly effective working in a team, as well as working independently.
Demonstrated good oral and written communication skills.
Demonstrated strong initiative and organization skills.
Demonstrated strong customer service and interpersonal skills.
Microsoft SQL Server experience.
Experience with Server-side development (PHP, ASP.Net, or related).
Visual Basic for Applications (VBA).
Experience with Java development.
Experience with Business Intelligence tools including visualization (MS Power BI, Tableau, etc).
Bonus: mainframe experience, SAS, JCL or similar.
This job operates in a professional office environment indoors. Routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets, and fax machines.
The position requires the ability to spend long hours sitting or standing while using office equipment and computers. Ability to perform repetitive tasks such as typing and keying. Occasional lifting, pushing/pulling, carrying 10 lbs of supplies and materials is required.
YRC Worldwide, along with all subsidiary companies, are an Equal Opportunity/Affirmative Action Employer
Title: Systems Analyst 2
Location: KS-Overland Park
Requisition ID: 2000CZ