YRC Freight Sr BI/Database Developer in Overland Park, Kansas

JOB SUMMARY*


Under limited supervision, complete medium to high complexity projects. Lead development efforts for assigned subject area, develop, document, and implement technical designs. Communicate with the customers, management, and team.

Responsible for review, design, analysis, new development, and modification of the systems. Responsible for the optimization and performance improvements of the new and existing code base. Responsibility include design and development of the batch and near-real time data integration processes, Business Intelligent (BI) solutions, development in heterogeneous databases environment, navigation through complex systems configuration.

ESSENTIAL DUTIES AND RESPONSIBILITIES

  1. Ensure accuracy and integrity of the data and applications through analysis, coding, writing clear documentation and problem resolution.

  2. Analyze data structures content and ensure performance validity.

  3. Design, code, test, and implement software solutions using modern techniques and programming language.

  4. Design, code, test, and implements BI solutions, including report, dashboards, notifications, in support of the business requirements.

  5. Provide high-level database development assistance in creating specific applications for businesses.

  6. Participate in research and apply innovation at all levels of the software development process.

  7. Work on multiple projects simultaneously and manage competing priorities.

  8. Work harmoniously in a cross-functional teams including IT and business resources.

  9. Function as technical lead and Subject Matter Expert (SME) on assigned projects.

  10. Perform the role of the principal designer responsible for complex systems and their subsystems employing deep knowledge of current technology and tools, as well as relevant systems that are already existing.

  11. Act as a coach or mentor to less experienced team members.

  12. Provide excellent customer service by responding to and assisting with resolving issues and system outages.

COMPETENCIES* *

  1. 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.

  2. 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.

  3. Collaborating - Working cooperatively with others to help a team or work group achieve its goals.

  4. 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.

  5. 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.

  6. Initiating Action - Taking prompt action to accomplish work goals; taking action to achieve results beyond what is required; being proactive.

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

MINIMUM REQUIREMENTS

  1. Bachelor’s degree specializing in computer science or equivalent work experience required.

  2. Five (5) or more years of experience with Transact-SQL, SSIS, SSRS, Stored Procedures, Views, etc.

  3. Five (5) or more years work experience specializing in transforming XML, Flat files, or other delimited formats into RDBMS. MS SQL Server experience is required. Oracle RDBMS experience is a plus, but not required.

  4. Five (5) or more years working experience in a database development environment.

  5. Sound knowledge of traditional as well as agile software development methodologies.

  6. Ability to apply Database Design Principles (OLTP).

  7. Experience with C# and SQL SLR stored procedures.

  8. Experience with SSAS (Tabular and Multidimensional) and MS PowerBI suite.

  9. Strong ability to carry out research and innovation.

  10. Sound knowledge and experience working with software application, database design, and BI ideas.

  11. Highly effective working in a team, as well as working independently.

  12. Demonstrated good oral and written communication skills.

  13. Demonstrated strong initiative and organization skills.

  14. Demonstrated strong customer service and interpersonal skills.

PREFERRED QUALIFICATIONS

  1. Experience with Service Broker.

WORKING CONDITIONS


This job operates in a professional office environment indoors. Routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets, and fax machines.


PHYSICAL DEMANDS


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 is an Equal Opportunity/Affirmative Action Employer

Minorities/Females/Persons with Disabilities/Protected Veterans

Title: Sr BI/Database Developer

Location: KS-Overland Park

Requisition ID: 17024M