Senior Data Ware House Developer

Data Warehouse Developer
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:
oETL processes using Dimensional Modeling for ROLAP and MOLAP.
oETL technical architecture.
oBI 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 f
rom 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.
This job description is not intended to be all inclusive and employee will also
perform reasonable related business duties as assigned.
What we offer:
Exciting opportunity to be part of New Yorks resurgence to greatness;
Extensive benefits package including paid leave excellent health dental
vision and retirement benefits;
Promotional opportunity for dedicated professionals.

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:
oETL processes using Dimensional Modeling for ROLAP and MOLAP.
oETL technical architecture.
oBI 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.