Saxon Global
Location: Lexington,NY, USA
Date: 2025-01-15T07:39:31Z
Job Description:
High chance of interview for the candidate having prior state client experience.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.
- 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.
- ETL technical architecture.
- 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.
Apply Now!