Seeking a Data Warehouse Developer (Developer) within their Information Technology department to play a key role in this effort, which will include designing and building an enterprise data warehouse.
Qualifications:
- Bachelor’s degree; MBA or relevant technical degree preferred.
- A strong background in technology, analysis and critically evaluating information gathered from multiple sources.
- Experience decomposing high-level information into details, distinguishing user requests from the underlying true needs, and developing solution ideas from requirements.
- Strong experience writing business requirements documentation (BRDs) and functional requirements documentation (FRDs).
- Proven experience successfully working in a team setting and ability to reconcile conflicts.
- Minimum seven 7-10 years of experience in related professional business/project analyst capacity.
- Excellent oral and written communication skills.
- 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 experience with MS Office 2013/2016 and above as well as design tools and flowcharting tools, e.g. Visio.
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:
- Experience in developing end-to-end Data warehouse ETL routines.
- ETL processes using Dimensional Modeling for ROLAP and MOLAP.
- ETL technical architecture.
- BI load dependency plan, job scheduling and cycle management.
- 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.