US-CA-Hayward: Database Analyst To apply for this position, please visit this Website. http://dba.fyicenter.com/jobs/99899030_Database_Analyst.html To see other opportunities, please visit http://dba.fyicenter.com/ Date: 13-Feb-2009
Database Analyst Description The Data Analyst will be responsible for gathering and translating business requirements into queries, models and tools to allow for insightful data analysis and forecasting back to the business. The Data Analyst works with business users to develop and interpret reports in the proper context, create complex data queries, reconcile data from sources with varying degrees of accuracy and granularity, develop ad-hoc queries to augment/pilot new reports, perform data cleansing and auditing to identify idiosyncrasies and compensate for deficiencies, create data extract transformation and load processes. Data Analyst uses deployed business intelligence capabilities to help business users analyze data and create customized reports and analytics. · Develop a strong working relationship with the appropriate business users to understand the key business drivers and priorities · Lead and facilitate sessions with cross-functional teams to reach consensus on data definitions. Develop data models to cleanse, interpret and reconcile information from various sources · Develop data models to distill actionable information by excluding noise in the data. · Develop detailed functional specifications and requirements for new reports. · Audit and measure data quality and take actions to reconcile. · Create ad-hoc queries to augment existing reports using SQL and other tools e.g. Excel · Perform ad-hoc data cleansing, match, merge & debug operations. · Create and maintain documentation · Provide analytical support and create reports for the Cognos BI / MS SSRS user community · Educate user community on data mining techniques, tools, and best practices · Ensure quality delivery of BI reports and operational enhancements · Perform QA on new reports against underlying data for accuracy. · Perform end user training on reports and reporting environment · Maintains data integrity and standards · Use audit techniques to obtain, analyze and appraise data, transactions, and records as a basis for providing an objective opinion on the performance of the business and the effectiveness of key management activities · Design and execute tasks to cleanse data to support various initiatives Requirements Strong hands-on technical experience with MS SQLServer, TSQL, and VB.net Extensive experience with data extraction, and validation, experience with transactional systems Reporting and business intelligence experience Experience in medium to large scale reporting environments so to understand the unique challenges in scale Experience with Banking, Financial Services, Retail and Commercial Lending data Experience with ITI Premier Prime data warehouse is highly desirable. 6+ years of experience as an IT data analyst 4+ years exp in the field of Business Intelligence 4+ years of exp in the field of data mining and analytics Must be skilled in SQL design/ development, strong in MS SQL Server, Excel Experience with IBM Cognos Bachelors of Science degree in Computer Science, Information Systems, Electrical Engineering or related field Thank you, DBA FYI Center http://dba.fyicenter.com/ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "oracleguru" 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/oracleguru -~----------~----~----~----~------~----~------~--~---
