Hi,
Hope you are doing well. Kindly have a look below job description, and do let me know your interest in this opportunity. Title: DATA WAREHOUSE/BUSINESS INTELLIGENCE ARCHITECT Location: Boston, MA Duration: 4 months Job Description 1. BASIC PURPOSE: A significant aspect of strong risk management practices mandated by the Fed - is a requirement to have analytical tools in place to be able to view and report on data from many perspectives. We require an experienced DWH/BI architect to install, manage, develop and maintain Data Warehouse (DWH) and Business Intelligence (BI) solutions. This resource will be responsible for the Data Architecture, Data Analysis and ETL Design of the DWH layer. This resource will be working independently of a larger team looking at Operational systems that have not been migrated to the DWH and help create the BI layer on top of the DWH. Also, this resource could build BI models, design, develop and review standard and adhoc reports, dashboards and scorecards against an integrated DWH and diverse disparate Operational data-sets. 2. MAJOR RESPONSIBILITIES: Develop DWH data models and be responsible for the physical and logical database layer. Analyze Operational Data Sources to identify the design of the subject areas of the DWH. Design ETL logic and build ETL mapping specifications for global ETL development team. Support the business with report questions as it relates to functionality and performance. Develop BI metadata and models for standard, adhoc reporting, analysis and risk dashboards. Tune BI models and reports for performance issues. Identify need for indexes and materialized views. Lead the internal review process of reports, adhoc queries built by business users and identify duplicate calculations, filters etc. that can be built in the DWH or into the Cognos model. • Work closely with the Project manager and Development Manager to define project timelines, and to manage requirements. Estimate DWH and BI work. • Work closely with ETL, Data architecture and software quality assurance leads to provide insight on business requirements and user goals. 3. REQUIREMENTS: Education and Experience • Bachelor’s degree; Advanced degree a plus • 4+ years functioning as a DWH Developer/Architect, BI experience a plus • Financial services experience required; Risk and compliance experience a plus • 7+ years Data Warehousing and Information Delivery experience Skills/Knowledge • Proficient in DWH, ETL design and Data Virtualization (Composite, etc.) • Demonstrated ability to solve problems of diverse scope and working in complex environments • Proficient in Data Modeling tools like ERWin or Embarcadero • Familiarity with ETL tools like Data Stage • Proficient with Oracle 10 and 11G RDBMS • Proficient with RUP development methodology and Clearcase and Clearquest tools • Performance tuning experience required • Proficient with Cognos 8 and 10 (Framework Manager, Transformer, Metrics Server, Business Insight, Business Insight Advanced, Analysis Studio, Report Studio, Query Studio, Go Mobile) is a plus • Database security experience required • Requires superior communication skills to communicate with business users and defend Data Warehouse and BI design in large group settings in front of enterprise Architects • Ability to operate independently or as a member of a cross functional team *Let me know if needed any help from my end. You can reach me via Email: je...@gtssminds.com <je...@gtssminds.com>, Ph: (609) 890 0316 *802* -- You received this message because you are subscribed to the Google Groups "SAP Workflow" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-workflow+unsubscr...@googlegroups.com. To post to this group, send email to sap-workflow@googlegroups.com. Visit this group at http://groups.google.com/group/sap-workflow. For more options, visit https://groups.google.com/d/optout.
