Must Have skills:
ETL
SSIS
SQL
T-SQL
EDI
Healthcare
Overview: Analyze, design, implement and maintain ETL programs. The Senior ETL Developer reports to the Data Integration Manager and works with Data Integration Manager and the and ETL team in accelerated development and deployment of healthcare ETL, EDI and proprietary interfaces. Working closely with developers, a data architect, analysts, and business users, the Sr. ETL Developer is challenged with implementing robust, reusable development for SSIS and ETL packages with strong emphasis on Healthcare Insurance, SQL Server, Understanding of EDI 834/837 and FHIR concepts.
Principal responsibilities include:
• Create and manage SSIS packages, ETL packages, triggers, stored procedures, views, SQL transactions.
• Develop new secure data feeds with external parties as well as internal applications including the data warehouse and business intelligence applications.
• Performance analysis and QA.
• Lead SQL and SSIS programming initiatives.
• Work to train key IT Staff on advanced SSIS, SQL, XML (x12) and EDI techniques and design patterns.
• Diagnose ETL and database related issues, perform root cause analysis, and recommend corrective actions to management.
• Work with a project team to support the design, development, implementation, monitoring, and maintenance of new ETL programs.
• Complete other related duties and special projects as assigned by IT management.
• Provide support to IT management with developing and implementing a comprehensive ETL & EDI strategy.
Technical Skills: •
Bachelor’s Degree in Computer Science, Professional experience in a healthcare setting
. • Core competency required in TSQL, EDI interfaces, SSIS, Erwin, x12, SQL Server 2008R2 - 2014 ETL development, database administration and analysis.
• Experience in SSIS package versions 2008R2/2012.
• Working knowledge of Visual Basic/.NET programming is required.
• Expert knowledge of and significant experience with x12 EDI transaction sets. • Excellent skills in writing technical design specifications.
• Superior problem solving and troubleshooting capabilities.
• Minimum eight years experience in ETL programming utilizing SSIS packages, DTS, stored procedures, Informatica, Pentaho and SQL scripts.
• Minimum seven years demonstrated professional experience in IT development and support roles with at least 4 years of direct ETL experience.
• At least 3 years of building EDI file sets including data extraction/consumption and data loading from/to EDI file sets.
• Experience working with Healthcare-related EDI files (834, 835, 837, etc.).
• Strong critical thinking and problem solving skills required
...Job Description Opportunity: Sales Representative & Trainer Professional Skincare Territory: British Columbia (with occasional travel to Alberta, approximately 4 times per year) Full-time position Competitive compensation with performance incentives and car...
...Montefiore Medical Center is seeking a Registered Nurse (RN) Manager, ED - Emergency Department for a nursing job in Bronx, New York... ...Experience Requirements: Education: Current Registered Nurse licenseBSN RequiredMasters Degree in Nursing or Health-related field...
Overview Community healthcare is highly rewarding. Come join a dynamic care team at LifeLong Medical Care. We are looking for a Health & Wellness Coach at our TRUST Health Center in downtown Oakland. TRUST Health Centers diverse and unique care team supports health through...
...Unit is a 3 bedroom 2 bathroom (upstairs unit). Department: Property Management & Maintenance Benefits include, but are not limited to:... ...available as needed on a 24-hour basis, and reside at the assigned site while actively fulfilling the role of this position. The...
...Job Description: HVAC Technician A service technician is responsible for installing, maintaining, and repairing heating, ventilation... ...communication and customer service skills. Experience: Entry-level positions may require hands-on training or apprenticeship....