Please respond to *gsi...@ameritconsulting.com <gsi...@ameritconsulting.com>*
*Position: Logical Data Modeler/Data Analyst Location: Tulsa, OK Duration: 6-12 Months+* *JD:* Data modeling expert: works on complex problems where analysis of situations or data requires an in-depth evaluation of factors. Responsible for completion of the logical data model to full attribution within the scope of a specific data project. The incumbent must be knowledgeable in all aspects of designing data warehouses, operational data stores or data marts. This position focuses primarily on data modeling with additional responsibility for business analysis. Responsibilities include documenting data entities and attributes, documenting business access rule, and data volumes and retention, and designing the logical database. Incumbent must be knowledgeable in star schema designs, design key and indexing schemes, and design partitioning and summarization strategies. Position requires proficiency in business analysis, event modeling, data access analysis, archive and recovery strategy, and load strategy design and security. Must be able to design databases with easy end-user access and balance design for optimized data access with resource utilization. Requires three to five years of experience in IT with relational database management systems and at least two years' experience with data modeling tools such as Design/IDEF (Meta Software), Erwin, and Designer 2000 (Oracle). The Modeler/Analyst will provide professional business analysis and analytical skills to assist in the overall Master Data Management (MDM), perform business analysis, define delimitations and Testing. He/She has the responsibility of creating the Requirements & Reporting Specifications for the team while utilizing the application of standard, descriptive, and inferential statistical methods for conducting necessary analysis. This could include participating in converting and mapping of legacy system data to company standards or industry standards. This includes participating in the data integrity initiative and works with end users to follow through with associated action items. The Analyst helps to enforce data integrity, researches and documents data mapping from source to target systems, and works closely with Customers, Project Management, Data Architects, and the ETL Development Team to design and implement the requirements for the Enterprise Data Warehouse. They also will be working closely with business users to verify data requirements and access needs. The candidate should have the following qualifications: • Minimum 5 years of experience gathering business requirements • Minimum 5 years of experience working with Teradata, Oracle, SQL Server Databases, SQL • Be a self-starter that does not require direct supervision • Has a strong fundamental understanding of project management, specifically in the SDLC and Agile methodologies • Expert in Microsoft products that include Outlook, Word, Excel, PowerPoint, Visio • Ability to write PL/SQL scripts to perform data refreshes from one system to another or run data queries • Ability to identify and map source and target data fields • Excellent written and verbal communication skills to enable: Lead meetings with technical peers regarding the requirements definition Communicate effectively with business, vendor, and project management staff Participates in ongoing decisions regarding study design, data collection, data analysis, and Methodology • Ability to work independently or as part of a team • Ability to show up to work and meetings on time • Ability to perform other activities as needed in order to help the team or the project to succeed *Skills Required: Agile Methodology * and 4 Yrs. Oracle * and 5 Yrs. PL/SQL * and 5 Yrs. SQL * and 5 Yrs. Teradata * and 5 Yrs.* *Gurjant (Gary) Singh* Technical Recruiter Amerit Consulting, Inc. t 925.297.5994 | f 1.925.406.0505 gsi...@ameritconsulting.com | www.ameritconsulting.com *BUSINESS ON A HUMAN SCALE* *A Member Company of **Evergent Group* <http://www.evergentgroup.com/> -- You received this message because you are subscribed to the Google Groups "oraapps" group. To unsubscribe from this group and stop receiving emails from it, send an email to oraapps+unsubscr...@googlegroups.com. To post to this group, send email to oraapps@googlegroups.com. Visit this group at http://groups.google.com/group/oraapps. For more options, visit https://groups.google.com/d/optout.
