ETL Developer

  • 16945 Northchase Dr, Houston, TX 77060, USA
  • Full-time

Company Description

HealthHelp - A WNS Company (www.HealthHelp.com), is the leader in the field of healthcare utilization & care management. We have gained this position by actively working to change out-of-date practices with a collaborative, non-denial based approach. Our methodology helps payors achieve a higher return on investment, gives providers education programs that better inform physicians, and ensures quality and safety for the patients needing treatment.

HealthHelp’s innovative approach and strong IT capability in specialty benefits management means that staff will move healthcare forward when provided with evidence-based solutions and second opinions. HealthHelp's staff is comprised of healthcare professionals who make a difference every day. HealthHelp has a desire to fill their company with talented and innovative people who want a career path filled with success and personal growth.

Our specialty benefits management services are broad and include, Cardiology, Oncology, Radiology, Radiation Therapy, Sleep Care, and Musculoskeletal Care. HealthHelp has two locations in Houston, one a corporate office and the second a state-of-the art contact center. HealthHelp is also proud to have another such contact center in Albany, New York.

WNS Global Services Inc. (NYSE: WNS) is a global Business Process Management (BPM) leader. WNS offers business value to 400+global clients by combining operational excellence with deep domain expertise in key industry verticals, including Banking and Financial Services, Consulting and Professional Services, Healthcare, Insurance, Manufacturing, Retail and Consumer Packaged Goods, Shipping and Logistics, Telecommunications, Travel and Utilities. Globally, the group’s over 44,000+ Professionals serve across 60 delivery centers in 16 countries worldwide.

Job Description

Ability to build, test, and maintain ETL architecture and processes using strong modular system design skills
Create, modify, document, and enhance data specifications including identifying and mapping data elements from source systems into the dimensional data warehouse and operational system; Validate that the operational system and data warehouse meets specified requirements
Work with other members of the team and make sure that routine data loads are completed properly without any issues and report weekly load status to supervisor.
Ability to work independently on routine data loads with a minimal amount of supervision.
Analyze and QA data from different sources and ensure that it is properly loaded into our systems
Investigate data quality issues and implement appropriate solutions
Responsible for performance tuning of database functions, SQL queries, stored procedures and SSIS packages to ensure scalability demands are satisfied and will be responsible for monitoring the production jobs, and other database activities (Backups, recovery, etc),
Ability to manage individual priorities and tasks and coordinates with other team members and supervisor to meet such timelines and actively contributes to project status reporting processes to identify and mitigate risks.
Go-Live and Production Support - Need to work after business hours as needed basis., will be monitoring the production jobs & processes and will fix any issues and work with peers and supervisor and track the issues in in-house task system
Requirement gathering – frequent interaction with the Data & Database Systems Managers, Technical Managers, Data Architect, Database administrators, Application Users – all belonging to different departments and divisions of to ensure smooth implementation and running of the application
Knowledge of health system functions, terminology and standard coding systems preferred.
Please note this job description is not designed to cover or contain a comprehensive list of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice.

Qualifications

Experience with relational database systems in an operational environment and particularly with Microsoft SQL Server 2008 or later.
Strong experience in extraction, transformation, and load processes from multiple source format files and systems into operational systems into the data warehouse.
Experience in multi-server data management and database administration functions
Excellent work ethic, organizational, analytical, planning, problem solving, and communication skills are must
Must be authorized to work in the United States on a full-time basis for any employer
Bachelor's degree in computer science engineering, mathematics, statistics, science, information technology, Business Administration required Or Master Degree in computer science, computer application or Business Administration preferred
Minimum 6 + years of extensive experience in Data Migration, Data Load & Management, SQL Server Integration Services (SSIS) and other equivalent ETL tools and ETL design and development & T-SQL programming using SQL Server 2016/2014/2012/2008.

Additional Information

All your information will be kept confidential according to EEO guidelines.