SQL Server Data Architect
Company Overview: ICONMA is a consulting firm, that provides professional staffing services and project based solutions for a broad range of Fortune 1000 companies. Our areas of expertise include Information Technology, Accounting/Finance, Engineering, and Professional. ICONMA has a nationwide presence that helps us support our national clients. ICONMA has received numerous awards for delivering outstanding services and providing the highest standards of quality. We recently received the Bridge Award and the Silver Supplier Award from two of our major clients. We provide long and short term opportunities as well as contract to hire and direct hire opportunities. ICONMA offers Paid Vacation, Holidays, Personal Days, Medical and Dental, Life Insurance and 401K. We also have an AFLAC insurance program that allows our consultants to further personalize their coverage with a choice of selections that include long and short term disability, additional term life insurance. We are currently looking to hire for one of our clients. Duration: 5-6 months plus Description: - Data Architect – IPS Service Quality Management - This contractor 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. - 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: - Please note that the evaluation matrix is provided to convey the relative importance of the criteria. - Additional criteria may be added or criteria may be deleted as needed to effectively and uniformly assess the pool of candidates. - Some of the criteria are gating, or minimum criteria, and not all candidates may clear the gates. - Please note that the evaluation matrix is provided to convey the relative importance of the criteria. - Additional criteria may be added or criteria may be deleted as needed to effectively and uniformly assess the pool of candidates. - Some of the criteria are gating, or minimum criteria, and not all candidates may clear the gates. Required Skills: - At least three years of logical data modeling experience, and one year of experience developing physical/deployment models and the use of ERWin for data modeling. - 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 Preferred Skills: - 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 inference - Professional certification, formal academic training, or at least three years of significant professional experience in business systems analysis, financial auditing, or IT auditing Education: - MBA, MS in Math, Engineering, or Accountancy - Technical undergraduate degree or concentration in a technical field Thanks and regards, Algyne Garcia Recruiter ICONMA Ph: (732) 547 6061 Toll Free: (855) 571 3867 Email: agarcia@iconma.com
|
Richmond
|
Expired |
Amy Mayo
Blog & Content Writer
View profile
Rodrigo Flamenco
Software Developer
View profile
Cerise Carson
Virtual Assistant
View profile
Gareth Evans / Sniper Systems Ltd
Software Developer
View profile
Related projects
Search for freelance jobscan’t wait for more clients
and advertising. Thank you."