JOB TITLE: Remote SQL Developer with QNXT JOB LOCATION: Remote WAGE RANGE*: $55hr to $60hr
JOB NUMBER: 24-00972 REQUIRED EXPERIENCE: Develop QNXT Claims system stored procedure (SP) claims extensions including creating support tables to process claims outside of cored adjudication. JOB DESCRIPTION Develop QNXT Claims system stored procedure (SP) claims extensions including creating support tables to process claims outside of cored adjudication. Provide core technical expertise to support and manage Microsoft SQL Server in a highly challenging environment. Provide expertise in writing complex queries. Perform SQL performance tuning Design and create tables, views, triggers, partitions, complex stored procedures, functions, indexes and other database objects using SQL/T-SQL Review long running SQL’s in production database and recommend for tuning. Import and export data to and from the database servers. Create and maintain detailed SOPs, configuration documentation, and maintenance plans for the database environment. Understand and translate business needs into data models supporting long-term solutions. Work with the application development team to implement data strategies, build data flows and develop conceptual data models. Create logical and physical data models using best practices to ensure high data quality and reduced redundancy. Evaluate data models and physical databases for variances and discrepancies. What we’re looking for (top 5 only) 5+ years of progressively responsible experience in a directly related area, during which both professional and management capabilities have been clearly demonstrated. Understanding of claims adjudication steps and SQL manipulation of QNXT core tables to process claims. Ability to create complex claims impact analysis reports, write QNXT table update scripts, and contract term, fee schedule, enrollment, etc. audit queries. Extensive expertise in Microsoft SQL Server database, as well as data modeling, both logical and physical. SQL knowledge (query performance tuning, index maintenance, etc.) as well as an understanding of database structure. Recommended Additional Skills/Experience Minimum of Bachelor’s Degree or equivalent experience. Experience with Healthcare EDI standards such as 835s. Knowledge of SSIS and SSRS Experience with job scheduling tools. Experience with a health insurance company, TPA, or claim processor and a thorough understanding on the underlying structure of claims transactions. Equal Opportunity Employer Veterans/Disabled * While an hourly range is posted for this position, an eventual hourly rate is determined by a comprehensive salary analysis which considers multiple factors including but not limited to: job-related knowledge, skills and qualifications, education and experience as compared to others in the organization doing substantially similar work, if applicable, and market and business considerations. Benefits offered include medical, dental and vision benefits; dependent care flexible spending account; 401(k) plan; voluntary life/short term disability/whole life/term life/accident and critical illness coverage; employee assistance program; sick leave in accordance with regulation. Benefits may be subject to generally applicable eligibility, waiting period, contribution, and other requirements and conditions. #Circa
Data Flows data-quality T-SQL SSMS Microsoft SQL Server SQL Server Integration Services (SSIS) database-design data-modeling SQL Server Reporting Services (SSRS) SQL triggers indexing stored-procedures