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.
- Experience with data modeling (conceptual, logical and physical data model design) and metadata management. Experience designing tables and views for efficiency, flexibility, maintainability and performance.
- Experience with ERwin, Embarcadero, or comparable data modeling tools.
- Experience working with relational databases (RDBMS) such as Oracle, SQL Server etc.
- Experience architecting large scale data systems with increasing scope and responsibility.
- Experience with reporting/analysis tools such as IBM Cognos, Business Objects, Microstrategy, Tableau, etc.
- Professional working experience modeling data requirements based on complex business needs across multiple information domains.
- Experience in skilled writing and maintaining complex SQL and PL/SQL scripts.
- Verbal and written communication skills.
- Analytical and problem solving skills with ability to clearly articulate solution alternatives.
- Attention to detail, seasoned judgement and experience to anticipate business needs.
- Ability to embrace change, adapt to the unexpected, and focus energies, people, and solutions on practical and positive results.
- Equivalent combination of relevant education and experience may be substituted as appropriate.
All your information will be kept confidential.
Danielle Louise Garan
346-231-7544
Job details are sourced from the employer's original posting.
Open job postingAbout the company
PSG is the world’s largest and fastest growing provider of outsourced recruiting support. PSG has clients across the globe, including four of the world’s ten largest staffing companies, 20% of the Staffing Industry Analysts Top 50 and multiple Fortune 500 corporations. With decades of experience in both staffing and the broader outsourced services sector, our services are easy to implement, cost effective, and drive real bottom line results. We have close to 1,200 people at our recruiting centers in the Philippines, the preferred offshore location for supporting the US and global English speaking countries. We built our company from the ground up to take advantage of an offshore delivery model closely aligned with onshore client management. With this approach, our goal is to deliver onshore performance while significantly lowering costs with offshore frontline resources. Many of our customers have had poor experiences with offshore support prior to working with us. With these customers in particular, we are thrilled when they become a case study and talk about their success in our marketing materials and with their colleagues. We partner with every customer using a consultative approach to establish a value delivery framework to ensure we are improving their profitability with every PSG resource assigned to their team.