Coronavirus (COVID-19) Update: Pearson VUE has suspended test delivery at its company-owned US and Canada-based testing centers for at least 30 days until April 16, or whenever conditions are deemed safe to reopen. Learn more.

Data Systems Manager

Job Title: Data Systems Manager
Department: Information Technology
Reports To: Director of Information Technology
FLSA Status: Exempt

Position Summary: Work closely with internal stakeholders to propose, create, support and maintain optimal business application solutions. Primary responsibilities include serving as the administrator for Microsoft Dynamics CRM, Wrike project management and G Suite, overseeing the data warehouse, conducting enterprise application testing, and providing support for PTCB staff in the use of hardware, software, and network services.

Essential Duties and Responsibilities: To perform this job successfully, an individual must be able to perform the following satisfactorily; other duties may be assigned. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

CRM Administrator - (55%)

  • Perform Microsoft Dynamics CRM administrator functions.
  • Assign and manage security roles for Microsoft CRM users.
  • In coordination with the IT team, maintain tight control of access rights, security settings, and user privileges.
  • Support, and at times, own, the customization of entities, workflows, fields, and forms in CRM.
  • Manage all automated processes on a daily, weekly, monthly, and quarterly basis.
  • Provide help to staff to resolve issues in Microsoft Dynamics CRM.
  • Assist with the development and maintenance of regression testing scripts related to software releases.
  • Responsible for supporting end-to-end test plans for CRM project releases. Executing these plans during release rollouts with the help of PTCB staff and managing all activities in the plan to ensure that all the objectives are met and that the solution works as expected.
  • Provide data as requested from staff from Microsoft Dynamics CRM and SQL.
  • Analyze and document business process flows. Suggest improvements and carry out system modifications as needed.
  • In coordination with the IT team and Certification Products Manager, develop and maintain training materials.
  • In coordination with the IT team, review and revise policies and procedures to ensure they comply with system architecture and workflow.
  • In coordination with the IT team, develop, update and maintain custom reports and dashboards specific to PTCB departments. This is to include Microsoft SQL Server Reporting Services, SQL Server Integration Services, develop ad hoc SQL queries, scripts and/or procedures to summarize and export data.

Enterprise Applications and Project Management - (25%)

  • Work with PTCB departments to identify issues and gaps, build consensus, and develop solutions across departments that meet business needs. Work with software vendors and contractors to integrate enterprise applications as needed.
  • Identify and define opportunities and enhancements of business application solutions and work with PTCB staff to prepare business cases to support such initiatives.
  • Work with the IT team to manage planning activities, including road-mapping, release planning, and development of documented solution visions and roadmaps.
  • Provide data as requested from staff for various enterprise applications.
  • System administrator along with the IT team for Wrike project management and G Suite.

IT & Helpdesk - (20%)

  • Provide basic helpdesk support to staff to resolve desktop and network issues.
  • Work with offsite network support service providers to ensure Tier 1 support issues are resolved in a timely fashion.
  • Coordinate with vendors and service providers to troubleshoot relevant issues including phone, printers, fax problems, etc.
  • Work with network support vendor to ensure software updates are applied on a regular basis on servers and other hardware.
  • Responsible for setting up new laptops/desktops.
  • Responsible for new-hire setup/onboarding and ex-hire processes including provisioning or de-provisioning employee accounts across databases, tools, dashboards, corporate network, etc.
  • Monitor for performance, reliability, stability, and compatibility of other IT systems.
  • Uphold IT security policies and explore ways to enhance IT security.
  • Primary point of contact for day-to-day task management of Managed Service Provider (MSP).
  • Develop training documentation of relevant IT processes to be performed by end-users.
  • Suggest system modifications to mitigate potential business impediments.
  • Support Director of IT and other IT team members as needed in all areas of IT administration, maintenance and management including network infrastructure, servers and workstations.
  • Assist in IT training and updating user guides and policies.
  • Track and report on IT metrics.
  • Assist all departments with 
  • custom and/or ad hoc reporting needs.
  • Other duties as assigned.

Competencies: To perform the job successfully, an individual should demonstrate the following.

Achievement Focus - Demonstrates persistence and overcomes obstacles. Measures self against standard of excellence. Recognizes and acts on opportunities. Sets and achieves challenging goals. Takes calculated risks to accomplish goals.

Adaptability - Accepts criticism and feedback. Adapts to changes in the work environment. Changes approach or method to best fit the situation. Manages competing demands.

Communications - Exhibits good listening and comprehension. Expresses ideas and thoughts in written form. Expresses ideas and thoughts verbally. Keeps others adequately informed. Selects and uses appropriate communication methods.

Customer Service - Displays courtesy and sensitivity. Manages difficult or emotional customer situations. Meets commitments Responds promptly to customer needs. Solicits customer feedback to improve service.

Planning & Organization - Integrates changes smoothly. Plans for additional resources. Prioritizes and plans work activities. Sets goals and objectives. Uses time efficiently. Works in an organized manner.

Problem Solving - Develops alternative solutions. Gathers and analyzes information skillfully Identifies problems in a timely manner. Resolves problems in early stages. Works well in group problem solving situations.

Teamwork - Balances team and individual responsibilities. Contributes to building a positive team spirit. Exhibits objectivity and openness to others' views. Gives and welcomes feedback. Puts success of team above own interests.

Qualifications: To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Education/Experience:
Bachelor's degree from four-year college or university; or three to five years related experience and/or training; or equivalent combination of education and experience.

  • Minimum 3 years of project management experience with the ability to organize, plan, envision and execute
  • 3 years of business/functional analyst experience
  • Microsoft and/or IT industry certifications are a plus.
  • Experience in Quality Management Software and Processes
  • Knowledge and experience in technical aspects of software solution being tested
  • Business process understanding
  • Familiarity with Active Directory, Group Policy and Network shares (file and device)

Language Ability:
Read, analyze and interpret business, professional, technical or governmental documents. Write reports, business correspondence and procedure manuals. Effectively present information and respond to questions from managers, customers and the public.

Mathematical Ability:
Add, subtract, multiply and divide in all units of measure, using whole numbers, common fractions and decimals. Compute rate, ratio and percent, and draw and interpret bar graphs.

Reasoning Ability:
Solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists. Interpret a variety of instructions furnished in written, oral, diagram, or schedule form.

Computer/IT Skills:
Microsoft Dynamics CRM.
Google Suite.
Microsoft Operating Systems and Microsoft Office.
Networking administration.
Ability to write SQL queries and manage databases.
Wrike.

Other Qualifications & Skills Preferred:
Clear communicator (written and verbal) – to ensure ability to write test plans and test cases. To communicate bugs to developers and other stakeholders.
Creative solving of technical problems – to ensure the ability to translate technical requirements test plans.
Ability to focus on deadlines and deliverables – ensures the ability to find the bad defects and bugs quickly.
Strong interpersonal skills and ability to relate to and interact with a wide variety of users.
Ability to maintain high level of confidentiality.
Ability to establish priorities and handle multiple work tasks effectively.

Certificates and Licenses:
Certification in networking, helpdesk, project management or Microsoft preferred

Supervisory Responsibilities: None

Work Environment: The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. This job routinely uses standard office equipment such as computers, phones, photocopiers, and fax machines. Regular and satisfactory attendance required.

Physical Demands: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. While performing the duties of this job, the employee is regularly required to talk, hear, and type. Moving around and setting up technology equipment. Example: Monitors, computers, cables, switches, TV’s, & phones.

The above job description is not intended to be an all-inclusive list of duties and standards of the position. Incumbents will follow any other instructions, and perform any other related duties, as assigned by their supervisor.

 

To apply, please send your resume and cover letter to apply@ptcb.org.