Data Analyst
$40K-$73K (Glassdoor est.)
The Data Analyst is primarily responsible for the operational execution of data extracts and exchanges with DentaQuest's clients and vendors. This includes loading and processing data files, various operational data maintenance functions, and systemic delivery of files to third parties.

PRIMARY JOB RESPONSIBILITIES:

• Perform routine and ad hoc encounters and claim resubmissions.
o Use SQL tools to resubmit encounters for clients such as NY, FL, and other markets
o Work with BAs and developers to streamline/automate processes

• Run, edit and maintain data extracts, applications, and ad-hoc queries as requested by internal and external customers using SQL, SSIS, Informatica toolset (Powercenter, B2B with MFT)
o Analyze discrepancies with invoice detail files, provider files, etc.
o Re-run TWS or manual jobs to ensure data delivery and compliance
o Run, test, deploy, or retire TWS jobs as needed
o Ensure scheduled and ad hoc extracts are delivered per schedule
o Ensure scheduled EDI and flat files are received per schedule
o Onboard inbound and outbound client data to automated file transfer solution
o Track inbound/outbound files, errors, and discrepancies; identify and report trends.

• Analyze data and extract requests and help define technical specifications for efficient development.
o Requests include custom flat files and a significant focus on healthcare encounters and HIPAA X12 transactions: 837, 999, 277, 835
o Support BAs by reviewing and/or updating data maps, spec docs, etc.
o Write/update run docs and other documentation related to deployed extracts
o Collaborate on the definition, development, and maintenance of standards and processes.

• Facilitate and perform deep-dive data analysis and reconciliation with external clients
o Use SQL tools to develop and automate enrollment reconciliation reporting
o Support enrollment error management
o Develop a thorough understanding of clients within the assigned region
o Identify and coordinate data changes impacting clients and extracts across multiple business units and departments
o Maintain documentation associated with contractual requirements; track operational results to ensure quality metrics are achieved and/or exceeded.

• Demonstrate expertise in a variety of IT concepts, practices, and procedures and maintains general knowledge of company-wide processes and systems (e.g. Windward).
• Successfully manage a high volume of projects and tasks with, often with competing priorities.
• Ensure regulatory and legal compliance (HIPAA) within the department.
• Drive continuous improvement in CDM solutions and processes.
• Support DentaQuests goals and objectives by working closely with the management team to deliver value to the business.
• Serve as a mentoring resource for other team members.
• Other duties as assigned.

JOB REQUIREMENTS:

• BS degree in Business, Computer Science, Engineering, Information Systems or related field (or equivalent experience)
Proficiency in the following technical concepts:
• 2 years of experience in a business role with operational deliverable responsibilities.
• Knowledge of general computer software.
• Expert level proficiency in the use of advanced features of MS Office.
• Relational Database concept knowledge (SQL Server preferred)
• Exposure to ETL, reporting concepts, SQL, or SSIS preferred.
• Experience with SQL queries.
• Good interpersonal skills.
• Excellent verbal and written communication skills.
• Ability to prioritize and organize multiple tasks with high attention to detail.

• Desired knowledge of dental or medical insurance claims processing including:
o Hands-on experience with HIPAA EDI transaction formats including 837, 835, 277, 997, 999, 834
o Familiarity with appropriate handling of PHI data

PHYSICAL DEMANDS:

• Incumbent must be able to communicate effectively.
• Requires overall light physical effort (up to 25lbs.)
• Manual dexterity and sitting are required in carrying out the position's own position responsibilities (i.e. use of a personal computer).
• Ability to travel or move about within and outside serviced facilities required.
• Incumbent works primarily in either a private or shared office environment.
DentaQuest
3.1
DentaQuest
