*Position: Sr. Data Modeler/Data ArchitectLocation: Austin, TXDuration: 6+ Months* *Description:* This solicitation is for a Senior Data Modeler for Information Quest (IQ), the enterprise data warehouse team for Client, under the auspices of the Administrative Systems Modernization Program 2.0 (“ASMP 2.0”). ASMP 2.0 is a program comprised of several projects aimed at modernizing Client’s administrative systems, business processes, data management, and technical architecture. A key part of ASMP 2.0 is the Enterprise Resource Planning (“ERP”) implementation of the Workday HCM/Payroll and Financials modules. 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. Organizationally, the Worker will be part of the Information Quest team. Terms and Conditions: Worker must pass a background check. *Required Technical Skills:* - 8 years of 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. - 8 years of Experience with Erwin, Embarcadero, or comparable data modeling tools. - 8 years of Experience working with relational databases (RDBMS) such as Oracle, SQL Server etc. - 5 years of Experience architecting large scale data systems with increasing scope and responsibility. - 3 years of Experience with reporting/analysis tools such as IBM Cognos, Business Objects, Microstrategy, Tableau, etc. - 3 years of Professional working experience modeling data requirements based on complex business needs across multiple information domains. - 3 years of Experience in skilled writing and maintaining complex SQL and PL/SQL scripts. - Strong Verbal and written communication skills. - Strong Analytical and problem solving skills with ability to clearly articulate solution alternatives. - Strong Attention to detail, seasoned judgement and experience to anticipate business needs. - Strong Ability to embrace change, adapt to the unexpected, and focus energies, people, and solutions on practical and positive results. - Degree Equivalent combination of relevant education and experience may be substituted as appropriate. *Preference:* - 5 years of Experience architecting large scale data systems with increasing scope and responsibility and working with enterprise data warehouse projects. - 5 years of Experience with data modeling in an Oracle environment. - 5 years of Experience with business intelligence tools (data modeling and reporting/analysis tools) such as IBM Cognos, Business Objects, Microstrategy, Tableau etc. - 5 years of Experience with resolving data anomalies and conducting data integration analysis. - 5 years of Experience working with human resource, payroll and financial data. - 3 years of Experience with data profiling techniques and tools. - 3 years of Experience working in higher education. - 3 years of Experience with ETL tools; especially IBM InfoSphere Information Server version 8.7 and higher. -- You received this message because you are subscribed to the Google Groups "Companies Looking for IT Out Staffing & Recruitment" group. To unsubscribe from this group and stop receiving emails from it, send an email to arunsinh+unsubscr...@googlegroups.com. To post to this group, send email to arunsinh@googlegroups.com. Visit this group at https://groups.google.com/group/arunsinh. For more options, visit https://groups.google.com/d/optout.
