Data Architect Level 4 -SP00003670

Data Architect IPS Service Quality Management10 month Contract in Richmond, VARequired Technical Skills, Education, and Certifications:-At least three years of logical data modeling experience.-One year of experience developing physical/deployment models and the use of ERWin for data modeling.-Technical undergraduate degree or concentration in a technical field.-A mastery of Transact SQL, T-SQL Stored Procedures, and a working knowledge of PL-SQL.-A mastery of MS-Access and Visual Basic for the creation of rapid prototypes with at least three years of relevant experience.-Rapid application prototyping using MS-Access, Visual Basic, and the .NET Framework.-Demonstrated relationship management skills.-Knowledge of the Microsoft Office Suite including Word, Excel, PowerPoint, Visio, and Outlook.Desired Technical Skills, Education, or Certifications:-Professional certification, formal academic training, or at least three years of significant professional experience in business systems analysis, financial auditing, or IT auditing.-MBA, MS in Math, Engineering, or Accountancy-Certification as a Microsoft MCDBA, Application Developer MCSD/MCAD, or Oracle Application DBA.-Working knowledge of Abinitio and/or Informatica.-Working knowledge or BRIO, MicroStrategy, COGNOS, or other OLAP tools.-Working knowledge of data mining practices and statistical inferenceApplication of Technical Skills:This modeler will (primarily) support the IT Analysis and Metrics team by modeling the data from several financial applications. Instantiating these models, developing the transformation and load jobs, and developing processes to ensure data quality will be the next steps.The modeler will create any user interfaces needed to create or maintain dimension tables, system driver tables, or others as needed.The modeler will use MS-Access 2003 to prototype and create custom GUIs in an Agile project environment.The modeler will meet with management to provide project statuses and offer opportunities for project performance enhancement.Day-to-Day Tasks:1. Using ERWin or MS-SQL-Server Utilities, model data for storage in an analytical data mart2. Using MS-SQL-Server, create entities, attributes, and relationships to persist data.3. Using MS-SQL-Server Tools, create load jobs, T-SQL code, and other tasks to ensure database performance and quality.4. Work directly with customers to prototype SQL-Server GUIs to instances modeled and created.5. Interface with support staff to promote data model changes to production.6. Document the data model and the lineage of the data.Most Technically Challenging Task:-Creation of a (relatively flat) data store sourced from a highly normalized, object oriented instance.-Ensuring that reporting off of the data mart is as easy as possible will be challenging.-Assisting with rapidly changing user requirements in the GUI design will be challenging.-Developing a high level vision of the project and the post-implementation world will be difficult.Evaluation Matrix:Skill WeightSQL-Server/T-SQL/DTS 30MS-Access VBA and Visual Basic 30Data Modeling - Physical / Logical 25BRIO/MicroStrategy/COGNOS/OLAP 10DTS/Abinitio/Informatica/Generic ETL 5Please send your resume and salary requirements to Ashley Barker, Placement Manager, at abarker@comsys.com . Apply Now Location: RICHMONDStatus: Full Time, Temporary/Contract/ProjectJob Category: IT/Software DevelopmentCareer Level: Experienced (Non-Manager) About COMSYS COMSYS IT Partners, Inc. (NASDAQ: CITP) is a leading information technology services company with 44 offices across the U.S. and offices in Canada and the U.K. Leveraging more than 30 years of experience, COMSYS service offerings include contingent staff aug-mentation, permanent recruiting and placement, vendor management and project solutions, including network design and management, customized software development and maintenance, software globalization/localization translation services and implementation and upgrade services for SAS, business intelligence and various ERP packages. For more information, visit www.comsys.com.COMSYS is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, disability, military status, national origin or any other characteristic protected under federal, state, or applicable local law. View all COMSYS opportunities Learn more about COMSYS at www.comsys.com