THIS JOB HAS EXPIRED Job Description:
Apply Deductive Reasoning to translate business data requirements into technical specifications. Create, update and maintain detailed documentation of attributes and metrics using Deductive Reasoning. Analyze complex data from conceptualization through presentation of the data. Responsible for on-going analysis of ServiceSource and industry specific data, obtained from a variety of sources, including CRM, financial, and demographic data. Develop and prepare information products such as Invoices and Bookings for Client Delivery and Sales organizations. Perform complex data analysis in support of ad-hoc and standing customer requests using OLAP, and Advanced T-SQL queries. Support Client Delivery and Sales organizations on Data issues such as short falls in expected amounts using results of statistical analyses, including information in the form of graphs, charts, and tables. Develop an understanding of fields to which statistical and Data Driven methods are to be applied, in order to determine the most efficient course of action for quality control standards of data and its evaluations. Adapt statistical methods such as sampling techniques prior to consulting with clients and agreeing on what data to collect and how it should be retrieved - taking into account any ethical and legislative considerations. Evaluate the statistical methods and procedures used to obtain data to ensure validity, applicability, efficiency, and accuracy. Apply deductive reasoning to develop awareness of and familiarity with issues and events affecting ServiceSource data assets. Work with BI analysts and support team to troubleshoot issues with Microsoft Business Intelligence software. Work with BI report developers to generate optimized code. Function as back-up for Extract Transformation and Load (?ETL?) Developer using proprietary Advanced T-SQL queries, including hand coded SQL stored procedures and development, testing, and troubleshooting of new stored procedures; Interface with MSSQL for technical support. Work with department to define and document system standards and ensure their implementation within the BI platform using Deductive Reasoning, and application software such as Microsoft Excel. Conduct source system data profiling on relational database management system (RDBMS) and SQL Server to ensure integrity of data being brought into the data warehouse. Work on relational database management system (RDBMS) and SQL Server to Analyze and profile source system data in order to validate metadata when it is available and to discover metadata when it is not. Use Microsoft Integration Services and advanced T-SQL to Develop and Maintain SQL SSIS Packages. Verify program logic by conducting unit tests and assessing performance impacts using Microsoft Integration Services and Microsoft Reporting. Design, implement and maintain User Security using Microsoft Integration Services. Develop and maintain new and existing Business Intelligence (BI) reporting and analysis using Business Objects, Microsoft Reporting Services, or Microsoft Integration Services. Participate throughout the project life cycle, from requirements to production implementation, with emphasis on data analysis, development and testing of analytic reports and tools. Use Business Objects, Microsoft Reporting Services, Microsoft Analysis Services, and Microsoft Integration Services to develop and Maintain SQL SSAS OLAP and SSRS Reports. Develop new project objects including Microsoft SQL Server Integration Services (SSIS) packages, creating new attributes and apply deductive reasoning to identify the proper relationships, to create facts and metrics, and to create user-defined reports.
Master?s Degree in Mathematics or related field or foreign equivalent plus two years? experience to include designing, developing, implementing and/or reviewing innovative analytical approaches, statistical methods and procedures, algorithms and predictive modeling techniques for reactive or proactive data analysis, statistical modeling, data mining, sampling, study design, and quality assurance and/or control using computer software, including MS Access, MS Excel, SAS, SQL and/or other applications, for assigned projects; assessing any limitations of the data, in terms of reliability or usability, resolving issues within the existing methodology and proposing work around methodologies to increase analytical efficiency, as needed and assigned by manager; validating and/or reviewing data analysis results; developing and/or reviewing reports to identify potential program or systematic vulnerabilities; researching the fields, policies and other relevant information to ensure that the most appropriate statistical techniques and/or methods are utilized for all projects to ensure the highest quality; estimating sample size requirements and determining sample design and weights; evaluating statistical methods and procedures used to extrapolate results; communicating effectively with management, investigators, other Statisticians, as well as internal and external clients to provide reactive and proactive case development support.
||Nashville, TN |
THIS JOB HAS EXPIRED