Dataware house architect @ Haven, CT

• Full-time

Title: Data Warehouse Architect
Location: New Haven, CT
Duration: Full-time

Should possess skills and experience in the following:

• Development of operational processes to perform Extract, Transform, and Load (ETL) of data from source transactional systems to an Enterprise Data Warehouse and Data Marts using Informatica's Power Center or SAP Business Objects Data Services.
• Job scheduling, job dependencies, automation scripting, batch cycles.
• Daily change data capture as well as real-time data replication and synchronization in a Windows, IBM mainframe, or Linux environment.
• Data integration services utilizing APIs, web services, or file transfers of XML, JSON, delimited, or fixed-width files.

• Business intelligence reporting using Information Builders' WebFOCUS.
• Development of dashboards and analytics of key performance indicators (KPIs) and forecasts.
• Data architecture, design, and modeling of an Enterprise Data Warehouse and its associated Business Glossary, Data Dictionary, and Metadata Repository.
• Leadership in data Governance and Data Management, including MDM - Master Data Management, Reference Data Management, Data Stewardship/Ownership, and Data Quality.

A strong understanding of relational databases and SQL proficiency is required. Applicants must be adept in managing all phases of the software development lifecycle. Experience with life Insurance and Annuity financial products, or fraternal membership organizations is a plus, as is a solid working understanding of ITIL or ITSM concepts.