PSG Global Solutions is hiring a Database Architect

The Worker shall work on the IQ enterprise data warehouse and team as part of the Administrative Systems Modernization Program 2.0 and related initiatives. Work with IQ's ETL (extract/transform/load), BI (business intelligence), and DBA (data base administrator) teams to develop models and reporting structures to support current and projected reporting and data requirements. The Worker will work collaboratively with the IQ team to create, manage, and modify logical and physical data models using a variety of data modeling philosophies and techniques including Bill Inmon and/or Ralph Kimball. The Worker will work closely with database administrator(s) to establish and maintain highly resilient, scalable and high performance architecture when the data model is implemented physically on the target databases. The Worker will identify and analyze data discrepancies and data quality issues and work to ensure data consistency and integrity. The Worker will take an organization-wide view of the business and its data, (e.g. maintain re-usable or enterprise data models) while providing detailed project-specific modeling and analysis support. Perform performance monitoring and query tuning as needed. Thoroughly document developed solutions and communicate knowledge to team to ensure continuity and maintainability.