*Title: Business Systems Analyst with Erwin and Data Modelling* *Location: Fountain Valley, CA*
*Interview Process: 1 phone, 1 Skype* *Rate: $48/hr C2C* *Top 3:* *Erwin r7* *Data Modeling* *Data Warehouse* *Description:* As a member of the EDW team, the BI/Data Warehouse Business Systems Analyst will perform requirements gathering and system analysis, data analysis, data mapping, logical data modeling, functional design, and data quality improvements. This individual will be working closely with end users, ETL developers, Data Modelers / Architects, Report Developers and Functional teams. •5-7 years of proven hands on experience in the role of a BSA in a Data Warehouse / BI environment •Extensive data modeling experience using ERwin r7 or higher •Extensive experience creating, maintaining, and fine-tuning Oracle database objects using Toad for Oracle 11 or higher •Strong understanding of data warehousing methodology, data mapping and modeling, ETL, databases, and Business Intelligence and their processes •Strong knowledge of SQL, Oracle database, stored procedures and ad-hoc query development •Strong ability to work with star schema designs and extensive knowledge in building and designing logical /physical data modelling •Strong data modeling skills be detail and process oriented •Strong business analysis experience to capture data and reporting requirements and translating to technical specs for the enterprise data warehouse •Extensive experience in data analysis and develop data mapping and functional solution design documents for ETL developers •Performs source data model / data analysis, and target EDW data model / data analysis •Capture business rules and builds physical design document to meet user requirements •Strong expertise to understand and interpret logical design document and data model diagrams to understand requirements to build physical design document •Ability to effectively communicate the functional design to developers and confirm the same with the business teams •Ability to effectively document overall business processes and data/information flow. Suggest and implement process improvement and data collection opportunities. Functional testing of reports and ETL data auditing *Regards,* *Rahman, * *Sr Resource Recruiter* *rahm...@usmsystems.com <rahm...@usmsystems.com>* *703 246 1849* -- You received this message because you are subscribed to the Google Groups "SAP BASIS" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-basis+unsubscr...@googlegroups.com. To post to this group, send email to sap-basis@googlegroups.com. Visit this group at http://groups.google.com/group/sap-basis. For more options, visit https://groups.google.com/d/optout.