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
...Certification in Early Childhood Education (BirthGrade 2) required Experience working with young children in a classroom or childcare setting Strong understanding of early childhood development, developmentally appropriate practice, and child-centered learning...
...University of California, Irvine's academic community, the UC Irvine Libraries plays a vital role in enabling our outstanding students,... ...responsible for all functions at the Langson Library Check Out Desk. Assists the Langson Library Stacks Lead. Serves as backup for all...
...Position: Oversees daily Operation processes and activities. Primary Job Duties: Supervises multiple operating units (warehouse / distribution center) with part time and full-time employees. Establishes and maintains performance and productivity standards. Manages...
...accuracy and efficiency, while consistently meeting key department performance metrics. Functional support areas include Brokerage Cash Management products and services, Brokerage Online (client website) and Mobile app, and general account or financial related inquiries....
...Join our growing team as a primary care RN! This Jobot Job is hosted by: Amber Stoneburner Are you a fit? Easy Apply now by clicking... ...us: Join a collaborative, mission-driven team where your nursing skills help shape compassionate, coordinated care in a dynamic clinic...