Data Engineer Dev

Job responsibilities

Build and Maintain Data Integrations Using SSIS
Design, develop, and deploy ETL processes to enable data ingestion of eligibility, medical, pharmacy claims, and other partner data.
Configure SSIS workflows for outbound data feeds and file-based data exchanges.
Implement and maintain error-handling mechanisms in SSIS to ensure robust and reliable processes.
Develop and Optimize Database Processes Using T-SQL
Write and optimize T-SQL queries and stored procedures to support integration pipelines.
Develop scripts to ensure efficient data processing and transformations.
Add error-handling and logging to database processes to ensure data integrity and process transparency.
Troubleshoot Errors and Monitor Integration Processes
Diagnose and resolve errors in SSIS workflows, T-SQL queries, and overall integration pipelines.
Develop tools or procedures to monitor and alert for integration issues proactively.
Analyze integration anomalies and apply root-cause analysis to ensure long-term reliability.
Collaborate with Analysts and Business Stakeholders
Partner with Data Analysts and Business Partners to gather and validate integration requirements.
Ensure integration processes align with business needs and data quality standards