Data Warehouse Specialist #13014U6 | Paychex, Inc. | New York-Rochester-Rochester Kenneth Drive Office

Data Warehouse Specialist #13014U6 | Paychex, Inc. | New York-Rochester-Rochester Kenneth Drive Office

Job Description 

Data Warehouse Specialist-13014U6

Description

With headquarters in Rochester, NY, Paychex, Inc. has more than 100 offices and serves approximately 554,000 payroll clients nationwide.  We provide comprehensive payroll services, including payroll processing, payroll tax administration, time and attendance solutions, and employee pay services. Human Resource Services include 401(k) plan recordkeeping, workers' compensation administration, section 125 plans, a professional employer organization, and other administrative services for business. 

Paychex is always looking for individuals who want to work for a company that allows for growth and development. With your desire to succeed and our training and resources, opportunities at Paychex are more than just jobs. They are your chance to build a solid career with a company named to FORTUNE magazine's "100 Best Companies to Work For" list seven times since 2002.  We provide an atmosphere that fosters a healthy work life balance, and our comprehensive benefits package provides health care, retirement planning, education assistance, and much more.

• Validates requirements, performs analysis, design, programming, testing, documentation and support for assigned projects to drive Enterprise Data Warehouse enhancements and changes.
•  Acquires and utilizes strong technical and/or application knowledge to independently produce deliverables and recognizes the possible outreaching impact of each proposed change.
•  Creates complex queries for the Enterprise Data Warehouse users when they request assistance in getting to the results they need to analyze and/or when performance tuning of the user created queries is a concern.
•  Responds to questions, researches / resolves issues and/or coordinates resolution of issues to complete project work and provide technical support for Enterprise Data Warehouse, including high impact production issues.
•  As requested, for the development related work on the project team, defines tasks, gathers estimates, and assists in prioritizing work.  Collects and tracks status against the schedule to monitor project progress for the development activities.  As requested, acts as a focal point to communicate department project activities and status. 
• Defines and develops appropriate 'tie-outs' (controls to monitor quality of each data load) to validate each data load into the Enterprise Data Warehouse. 
• As requested, reviews and provides input to documentation for other departments (e.g. support, training, business units).
• Ensures team compliance with standards and procedures (e.g. change management, version control, implementation) and/or consistency of coding.  Recognizes code, process and/or standard inefficiencies and suggests new standards and opportunities for improvement.
• Participates in investigation of opportunities for improvement for the Data Warehouse design or implementation, and makes recommendations to improve the environment (both technical and end user experience).  May consult technical equipment / software vendors and current users in these evaluations.

Qualifications

BA/BS degree in computer-related field with a minimum of five years relevant experience or the equivalent combination of education and experience.  Experience using one or more programming languages.  Data Warehouse experience preferred.

  

Required: 

• 5+ years relevant experience
• 1+ years experience with data warehouses
• 2+ years experience using one or more ETL tools
• Must be very strong in SQL

Preferred:

• Experience with ODI is a plus
• Experience with a Change Data Capture tool is a plus
• Demonstrated leadership experience is a plus

Job Category

:  Information Technology

Primary Location

:  New York-Rochester-Rochester Kenneth Drive Office

Rochester Kenneth Drive Office 

220 Kenneth Drive Suite 100 (Kenneth Drive Location)

 Henrietta 14623

Schedule

: Full-time

https://paychex.taleo.net/careersection/external/jobdetail.ftl?lang=en&job=13014U6