Technical Functional Analyst [17252] at ATR Arena Technical Resources

Job Title: Technical Functional Analyst
Location: Remote
Eligibility: US Citizenship or Green Card/Permanent Resident required.
Must be able to obtain a CDC NACI clearance.

Job Description:

Our client is seeking a Technical Functional Analyst to join their CDC
team, playing a crucial role in supporting the Public Health Information
Network Vocabulary Access and Distribution System (PHIN VADS) and PHIN
DIR project. In this role, you will work with the CDC customers to
provide frontend and backend support for the proprietary application(s),
and SSMS support across several databases and environments for multiple
projects.

How a Technical Functional Analyst will make an impact:

- Create/Update Queries, Scripts, and SPs.
- Solid understanding of all Operations and Maintenance activities.
- Troubleshooting with team members daily and resolving/supporting their activities.
- Resolving any data discrepancy issues for the projects with minimum supervision.
- Mid-tier level relationships between tables without having complete documentation
- Supporting large Excel file manipulations to sanitize content and file structures.
- Create and update SOP as required
- Create/Update Standard Operating Procedures (SOPs) that describe in detail how each project work is performed.
- Deploy vocabulary content supporting proprietary application (UAF) for the PHIN VADS system
- Manage internal/external customer requests via mailboxes to keep track of work and follow SOPs
- A well-organized, goal-oriented, highly motivated, effective team member.
- Ability for critical thinking and analysis, good interpersonal and communication skills, and teamwork.
- Submit weekly status reports to the management on activities completed.

WHAT YOU’LL NEED TO SUCCEED:

- Bachelor’s degree in computer science or higher
- Must have 2 + Years of experience of T-SQL
- Must have 2 + Years of experience in SSMS, Import Export Data, and Bulk Insert
- Experience using MS Office products.
- Experience supporting web-based applications
- Preferred experience supporting ticketing systems like ServiceNow.

Security Clearance: Must be able to obtain a CDC NACI clearance

Required Skills and Abilities:

- Intermediate knowledge of writing complex queries in Transact-SQL, such as DML.
- Ability to provide support and collaborate with stakeholders to review business, technical, and data requirements and ensure data accuracy and quality
- Must be able to communicate with stakeholders and team effectively

Preferred Skills:

- Experience with MS SSMS
- Experience with the ServiceNow ticketing system or equivalent

Arena Technical Resources, LLC, (ATR) is an Equal Opportunity Employer
(EOE) who will provide equal employment opportunity to employees and
applicants for employment without regard to race, ethnicity, religion,
color, sex, pregnancy, national origin, age, veteran status, ancestry,
sexual orientation, gender identity or expression, marital status,
family structure, genetic information, or mental or physical disability.