Application Programming Interface (API), Automation, Data Management, Data Processing, Data Warehousing, Database Extract Transform and Load (ETL), Database Replication, IT Service Management (ITSM), ITIL (IT Infrastructure Library), Informatica, Master Data Management (MDM), Performance Metrics, Process Development, Quality Assurance, Relational Databases (RDBMS), Reporting Dashboards, SAP, SQL (Structured Query Language), Software Development Lifecycle (SDLC), Stewardship, Web Services
Seeking a Full-Time Data Warehouse Architect in New Haven, CT with expertise in data integration, architecture, and analytics.
- Develops ETL processes for data extraction, transformation, and loading using tools like Informatica PowerCenter or SAP Data Services, including job scheduling, automation, real-time replication, and data synchronization across various environments.
- Utilizes APIs, web services, and file transfers for data integration.
- Designs and models enterprise data warehouses, dashboards, and KPI analytics using WebFOCUS.
- Leads data governance efforts, including MDM, reference data management, data stewardship, and quality initiatives.
- Requires strong relational database and SQL skills, experience with the full software development lifecycle, and knowledge of data governance principles.
Bonus for experience with financial products or fraternal organizations, and familiarity with ITIL/ITSM concepts.