Client is looking for an *Oracle business intelligence (BI) and data warehouse (DWH) data modeling analyst/developer – Baltimore, Maryland.* This is a *one year* *contract position*. The Hourly rate is DOE.
*General* · Education - BS or MS in computer science or information systems. · Verifiable Training or Certifications in: · OBIEE reports, alerts, dashboard, and metadata design and development · Data modeling ERD and dimensional models for highly conformed data marts · General Work Experience: · Minimum of 2 years developing OBIEE dashboards, analytics, alerts, physical connect strings, business layer model with dimensions and hierarchies, presentation layer development, and role based security. · Minimum of 2 years developing BI Publisher reports. · Minimum of 2 years experience developing OLAP cubes. · Minimum of 2 years experience performing systems business and requirements analysis on data warehouse development projects. · General Industry Experience: K-12 and/or Higher Education industry preferred. · Communication Skills: Fluent in speaking and writing English. · Must have a Minimum of 2 years verifiable experience working with end-uses in defining and preparing system requirements, dashboard user interface design documents. *Professional Technical Skills & Experience* * * · Ability to read ERD and dimensional models and trace data lineage to reports and processes · Understanding of primary, foreign, compound, and surrogate keys and how to structure them · Ability to read and write SQL code · Ability to use TOAD or SQL Developer to access Oracle databases and view tables structures · Knowledgeable, or ability to read, NCES data models with experience in performing gap analysis to identify potential data set modifications and enhancements. · Ability to use ERWIN to create new ERD and dimensional models. · Ability to use MS Word with 4 years experience in preparing functional requirements specifications. · Ability to use ERWIN to create new ERD and dimensional models. · Ability to use MS Word with 4 years experience in preparing functional requirements and detail design specifications for data base designs · Two years experience in defining and developing KPIs, meta data, analytics, reports, alerts, and dashboards using: *OBIEE* * BI Reports* * OLAP* * Oracle SQL Developer or Toad* * SQL* * SAS 10* · Two years experience in defining test case scenarios, and performing manually executed unit testing. Experience using Load runner to test reports and software batch processes desirable. · Two years experience in defining test case scenarios, and performing manually executed unit testing. · Experience using Load runner to perform testing desirable. · Four years experience with AGILE and SDLC development cycles in data warehouse development projects, with experience in defining and recommending development approaches for modification of data sets. · Two years experience with developing and implementing OBIEE dashboards, reports, and alerts in an enterprise production environment servicing 300 end users. 2 years client project experience with ERD and dimensional data modeling · 2 years client project experience using OBIEE with a data warehouse, relational table structures, and OLAP data structures · 2 years client project experience with as a full time OBIEEdeveloper doing; Dashboard development with custom graphics, Analytics design and Answers development, Alerts development, Events scheduling development, Integration with email systems for email alerts, Physical layer setup for federated data sources, Business layer modeling with custom hierarchies and custom dimensions, and presentation layer development · 2 years client project experience with BI Publisher development with parameterized reports · 2 years client project experience with SQL and PL/SQL programming *Duties:* · ·Review and document data structures, report data, and data quality processes of the educational data warehouse · Map and gap/compare the MSDE educational data warehouse data structures to national data models to identify areas for modification or improvement · Prepare Component Impact Summary for the eleven data domains · Participate with the team and document proposed data structure changes based upon a redesign activities · Prepare a design change impact analysis summary for each data domain, for the proposed changes to that domain, for analytics, reports, and data quality routines · Define, prepare, and develop data sets, Oracle data tables, KPIs, metadata, analytics, reports, dashboards, and alerts for educational data from Educational Data Warehouse. · Create test plan cases for each data domain, for the proposed changes to that domain, for analytics, reports, and data quality routines. · Assist in testing change cases, and preparing test results, for each data domain, for the proposed changes to that domain, for analytics, reports, and data quality routines. · Assist in preparing conversion schedules, cut-over procedures, and cut-over component checklists · Assist in preparing conversion schedules, cut-over procedures, and cut-over component checklists. · Implement OBIEE dashboards, reports, and alerts in a production environment that can support 5000 users. *Please complete the following skills-matrix and send back with your updated resume.** * Full Name: Degree Major: Total IT exp: Total Oracle business intelligence (BI) and Total exp with data warehouse (DWH): Total exp with data modeling: Total exp with OBIEE reports, alerts, dashboard, and metadata design and development: Total exp in BI Publisher reports: Total exp in developing OLAP cubes: Total exp in performing systems business and requirements analysis on data warehouse development projects: Total exp with Oracle SQL Developer or Toad: Total exp in ERWIN and ERD: Total exp with SAS 10: Total exp SQL and PL/SQL programming: Hourly Rate: Whether is it C2C/W-2? If C2C, specify the corporate name: Day Phone #: Evening Phone #: Cell Phone #: Availability: Current City/State: Work Status (US Citizen / Green Card / Others): Have you applied recently for this requirement earlier through any one else? Y/N: If you qualify for this position, are available immediately and are interested, please send your resume, rate and contact information to *mailto:[email protected]?subject=oracle business intelligence (BI) and data warehouse (DWH) data modeling analyst/developer – Baltimore, Maryland<[email protected]?subject=oracle%20business%20intelligence%20%28bi%29%20and%20data%20warehouse%20%28dwh%29%20data%20modeling%20analyst/developer%20%E2%80%93%20Baltimore,%20Maryland> *** * ** Please ensure you complete and copy/paste the above-completed matrix with your response Warm Regards, * Vasu * 1057 E. Imperial Highway, Suite 509 | Placentia, CA 92870 Tel: 714-857-2002 Ext:815 | Fax: 714-364-9705 *[email protected]** *| *www.BeyondTekIT.com Alternate E.Mail:[email protected]<e.mail%[email protected]> * www.rafikee.com *| One Stop Shop for Tech Jobs **Rafikee.com is positioning itself to become the number 1 technology job board in the world. Any referrals to colleagues or friends would be much appreciated!* -- You received this message because you are subscribed to the Google Groups "SAP ABAP" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sap-abap?hl=en.
