SQL & Views Specialist - On-Site (West Memphis)

Automatic Data Processing, Inc.; West Memphis (AR); On-site; USD 65,000 - 90,000; Full time

Job summary

Automatic Data Processing, Inc. in West Memphis, AR is seeking a Database Specialist to own internal databases, monitor performance, and coordinate data issues.

You will triage data quality, develop new views, and support data health operations, while collaborating with a Data Analyst and developers in a hybrid on-site role. Strong SQL skills, ability to read view logic, and experience with JIRA are important, along with clear written communication.

Qualifications

• Strong analytical skills with experience identifying and investigating data quality issues.
• High level of knowledge with SQL and database views; ability to read and validate view logic.
• Programming experience sufficient to intuit relations from code to database. Diagnose issues, fix where appropriate, and take part in relevant code reviews.
• Ability to prioritize competing issues and coordinate work across team members.
• Clear written communication, especially for documentation (e.g., glossaries) and handing off technical problems.
• Familiarity with JIRA or similar ticketing and project management tools.
• Comfort working in a hybrid role that balances proactive analysis with reactive support.

Responsibilities

• Database: Maintain scope and ownership over internal databases. Monitor logs, improve performance, vet structure, solve issues.
• Data Health: Own day‑to‑day data health operations, including triaging, prioritizing, and coordinating incoming data issues between yourself and the Data Analyst.
• Proactive data review: Regularly audit datasets to catch discrepancies not covered by existing checks, and recommend process or efficiency improvements.
• Root cause resolution: Investigate the root causes of data issues and either resolve them directly or hand them off to developers with clear, well‑defined problem statements.
• Views ownership and support: Own the organization’s data views and maintain the view glossary as the authoritative reference. Serves as the first point of contact for view‑related tickets and questions.
• Software Tools: Create suggestions, plans, and implementations for modernizing support for internal tools and systems
• New view development: Validate new views before release and coordinate with relevant stakeholders on requirements and rollout.
• Support escalation and JIRA Management: Provide technical support for data‑related issues, and help with general support volume during high‑demand periods. Help manage and participate in triage of JIRA tickets to keep work moving and reduce bottlenecks.

Skills

Analytical skills

SQL

Database views

Code reviews

Prioritization

Written communication

JIRA

Hybrid work

Tools

JIRA

Job description

Automatic Data Processing, Inc. in West Memphis, AR is seeking a Database Specialist to own internal databases, monitor performance, and coordinate data issues.

You will triage data quality, develop new views, and support data health operations, while collaborating with a Data Analyst and developers in a hybrid on-site role. Strong SQL skills, ability to read view logic, and experience with JIRA are important, along with clear written communication.