Data Warehouse Developer

Data Warehouse Developer 8 years

Experience in the housing and financial sector 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.

Hybrid

Duration: 6 Months

37.5hrs per week.

Start Date: ASAP

Location: 641 Lexington Ave New York NY

New York State Homes and Community Renewal (HCR) fosters the creation and preservation of high quality affordable housing for New Yorkers while working strategically to revitalize neighborhoods and communities throughout the Empire State. HCR is a vibrant innovative agency that integrates and leverages New York States housing and housing finance resources. We have offices in New York City Albany Buffalo and Syracuse and employ a diverse workforce of professionals who are hardworking and committed to serving low and moderate income families. Our mission is far reaching encompassing single and multifamily housing finance home improvement rent control housing subsidies and community development. We partner regularly with a variety of public and private stakeholders.

Achieving this mission requires a wide range of skills and backgrounds in public policy administration real estate architecture finance law and many other areas of expertise. We seek to provide a workplace environment that is productive flexible accountable ethical and caring. Our employees are empowered to make a difference where they live and work. We offer competitive pay and a comprehensive benefits package including paid leave health dental vision retirement and familyfriendly policies.

Job Summary

New York State Homes and Community Renewal is undergoing a major modernization of their business applications and is 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.

The Developer must have extensive experience in software analysis design development implementation and maintenance of Data Warehouse/Data Marts. The Developer will work closely with project managers IT staff program staff and other stakeholders to define and develop requirements for the enterprise data warehouse. The Developer will apply a range of specialized skills and tools to complete the following specific duties and responsibilities:

The Developer will use their extensive knowledge of business analysis best practices to facilitate requirements sessions and communicate clearly and effectively with endusers applications developers senior business managers and other team members. The Developer will be accountable for providing coordination to ensure the appropriate collection of data; documentation of information; and presentation of findings. The Developer will provide documentation and flowcharts of the organizations workflow as well as adhoc query support and report creation.

The Developer must have strong technical knowledge and understanding of IT systems and applications as well as the ability to plan and track business analyses activities as part of a project. The Developer also must have good listening skills and interviewing skills to talk with individuals and groups about their needs and ask the right questions to surface essential requirements information. The ideal candidate will also possess good writing skills to ensure effective communication of information to customers marketing managers and technical staff.

The Developer will report directly to the CIO and indirectly to the VP / Application Development Manager and will play a vital role in helping HCR 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:

o 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 endtoend 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 drilldown capabilities links/images HTML objects and folders.

Proficient in using the timeseries functions to support historical time comparison analysis.

Experience with Calculated Measures and assigned Aggregation levels based on Dimension Hierarchies.

Qualifications:

Bachelors degree; MBA or relevant technical degree preferred.

A strong background in technology analysis and critically evaluating information gathered from multiple sources.

Experience decomposing highlevel 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 710 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.