Senior ETL Data Analyst
Gainwell Technologies · Illinois, United States
- Hybrid
- Full-time
- $99,200 / year
- Illinois, United States
Tailored resume — keyword-matched to this role.
Hiring manager — we find who's hiring.
Intro email — drafted to reach them directly.
Job highlights
- Analyze healthcare data using SQL and ETL mapping.
- Gather requirements for data transformation initiatives.
- Collaborate with technical teams on data solutions.
- Support testing and validation of data integrity.
- Advance your career in a flexible environment.
About the role
About Gainwell Technologies
Gainwell Technologies is dedicated to harnessing leading-edge technologies to enhance the health and well-being of vulnerable populations. We offer a rewarding career environment with a focus on work flexibility, continuous learning, and professional development. Grow your career with us and gain technical credentials and certifications while enjoying a generous vacation policy and educational assistance. We also provide comprehensive leadership and technical development academies.Job Summary: Senior ETL Data Analyst (Pharmacy/PBM)
As a Senior ETL Data Analyst at Gainwell, you will be instrumental in supporting pharmacy and healthcare data solutions through advanced data analysis, requirements gathering, and ETL mapping design. This role is crucial for translating business needs into technical specifications, ensuring data integrity, and facilitating scalable data transformation processes within Medicaid and PBM environments.Your Role in Our Mission
- Perform requirements gathering and data analysis to support ETL development and healthcare data transformation initiatives.
- Create detailed mapping documents and technical specifications based on business and system requirements.
- Partner with ETL developers, DBAs, and configuration teams to ensure accurate implementation of data solutions.
- Analyze data using SQL and data models to identify transformation logic, trends, and business insights.
- Develop test cases and support testing (unit, integration, system, and UAT) to validate that solutions meet design and business expectations.
What We're Looking For
- 5+ years of healthcare business analysis experience, preferably in Medicaid or PBM environments.
- 3+ years of strong SQL and technical data analysis experience.
- Knowledge of QNXT/schema and healthcare domains including member, eligibility, TPL, claims/encounters (medical & pharmacy), provider, clinical, drug rebate, and financial data.
- Experience with requirements gathering, ETL/data mapping, and interface development.
- Strong communication, analytical, and problem-solving skills with the ability to translate technical concepts into business terms.
What You Should Expect In This Role
- Remote Opportunity within the United States.
- Video cameras must be used during all interviews, as well as during the initial week of orientation.
- This posting is intended for pipelining, and we will accept applications on an ongoing basis.
Compensation and Benefits
The pay range for this position is $69,400.00 - $99,200.00 per year. The base pay offered may vary based on geographic region, internal equity, job-related knowledge, skills, and experience, among other factors. Put your passion to work at Gainwell! You’ll have the opportunity to grow your career in a company that values work flexibility, learning, and career development. All salaried, full-time candidates are eligible for our generous, flexible vacation policy, a 401(k) employer match, comprehensive health benefits, and educational assistance. We also have a variety of leadership and technical development academies to help build your skills and capabilities.Our Commitment to You
We believe nothing is impossible when you bring together people who care deeply about making healthcare work better for everyone. Build your career with Gainwell, an industry leader. You’ll be joining a company where collaboration, innovation, and inclusion fuel our growth. Learn more about Gainwell at our company website and visit our Careers site for all available job role openings. Gainwell Technologies is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical condition), age, sexual orientation, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics. Gainwell Technologies defines “wages” and “wage rates” to include “all forms of pay, including, but not limited to, salary, overtime pay, bonuses, stock, stock options, profit sharing and bonus plans, life insurance, vacation and holiday pay, cleaning or gasoline allowances, hotel accommodations, reimbursement for travel expenses, and benefits.Key skills/competency
- ETL Data Analyst
- Pharmacy Data
- PBM
- SQL
- Data Analysis
- Requirements Gathering
- Healthcare Data
- Medicaid
- Technical Specifications
- Data Transformation
Skills & topics
- Senior ETL Data Analyst
- ETL
- Data Analysis
- SQL
- Pharmacy
- PBM
- Healthcare Data
- Medicaid
- Data Transformation
- Requirements Gathering
- Business Analysis
- Gainwell Technologies
- Remote
- United States
How to get hired
- Tailor your resume: Highlight your 5+ years of healthcare business analysis and 3+ years of SQL/data analysis experience. Emphasize Medicaid or PBM experience.
- Showcase relevant skills: Explicitly mention your proficiency in requirements gathering, ETL/data mapping, and understanding of healthcare domains like member, eligibility, and claims.
- Craft a compelling cover letter: Clearly articulate how your analytical and problem-solving skills translate technical concepts for business stakeholders.
- Prepare for the interview: Be ready to discuss your experience with QNXT/schema and provide examples of successful data transformation projects.
- Utilize video communication: Ensure your camera is functional as it's required for interviews and initial orientation.
Technical preparation
Master advanced SQL querying techniques.,Practice ETL mapping and data transformation.,Familiarize yourself with healthcare data schemas.,Build a portfolio of data analysis projects.
Behavioral questions
Describe a complex data problem you solved.,How do you translate business needs to technical specs?,How do you handle conflicting stakeholder requirements?,Share an experience of collaborating with developers.
Frequently asked questions
- What is the application process for a Senior ETL Data Analyst at Gainwell Technologies?
- The application process for the Senior ETL Data Analyst role at Gainwell Technologies involves submitting your resume and potentially a cover letter. Due to this being a pipelining posting, applications are accepted on an ongoing basis. Be prepared for video interviews, as cameras are required.
- What specific healthcare domains are important for the Senior ETL Data Analyst role at Gainwell?
- For the Senior ETL Data Analyst position at Gainwell Technologies, knowledge of healthcare domains such as member, eligibility, TPL, claims/encounters (medical & pharmacy), provider, clinical, drug rebate, and financial data is highly valued.
- Does Gainwell Technologies offer remote work for the Senior ETL Data Analyst position?
- Yes, the Senior ETL Data Analyst position at Gainwell Technologies is a remote opportunity for candidates located within the United States.
- What are the key technical skills required for the Senior ETL Data Analyst job at Gainwell?
- Key technical skills for the Senior ETL Data Analyst role include strong SQL, technical data analysis, requirements gathering, ETL/data mapping, and interface development. Experience with QNXT/schema is also beneficial.
- What is the expected salary range for a Senior ETL Data Analyst at Gainwell Technologies?
- The expected salary range for the Senior ETL Data Analyst position at Gainwell Technologies is between $69,400.00 and $99,200.00 per year. The final offer may vary based on factors like location, experience, and skills.
- How important is prior experience in Medicaid or PBM environments for this role?
- Experience in Medicaid or PBM environments is highly preferred for the Senior ETL Data Analyst role at Gainwell Technologies, with at least 5 years of healthcare business analysis experience being sought.
- Are there specific benefits offered to full-time salaried employees at Gainwell Technologies?
- Yes, Gainwell Technologies offers full-time salaried employees a generous vacation policy, 401(k) employer match, comprehensive health benefits, and educational assistance, along with leadership and technical development academies.