ETL Designer (Healthcare)
Cross Lanes, WV, US, 25313-1497
Full Time USD 61K - 88K
Gainwell Technologies
Gainwell empowers you through innovative technologies and solutions to deliver better health and human services outcomes.Be part of a team that unleashes the power of leading-edge technologies to help improve the health and well-being of those most vulnerable in our country and communities. Working at Gainwell carries its rewards. You’ll have an incredible opportunity to grow your career in a company that values work flexibility, learning, and career development. You’ll add to your technical credentials and certifications while enjoying a generous, flexible vacation policy and educational assistance. We also have comprehensive leadership and technical development academies to help build your skills and capabilities.
Summary
- As a ETL Designer at Gainwell, you can contribute your skills as we harness the power of technology to help our clients improve the health and well-being of the members they serve — a community’s most vulnerable. Connect your passion with purpose, teaming with people who thrive on finding innovative solutions to some of healthcare’s biggest challenges. Here are the details on this position.
- The candidate is expected to be able to develop program specifications and mapping documents. Perform analysis on data to understand transformation requirements, work with ETL/Reporting/Conversion staff to ensure code has been developed that meet the business requirements documented, test the interface/report to ensure requirements are met and work with other team members.
Your role in our mission
Design your career for growth, new possibilities and refining your valuable skills:
- Knowledge of NCPDP Version D.0 for pharmacy.
- Creates accurate mapping documents according to the mapping process.
- Works toward delivering a first draft solution to ETL/Reporting for coding, by rapidly understanding which details about the mapping can be deferred.
- Supports DSD creation and response.
- Presents analysis and design recommendations to customer and/or vendors into the acceptance of the design.
- Supports the ETL/Reporting/Conversion developers based on the mappings created.
- Works closely with configuration team and DBAs to ensure synchronicity of configuration to interfaces and mappings.
- Uses SQL, data models, data element dictionary and schema to perform data and business analysis.
- Creates unit test cases for area of responsibility.
- Validates test plan results that satisfy the detailed design goals.
- Updates technical specifications and mappings.
- Supports Unit Testing, System Integration Testing, System Testing, and User Acceptance Testing.
- Analytical and data analysis skills within a technical real time environment preferably SQL.
- Healthcare knowledge within a claims processing environment preferably in a real time pharmacy point of sale environment.
What we're looking for
- QNXT(a proven core administration platform for claims) / Schema Experience.
- Data Mapping experience
- Healthcare/business knowledge in member, eligibility, TPL, claims processing, provider, real time POS pharmacy claims.
- Good Oral/Written/interpersonal customer relation skills.
- Good/Excellent SQL skills.
- Conversion/Interface/Reporting Experience.
What you should expect in this role
-
All USA locations will be considered including remote.
- Fast-paced, challenging and rewarding work environment.
- On call support after hours.
The Deadline to submit applications for this posting is May 3rd.
#LI-DN1
#LI-REmote
The pay range for this position is $61,700.00 - $88,200.00 per year, however, the base pay offered may vary depending 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.
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 committed to a diverse, equitable, and inclusive workplace. We are proud to be an Equal Opportunity Employer, where all qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical condition), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics. We celebrate diversity and are dedicated to creating an inclusive environment for all employees.
Tags: Data analysis ETL SQL Testing
Perks/benefits: 401(k) matching Career development Flex hours Flex vacation Health care
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Data Science Manager jobs
- Open Lead Data Analyst jobs
- Open Marketing Data Analyst jobs
- Open Data Engineer II jobs
- Open Senior Business Intelligence Analyst jobs
- Open MLOps Engineer jobs
- Open Principal Data Engineer jobs
- Open Power BI Developer jobs
- Open Data Scientist II jobs
- Open Data Analytics Engineer jobs
- Open Business Intelligence Developer jobs
- Open Junior Data Scientist jobs
- Open Business Data Analyst jobs
- Open Sr Data Engineer jobs
- Open Data Analyst Intern jobs
- Open Product Data Analyst jobs
- Open Sr. Data Scientist jobs
- Open Senior Data Architect jobs
- Open Research Scientist jobs
- Open Big Data Engineer jobs
- Open Data Quality Analyst jobs
- Open Azure Data Engineer jobs
- Open Principal Data Scientist jobs
- Open Manager, Data Engineering jobs
- Open Junior Data Engineer jobs
- Open Data quality-related jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Business Intelligence-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open Deep Learning-related jobs
- Open PhD-related jobs
- Open Data visualization-related jobs
- Open Finance-related jobs
- Open PyTorch-related jobs
- Open NLP-related jobs
- Open TensorFlow-related jobs
- Open APIs-related jobs
- Open Consulting-related jobs
- Open LLMs-related jobs
- Open CI/CD-related jobs
- Open Generative AI-related jobs
- Open Snowflake-related jobs
- Open Kubernetes-related jobs
- Open Hadoop-related jobs
- Open Data governance-related jobs
- Open Airflow-related jobs
- Open Databricks-related jobs