Data Warehouse Developer

Jo b Su mm ry: The Developer must have extensive experience in software analysis, design, development, implementation and maintenance of Data Warehouse/Data Marts. T h e Developer w ill w o rk cl o s ely wi t h proje c t m a n a g ers, I T s t af f , p r o g ram s t aff a n d o t h er s t akeh o l d e rs t o defi n e n d d e v e l o p r eq u ire m ents f o r the enterprise data warehouse . The Developer w ill pp ly ra ng e o f specia l i z ed s kills n d t o o ls t o c o m p le t e the f o ll o wing specific d u ties n d r e sponsi b iliti e s: The Developer will u se t h eir e x t en si v e kn o w l ed g e o f b u si n ess n alysis b est pract i ces to facilit a te r eq u ire m ents s ess i o n s and c o m m un ica t e c l early and e f f ec t i v ely w ith en d - u sers, a pp licati o n s d e v e l o p er s , s en i o r b u si n ess m a n a g e r s a n d o t h er t e a m m e m b ers. T h e Developer w ill be c c o un tab l e f o r p r ov i d i n g c oo r d i n at i o n t o e n su r e the ap p r o p ri a te c o ll e cti o n o f da t a; d o c u m entat i o n o f in f o r m at i o n ; and p res e n tat i o n o f fi nd i ng s. T h e Developer w ill p r ov i d e do cu m entat i o n and fl o w -ch a rts o f t h e o r g a n i z ati o n 's w o rkflow, as w e ll as ad- h o c qu e ry su p p o rt n d r e p o rt c r ea t i o n . The Developer m u st h v e s t r o n g t ech n ical k n o wled g e n d u nd ers t a nd i n g o f I T s y st e m s n d ap p licati o n s as w ell as t h e a b ility t o pl a n and t r ack b u si n ess n al y ses cti v i ties as part o f p r o je c t. The Developer lso m u st h v e g o o d lis t en in g skills n d i n t e r v i e wing s k ills t o talk with i nd ivid u als and gr o up s abo u t t h eir ne e d s and ask t h e ri gh t qu e s ti o n s t o su r face e ssential r e qu ir e m ents i n f o r m ti o n . The i d eal ca nd i d ate will l s o p o s sess g oo d w riti n g s kills t o ens u re effec t i v e c om m un ica t ion o f i n f o r m ti o n to c u s t o m ers, m ar k e t i ng , m a n a g ers, and t e ch n ical s taff. The Developer will report directly to the CIO, and indirectly to the VP / Application Development Manager, and will play a vital role in helping client fulfil its strategic, analytical and operational reporting requirements. The ideal candidate will demonstrate critical thinking skills when solving problems and making recommendations for new solutions. Responsibilities Include (but not limited to): Extensive experience in architecting and designing solutions at Enterprise scale in Enterprise Data warehouse applications. Experience in developing Data Warehouse/Data Marts using, as examples, OBIEE, OBI APPS, Cognos, Business Objects, SPSS, SSIS, SSRS, Informatica Power Center, OWB and ODI. Experience on design and development of Data Warehouse Architecture for Enterprise Data Warehouse (EDW), Operational data Store (ODS), Operational Data Marts and Data Marts. Experience in defining metadata standards for the enterprise data warehouse. Experience in design and development of: ETL processes using Dimensional Modeling for ROLAP and MOLAP. o ETL technical architecture. o BI load dependency plan, job scheduling and cycle management. Experience in developing end-to-end Data warehouse ETL routines. Experience in using SQL in advanced analytical functions. Experience in writing complex PL/SQL packages stored Procedures, functions, cursors, triggers, views, and materialized views. Experience in creation of enterprise data Warehouse Test plan, Test script creation and Test Script Execution for different test environments such as System, Integration and User Acceptance. Experience developing optimal approach for obtaining data from diverse source system platforms and moving it to the Enterprise Data Warehouse. Experience in Logical and Physical data Models for enterprise data warehouse and applications. Experience developing and configuring Interactive Dashboards with drill-down capabilities, links/images, HTML objects and folders. Proficient in using the time-series functions to support historical time comparison analysis. Experience with Calculated Measures and assigned Aggregation levels based on Dimension Hierarchies. Qualifications: Client h el o r ' s deg r e e; M B o r rele v a n t t ech n ical deg r e e p referred. str o n g b ackg r o un d in technology , n alysis n d cr i tically e v al u ati n g i n f o r m at i o n g athe r e d fr o m m u lti p le s o u r c es. E x p erien c e d eco m p o si n g h i g h -le v el i n f o r m at i o n i n t o d e tails, d isti ngu is h i n g u ser req u e sts fr o m t h e und erlying t r u e n e eds, and d e v e l o p i n g s o l u t i o n ide a s f r o m r e qu ir e m e n t s . Strong experience writing business requirements documentation (BRDs) and functional requirements documentation (FRDs). P r o v en e x p er i ence succe s s f u lly w o rki n g in t e m s e t t i n g and ab i lity t o r ec o n ci l e c o n fl i cts. M i n i m u m seven 7-10 y e a rs of ex p erience in r ela t ed p r o f ess i o n al bu si n es s / p r o j ect n al y st ca p aci t y. Ex c elle n t o ral and w r i t t en c o m m un icat i o n s kills. Experience in the housing and financial sector is preferred and a major plus, especially around accounting, bonds, mortgages, underwriting, loans origination and servicing; in addition to, experience around grants, tax credits, property/buildings asset management and compliance reporting. Excellent e x p er i ence with M S Off i c e 2013/2016 and above as well as design tools and flowcharting tools, e.g. Visio. This j o b descri p t i o n is n o t i n t e nd ed to be all inc lu s i v e, n d em p l o y e e will l so p e r f o rm r ea s o n a b le r e la t ed b u si n ess du ties as a s si gn ed.