Data Quality Analyst - Experian Health - Strong SQL writing ability required, 100% REMOTE
Job description
At Experian Health, our employees have the opportunity to shape more than products – they shape the future of U.S. healthcare. Experian Health is a pioneer for innovations leading the way in revenue cycle management, identity management, patient engagement, and care management for hospitals, physician groups, labs, pharmacies and other risk-bearing entities. Our success relies on people who are given the freedom to imagine new frontiers in the rapidly changing healthcare space and push the boundaries of innovation. Help us realize our vision of applying data for good and changing the healthcare landscape for the better – for all of us.
Our mission is to use data driven insights to simplify healthcare for all. Simply put, we want to make the healthcare system work better for us as consumers and for those who work in healthcare. Our ONE Experian Health culture is the centerpiece of making this happen. Our aspiration is to bring people together who are driven by purpose and want to make a difference. We strive to have a diverse group of people and minds who are:
- OPEN: Have a growth mindset and collaborate often with others to make things happen
- NIMBLE: Always embracing change and pushing the envelope on innovative ways to solve problems
- EFFECTIVE: Accountable to themselves and to others
The primary responsibility of the Data Analyst will be to support application development leveraging strong SQL skills, knowledge of relational databases, and the skills to ensure custom coordination of benefit software, containing over 400 million rows of data, only allows accurate data to be loaded, and data integrity is maintained after bug fixes and enhancements.
This position will ensure this software is thoroughly tested from all angles focusing primarily on the backend by developing custom test plans and executing them using SQL, analyzing production data, and writing custom reports.
Job duties:
- Fully understand custom built Healthcare Medical Eligibility/Coordination of Benefits software solution. Understand the technical design and be able to traverse through and fully test the system using custom developed test plans using SQL
- Work collaboratively at ground level with senior level development staff to fully understand product requirements. Be willing to ask questions, push back as necessary, and ultimately ensure the new code meets stringent customer expectations
- Identify software defects, conduct research, develop plan for resolution, and engage appropriate internal resources as necessary
- Perform data analysis as needed on production data (400+ million rows of data)
- Collaborate with team members on, and provide peer review of, test plans, test cases, test data, and automation/tool enhancements.
- Work collaboratively with development team to make technical judgments based upon understanding of the business process and customer/user needs whereby a design change or modification should (or needs to be) changed.
- Support inquiries from client, operations, and customer support on content related questions and monitor areas for improvement.
- Design and document test cases to ensure optimal system performance with new code releases
- Utilize QA best practices
- Tests will be executed at the database level, using SQL
- Build automated tests using tools such as Selenium
- Operate load testing on Web Based Portal
- Run smoke tests and regression tests
- Prepare appropriate test data
- Communicate and document testing results in appropriate tool
- Maintain defect reporting and tracking
- Maintain current test plans, test cases, test scripts, and test data.
- Availability for planned after hours deployments and unplanned issue resolution
- Planned deployments typically occur once a month on Thursday nights
- Bachelor’s degree in Information Systems, Computer Science, or other related field OR equivalent experience required
- At least 3 years combined prior business analyst, SQL programming, software QA, SQL data analysis
- Minimum 3 years of SQL usage in a professional setting
- Experience working as an analyst with large datasets (1+ million records) highly desired
- Experience with SDLC and iterative development processes, specifically Agile work processes highly desired
- Experience in working in a highly competitive team environment
- Strong SQL skills required (Data Analyst SQL skill set, not necessarily SQL programming)
- Focus on relational databases
- Business analyst knowledge is highly preferred
- QA knowledge is preferred. Willingness to be trained on QA fundamentals is required
- Coordination of Benefits, and/or Healthcare Revenue Cycle knowledge a plus
- Effective communication and relationship building skills
- Self-motivated, team player, but who can work independently
- Ability to adapt to an Agile/Scrum environment
- Strong written and verbal communication skills
- Problem-solving as part of a distributed team
- Time management and organizational skills
- Knowledge of the HIPAA transaction sets and requirements is desirable
- Become an expert on highly complex custom software - willingness to self-study and learn through trial and error required.
Additional Information
Experian is an Equal Opportunity Employer. Anyone needing accommodation to complete the interview process should notify the talent acquisition partner. The word "Experian" is a registered trademark in the EU and other countries and is owned by Experian Ltd. and/or its associated companies.
EOE including Disability/Veterans.
Our compensation reflects the cost of labor across several U.S. geographic markets. The base pay range for this position is listed above. Within this range, individual pay is determined by work location and additional factors such as job-related skills, experience and education. This position is also eligible for a variable pay opportunity and a comprehensive benefits package which includes health, life and disability insurance, generous paid time off including paid parental and family care leave, an employee stock purchase plan and a 401(k) plan with a company match.
Experian is proud to be an Equal Opportunity and Affirmative Action employer. Our goal is to create a thriving, inclusive and diverse team where people love their work and love working together. We believe that diversity, equity and inclusion is essential to our purpose of creating a better tomorrow. We value the uniqueness of every individual and want you to bring your whole, authentic self to work. For us, this is The Power of YOU and and it reflects what we believe. See our DEI work in action!
Experian Careers - Creating a better tomorrow together
Find out what its like to work for Experian by clicking here
abouteureka.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, abouteureka.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, abouteureka.com is the ideal place to find your next job.