Center For Health Information And Analysis Database Test Engineer in Boston, Massachusetts
The mission of the Center for Health Information and Analysis (CHIA) is to be the agency of record for Massachusetts health care information, to responsibly steward sensitive and confidential data, and to objectively report reliable and meaningful information about the quality, affordability, utilization, access, and outcomes of the Massachusetts health care system.
CHIA collects an All-Payer Claims database (APCD) with over 500 data elements from both public and private insurers for all Massachusetts residents and a Case Mix database with data from acute care hospitals. The data is submitted to CHIA on a monthly/quarterly basis and contains claims data discharge/visit data, member eligibility data, provider, product data and other associated files. Updates to these data submissions occur on an annual basis. The Database Test Engineer will run queries on individual data elements and combinations of data elements to measure completeness and accuracy of the submitted data, reporting on the quality of priority data elements before release.
Salary range for this position is $80,000-$90,000
Specifically the Database Test Engineer will:
Create and document test cases, create test files in accordance with submission guides, create and execute queries against APCD data within IT database servers.
Examine, assess, verify and document test results utilizing Excel and SQL (required)
Use CHIA and industry standards specific to each data element to determine completeness and accuracy of edits and consistency of edits between file types
Assess APCD Data Elements percentage error allowances, which must be tested against APCD standard thresholds and payer specific variances on the thresholds
Document issues found in data edits and application for corrective action; Document the extent to which data edits and application fail to meet requirements
Perform troubleshooting of data issues and identify resolutions to both technical and non-technical problems
Provide information and support to Application Developers to assist in corrective action
Comply with CHIA data security requirements and assist in identifying potential data security risks
Identify issues pertaining to submissions or ETL transactions during the creation of the APCD and discuss with DBA?s, assist with remediation strategy, and timeline for correction
SQL Programming expertise (using SQL 2012 or minimally 2008) with experience querying large volumes (terabytes) of data and modeling data quality metrics for health data, preferably medical claims, dental claims, and pharmacy claims data.
Experience writing SQL queries and stored procedures for large volumes of data.
Applicants must have at least four years of full-time, or equivalent part-time, professional experience in application program and database testing.
Experience working with large scale Database Systems like SQL Server, Oracle etc, and ETL Tools like DataStage or SSIS.
Experience working effectively in cloud based test environments such as Azure.
Working knowledge and understanding of HIPAA policies and working with PII and PHI sensitive data.
Commitment to complying with data security requirements and ability to assist in identifying potential data security risks.
Effective at managing competing priorities and can work independently with little or no supervision.
Demonstrated knowledge of SDLC models.
Demonstrated project execution experience in big data cleaning delivering required daily analyses, queries, and reports for internal analysis and system engineers.
Proven ability to provide time-sensitive test results in a deadline driven environment.
Excellent communication skills: verbal, written, and presentation, along with excellent documentation skills.
Bachelor?s degree or higher. Equivalent work experience may be applied to education.
Experience in Health Care or Health Insurance Industry
Knowledge of medical billing and /or adjudication systems
Prior experience with two or more of the following vendor solutions would be considered a plus
- All Payer Claims Systems
Claims Auditing Systems
Provider and Product Quality
As an employee of the Commonwealth of Massachusetts you are offered a great career opportunity influencing a wide-spectrum of services to the diverse populations we serve - but it's more than a paycheck. The State's total compensation package features an outstanding set of employee benefits which you should consider towards your overall compensation, including:
75% state paid medical insurance premium
Reasonable Dental and Vision Plans
Flexible Spending Account and Dependent Care Assistance programs
Low cost basic and optional life insurance
Retirement Savings: State Employees' Pension and a Deferred Compensation 457(b) plan
11 paid holidays per year and competitive Sick, Vacation and Personal Time
Tuition Benefit for employee and spouse at state colleges and universities
Extended Illness program participation
Professional Development and Continuing Education opportunities
Qualified Employer for Public Service Student Loan Forgiveness Program
Bargaining Unit: 06 NAGE, TPL B
At CHIA, we are committed to earning a reputation as a great place to work and build a career. So if you?re excited to be part of a diverse and innovative team responsible for identifying opportunities to improve health care in Massachusetts, come join us! To apply and for more information visit: https://www.chiamass.gov/join-our-team/
CHIA is an Equal Opportunity / Affirmative Action Employer. Females, minorities, veterans, and persons with disabilities are strongly encouraged to apply.
If you have Diversity, Affirmative Action or Equal Employment Opportunity questions or need a Reasonable Accommodation, please contact Diversity Officer / ADA Coordinator: Tonya Bourassa 617-701-8127.
Information submitted by applicants is collected through the JazzHR Platform, your submission of application materials constitutes your express consent for this information to be provided to JazzHR for processing. Please do not include any personally identifiable information with your application materials other than that specifically requested by CHIA. CHIA requests basic information such as name, address, telephone number, and email address. You may also self identify race/ethnicity, gender, disability and/or veteran status if you so choose. However, you should not provide more detailed personal information such as your date of birth or Social Security Number with your application materials.
In compliance with federal laws, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification document form upon hire.