Technical Operations Database Analyst

EQUAL OPPORTUNITY EMPLOYER

Position Title: Technical Operations Database Analyst

Functional Area: Information Technology

Overview:

The ideal candidate will assume primary responsibility (approximately 75% of the time) for operational and tactical database tasks, including data processing and reporting, maintenance of the database, maintaining existing reports, gathering requirements for new reports and changes to existing reports, and supporting internal and external customers. Secondarily, (approximately 25% of the time) this position is a vital in creating and maintaining the strategic partnership between business needs and technology delivery in an agile development environment supporting all APQC service lines.  The employee will be responsible for eliciting requirements from stakeholders across all APQC service lines, organizing the requirements into work products, and assist in the enforcement of project deadlines and schedules.

_____________________________________________________________________________________

Responsibilities:

Primary Role (.75 FTE)

  • Manage the help ticket system: approve requests, assign tickets to resources, research problems noted in the tickets, resolve problems, close out tickets, and correspond with the ticket creator throughout the lifecycle of the ticket.
  • Perform day-to-day maintenance tasks on the database.  Ensure that the data in the database is accurate and there is no loss of integrity.  Troubleshoot problems quickly as they arise.
  • Participate in annual survey refreshes.  This may include performing the database related refresh tasks, or working with external vendors to complete the database aspects of the project.
  • Perform regular data transfers with the primary service line funding partner. Maintain the database mapping per the funding partner’s instructions. Generate, format and send data transfer files to the funding partner’s designated point-of-contact.
  • Manage outsourced contractors by assisting in functionality requirements, implementation, and testing of work products.
  • Respond to ad hoc customer requests (internal and external) and work with them to meet their needs.
  • Assist other research projects and managers with relevant data collection efforts.  Specific tasks may including querying the database for submissions, importing bulk submissions and performing mass changes to the data.
  • Document technical processes and procedures used to support systems, tools, and processes.
  • Perform other appropriate tasks as requested.

 

Secondary Role (.25 FTE)

  • Serve as the liaison between the business owners, development teams, and end users.
  • Communicate and collaborate with external and internal customers to analyze needs and requirements, and deliver the following as needed: use cases, wireframe designs, functional requirements, system requirements specifications, and process diagrams.
  • Successfully engage in multiple projects simultaneously.

____________________________________________________________________________________

Qualifications & Skills:

  • Two (2) years of experience in database administration, data security and integrity, performance monitoring, and logical and physical database design.
  • Excellent verbal and written communication skills and the ability to interact professionally with a diverse group: executives, managers, developers and subject matter experts. 
  • Possess the ability to communicate and work with remote team members. 
  • Must be detail-oriented and able to perform duties in a fast-paced environment.
  • Ability to work on multiple projects independently.
  • Extremely deadline and detail-oriented.
  • Nimble and versatile to adapt as services or strategies change.
  • Possesses working knowledge of T-SQL, Microsoft .NET (C#), and database design.
  • Demonstrated experience in design and development for Windows based applications and Web based applications.
  • Experience working with version control mechanisms (SourceSafe, Subversion, etc.).
  • Knowledge of benchmarking and best practices is highly desirable.
  • Professional manner with excellent customer service skills.
  • Function well in a small team environment and able to work autonomously.
  • Bachelor’s degree.
  • Advanced Microsoft Office® skills.

 

Skill

Proficiency Level Required

Functional/Topical knowledge

Level 2

Business processes

Level 2

Attention to detail

Level 4

Critical thinking/problem solving

Level 4

Presentation/oral communication skills

Level 3

Technical skills (SQL, DBA, etc.)

Level 3

MS Office applications

Level 3

Writing skills

Level 3

Project management

Level 1

Teaming & leadership

Level 1

Customer service orientation

Level 4

Relationship/stakeholder management

Level 2

Interviewing users, requirement gathering

Level 2

Developing use cases

Level 2

Ability to quickly learn and become proficient in new skills

Level 3

Estimation of technical deliverables

Level 2

Definition of Proficiency Levels:

Level 5 = Has comprehensive knowledge. Extensive and comprehensive experience.

Level 4 = Has in-depth knowledge. Can perform without assistance. Repeated and successful experience.

Level 3 = Has applied knowledge. Can perform with assistance. Has performed independently in routine situations.

Level 2 = Limited ability to perform. Has general knowledge only. Very limited experience.

Level 1 = Limited knowledge. No experience.

Level 0 = No knowledge. No experience.

Interested candidates should forward their resume and cover letter to Ashley White (awhite@apqc.org).