Salary: $80,000 - 110,000 per year
Requirements:
- Advanced Microsoft Excel skills
- Proficiency in SSRS report development and data extraction
- Intermediate to advanced Microsoft SQL Server skills, including writing queries and stored procedures
- Understanding of data pipelines and ETL processes, including how data moves between source files, databases, and reporting tools
- Power BI experience preferred
- Ability to analyze and interpret large datasets
- Strong organization, motivation to learn, and problem-solving ability
- Ability to work independently and manage time effectively
- Effective communication with technical and non-technical stakeholders
- Comfort working in a matrixed environment
- Bachelors degree in a related field, such as information technology, business administration, or healthcare management, or another relevant field
- Working knowledge of EDI file structures and experience with EDI mapping tools
- 2–5 years of experience working with healthcare and claims data
- At least 2 years of related experience in data analysis and SSRS report writing
- Health plan experience preferred
Responsibilities:
- Review claims system configuration and analyze pended, manually processed, and auto-released claims to improve accurate auto-adjudication and identify configuration fixes
- Create and maintain data dictionaries that document fields, definitions, and sources
- Develop, maintain, and document internal and external reports using SSRS and Excel
- Develop and maintain the 835 remittance process, including file generation, data mapping, validation, and reconciliation
- Support configuration and maintenance of 837 EDI mapping
- Maintain fee schedule and benefit matrix configuration; use SQL and Excel to prepare data loads, validate rates and benefit rules against source files, and identify discrepancies
- Extract, analyze, and interpret large datasets to identify trends, discrepancies, and outliers, and report findings to leadership
- Investigate and resolve configuration-related claim errors that affect payment integrity, working with relevant teams and leadership
- Help maintain the accuracy and integrity of our data warehouse
- Write complex ad hoc reports in SQL
- Identify process gaps and recommend improvements to efficiency and data quality
- Stay informed about our services, information, documentation, and reporting issues and requirements
- Use technology and automation to develop effective solutions that support organizational goals
Technologies:
- Data Warehouse
- ETL
- Excel
- Support
- Matrix
- Network
- Power BI
- SQL
More:
We are Independent Clinics of Washington (ICW), an alliance of local healthcare providers helping Medicaid and Medicare patients access high-quality, individualized care while supporting independent practices. We assist providers with administrative work, plan rate negotiations, claims processing, authorization requirements, patient advocacy, and connections with a supportive local network. In this full-time Senior Healthcare Business Analyst role in Claims Operations, reporting to the CEO, you will provide analytical and operational support across claims, encounters, eligibility, capitation, and data reporting. We offer an annual salary of $80,000–$110,000, medical, dental, vision, life and disability coverage, a 401(k) with employer match after the first year, paid time off and holidays, tuition reimbursement, professional growth opportunities, flexible scheduling, and a work-from-home equipment allowance. The position is described as home-based and remote, with the listed work location as hybrid remote in Seattle, Washington. We provide a desktop; employees use at least two personal monitors, a microphone, and a camera. The work involves prolonged sitting and computer use, with occasional lifting up to 20 pounds. We aim to foster an inclusive, supportive, collaborative work culture.
last updated 47 week of 2026
You apply on DevITjobs, where this job was posted. Peter Nowak isn’t the employer and doesn’t check listings.
