ETL Developer - 246187

ETL Developer Contract-to-Hire Remote About the Role We are seeking a seasoned ETL Developer to join our Data Integration team. This critical role involves designing, developing, and maintaining high-volume data exchange solutions, with a strong emphasis on healthcare data standards (EDI) and ensuring regulatory compliance. The developer will work across the full data lifecycle, from requirements gathering and ETL design to performance optimization and Master Data Management (MDM) support. Key Responsibilities Data Integration and Pipeline Development • Design and implement scalable ETL workflows using industry tools such as Microsoft SSIS and Informatica to extract, transform, and load data from various sources. • Develop and maintain complex data exchange maps and workflows with external partners, ensuring data quality and integrity. • Manage data transfer protocols, including flat file integrations and secure communications like FTP/SFTP. • Monitor, troubleshoot, and optimize ETL job performance, reliability, and error-handling processes to ensure high system uptime. Healthcare EDI and Compliance • Work extensively with ANSI X12 and HIPAA-compliant transaction sets including 834 (Eligibility), 837 (Claims), 835 (Remittance), 270/271 (Inquiry/Response), and 276/277 (Status). • Apply knowledge of NCPDP pharmacy standards to collaborate on claims and formulary workflows. • Ensure all data exchange and integration processes maintain strict compliance with HIPAA, CMS, and security best practices, including data encryption. Database and Data Governance • Utilize advanced SQL scripting for data manipulation, transformation, and performance tuning within relational databases (SQL Server preferred). • Contribute to Master Data Management (MDM) initiatives, including defining processes, policies, and monitoring MDM services for data consistency. • Partner with business teams (e.g., Claims, Enrollment, Billing) to gather detailed data requirements and translate them into technical specifications. • Provide technical guidance and mentorship to junior team members and document data integration processes thoroughly. Required Qualifications • Bachelor’s degree in Computer Science, Information Technology, or equivalent experience. • 5+ years of professional experience in systems integrations and/or ETL development. • 3+ years of hands-on experience in healthcare EDI development. • Expertise with major ETL platforms, specifically Informatica and/or Microsoft SSIS. • 5+ years of relational database experience and strong command of SQL. • Proficiency in scripting languages (e.g., XML, XSLT, SQL) and using mapping tools. • Strong analytical, problem-solving, and communication skills to troubleshoot complex integrations and data anomalies. Preferred Qualifications • Experience with advanced integration topics such as Web APIs, data streams, or cloud integrations. • Familiarity with data warehouse concepts and Business Intelligence (BI) tools (e.g., Power BI). • Experience with data modeling methodologies. • Prior experience in the Pharmacy Benefit Management (PBM) industry