A new Job, ID: 237237 <http://www.ejobsville.com/display-job/237237> was added at eJobsVille.com - For the Best Tech Jobs in Town <http://www.ejobsville.com/>
Title: Database BI/Reporting Analyst for Wells Fargo in Menomonee Falls, WI. posted on 2014-09-04 14:05:28 Job Description: *Database BI/Reporting Analyst for Wells Fargo in Menomonee Falls, WI. * *Evaluate current state Business Reporting Team (BRT) reporting processes.* *Document process and dimension overlaps, identify improvement/consolidation areas and implement new processes.Functional requirements for new and changing processesCreate and document standard workflow processes, procedures, column and dimension lineage and column mapping to tablesIdentify, document and help build solutions for common processing and inefficiencies within the BRTIdentify common dimensions used in Marketing and Sales analysis processesIdentify areas to eliminate and/or minimize tools used within BRT (SAS, PL/SQL, Cognos, Access, etc.)Identify, document and help build solutions (SQL coding) for common processing, inefficiencies and new processes within the BRT, ARD and RD activity code o Retail Intermediary cube build code o Integrity reporting and processes to feed errors back to proper groupsChannel report codeTerritory management codeCode to combine flows, AUM and activityEliminate unnecessary columns and standardize namingIdentify common dimensions used in Marketing and Sales analysis processes and create standard structuresCreate Cognos 10 reporting solutionsDrill through reporting (cube to cube, cube to report, report to report)Interactive and static scorecards and dashboardsStandard reporting in Report and Analysis studio using relational and OLAP sourcesCube tuning Review all dimensions in cube, figure out what is being used, eliminate those columns/dimensions that are not being used from code and cube Eliminate unnecessary columns Dimensionally model source queries for modelsDesired Skills Cognos 10.2 or 10.2.1 o Framework Manager, Transformer, Report Studio (relational, DMR, and DMX), Query Studio, Event Studio, Analysis Studio, Business Insight, Business Insight Advanced o Cognos Workspace, Cognos Workspace Advanced, Cognos Insight, Dynamic CubesSQL, PL/SQL o Ability to create tables and perform complex designsSAS o Base SAS >9, Enterprise Guide, Enterprise Miner* Thanks, Ron *Click here to view full job description and apply <http://www.ejobsville.com/display-job/237237> (Registration not mandatory to apply for this job)* ------------------------------ Best regards, eJobsVille.com - For The Best Tech Jobs In Town -- You received this message because you are subscribed to the Google Groups "MCMS" group. To unsubscribe from this group and stop receiving emails from it, send an email to mcms+unsubscr...@googlegroups.com. To post to this group, send email to mcms@googlegroups.com. Visit this group at http://groups.google.com/group/mcms. For more options, visit https://groups.google.com/d/optout.