Senior Data Analyst

Senior Data Analyst

Federal Home Loan Bank of Pittsburgh (Pittsburgh, PA) to be rspnsble for trnsltng data reqs into applcts tht emply apprprte data mdls & ETL sltns; anlyzng, definng, dvlpng, & maintnng cmplx databse strctrs & ETL archtctrs & applctns; dvlpng & implmntng data validtn, auditng, recnciltn, tstng mthdlgys, & intgrtn prcsses; wrkng w/ DBA Team & Oprtns to estblsh ETL job wrkflw w/ reliable error/excptn handlng & rllbck frmwrk; hlpng set & make req chnges to stndrds & cmplies w/ Bank & data gvrnnce policies, prcdres, & regltns; wrkng w/ IT groups to implmnt disstr rcvry & biz continnce sltns for ETL prcesses; makng rcmmndtns on buy vs build dcsns; mntrng team mmbrs & actng as tchncl resource on data intgrtn & ETL tech; prvdng periodc rprts on actvtys, accmplshmnts, issues & their sltns, & assistng in forcasts of futre utlztn, tools, & resource reqs; & ensrng cmplnce w/ policies, prcdres & regs to ensre safe & sound biz oprtns. Master in CompSci, Info Systms, or rel field w/1 yr prev wrk exp in pos off or rel. Mst knw (thru acdmc trnng or wrk exp) trnsfrm data from source to targt files in Source Anlyzr, Warehouse Dsgnr & Mappng Dsgnr in Infrmtica Dsgnr; perfrmnce tuning of ETL & othr prcesses to optmze session perfrmnce; data mdlng & data intgrtn; & Infrmtica Wrkflw Mngr & Tableau. Cvr lettr & resume w/ salary reqs & refrnces to HR Dept, FHLBank Pittsburgh, 601 Grant Street, Pittsburgh, PA 15219.