Data Engineer
Title: Senior Data Engineer – Ab Initio / SnowflakeDuration: 18-month contractLocation: Fully RemoteRate: Up to $65/hr on W2 (All-inclusive / no benefits)Job Description:Seeking a Senior Data Engineer with extensive experience in designing, developing, and supporting enterprise-scale data integration solutions using Ab Initio and Snowflake. This individual will be responsible for architecting and building high-volume ETL/ELT processes, data pipelines, workflow orchestration, metadata management, cloud modernization, and data warehouse solutions within Azure supporting hundreds of Ab Initio Graphs and processes that are already in place.Required Technical SkillsAb Initio (Senior - Expert Level)6+ years of hands-on Ab Initio developmentStrong experience with:o Graph developmentPlans and Plan executionParameter Sets (PSETS)Continuous FlowsBatch processing frameworksExtensive experience building and supporting:Complex ETL workflowsHigh-volume data integration solutionsReusable frameworks and componentsDevelopment of:DML filesXFR transformationsPDL scriptingo Data quality validation processesExperience with EME (Enterprise Metadata Environment)Experience with:Check-in/check-out processesTag promotionSandbox managementVersion controlAb Initio Metadata Hub / EMEMetadata managementLineage managementImpact analysisDataset mappingSnowflake (Senior Level)· 4+ years of Snowflake development· Snowflake architecture and designPerformance tuning and optimizationQuery optimizationCost optimizationRole-based securitySnowpipeStreams and TasksTime TravelData CloningZero-Copy CloningSQL Development· Advanced SQL developmentComplex joins and subqueriesStored proceduresDynamic SQLQuery tuningData reconciliationData quality validationSchema designDatabase Design / Data WarehousingDimensional modelingStar schema design· Snowflake schema designData vault conceptsData warehouse architectureMaster Data Management conceptsSource-to-target mappingPython & ScriptingPython developmentShell scripting (KSH/Bash)Automation developmentETL utility developmentFile processingData validation automationOperational support scriptingData IntegrationETL / ELT design patternsReal-time and batch processingFile-based integrationsAPI integrationsLarge-scale data movementDevOps & CI/CDCode promotion strategiesBranching methodologiesAutomated deployment pipelinesRelease management processesGit-based development practicesHealthcare Data ExpertiseClaims DataProfessional claimsInstitutional claimsMedical claimsPharmacy claimsEncounter dataAdjudication processesMembership DataMember enrollmentEligibilityCoverage historyProduct and benefit analysisPopulation health analyticsMember attributionProvider DataProvider directoriesProvider contractingProvider attributionProvider networkNPI and provider hierarchy structuresHealth Plan DataBenefit plansProduct structuresGroup and employer data