What are the responsibilities and job description for the Data Warehouse Developer position at Mindlance?
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.
Qualifications :
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.
