|Reference #||18-01273||Title||Analytic Consultant|
|Start Date / End Date||10-07-2018 --- 30-11--0001|
The Analytic Consultant will be responsible for design, application, and interpretation of comprehensive analysis. Serve as a team leader and an analytic member of project teams to deliver quality products and services. Essential Responsibilities: " Organize the project team, work with project team to define production steps, define testing plans, and prepare a work schedule; track and communicate status to manager. " Provide on-site and/or telephone support (e.g., client inquiries, requests for ad hoc reporting assistance, miscellaneous research, advice on analytic methods) and training to client end users. " Clarify scope and design issues, communicate status and results, develop appropriate deliverable documentation, ensure that training is provided. " Define problems and recommend appropriate solutions considering the project budget, the sophistication of the user and the intended use of project results. " Operate independently with clients. " Design an analytic project with an accurate estimate of effort in a project plan. Examples of responsibilities: " Perform risk analysis. " Evaluate the effectiveness of a disease management program. " Demonstrate ability to use analytic findings to make appropriate recommendations to clients. " Prepare and present effective, polished presentations to clients.
Required Technical and Professional Expertise: " 3 years of Healthcare/Medicaid industry and/or quantitative work experience. " Medicaid experience required " Demonstrated ability to convey complex ideas in an easily understood manner to guide audience through written or verbal communications. " Outstanding project management skills. " Strong Excel skills preferred. " Experience in applying health analysis methods and measures utilizing basic statistical methods. " Demonstrated ability to understand industry issues and problems, relate them to clients' needs, and propose appropriate solutions. Additional Technical Requirements Directly from Client: " Environment consists of multiple tools - the team requires individuals who are well versed in multiple areas OR are an EXPERT in one area (Tableau, Cognos, Toad, SAS) " Individual needs to be client facing, project oriented, and experienced in medicaid " From a technical perspective they need to know how to connect with the analytic data warehouse and how to populate the data for the end customer (HCPF) Tableau: " Familiar with Tableau Desktop professional " Experienced building dashboards and workbooks based on analytic data provided in data warehouse " Medicaid data experience is important as they are taking data and building dashboards using Tableau Desktop and publishing a work book " Need to know how Tableau Desktop works with Tableau Server to get data in front of client " Need to know how to build visualizations specifically around Medicaid " Knowledge of Oracle databases/data warehouses and being able to connect Tableau to a database to pull data from there directly (file based data and database based schema) SAS: " Various tools - analytics for healthcare which is server based " SAS Enterprise Guide " SAS Enterprise Miner miner
" SAS Forecast Studio " SAS Data Integration Studio (provides forecast and predictive analytics) Other: " There will need to be be some interpretation of requirements into how they will build out the vision using their tools " Toad, Oracle, SQL, Cognos, Tableau, SAS are all important to have but they can take a mixture of some in each consultatnt " Tableua, SQL, Cognos, SAS all important - providing tools to state but don't have the expertise to back it up yet. Medicaid background will be very important mostly for the Cognos
Additional Information: is replacing its Medicaid Management Information System (MMIS). This will redefine systems and business processes for the Colorado Medicaid program. The overall goal is to replace the legacy MMIS and Fiscal Agent services with a service delivery model that is both flexible and adaptable, with Business Intelligence and Analytics tools that will provide easy access to data and comprehensive reporting. Under this five-year base contract with build a first-of-its-kind, state, enterprise-wide data warehouse that will collect, consolidate, and organize data from multiple sources, and fully integrate Medicaid eligibility and claims data, for reporting and business process analysis. These services will support specific objectives including implementing a modern approach to data management. By integrating the vast collection of disparate data sources from across the state into a single data warehouse, the new system will support the Colorado Medical Assistance and related programs.
Work Environment: " " Very new and upscale work space " May need to meet with local client or vendors off-site at their facility
Interview Information: In-person interview with Account Executive (Angie) and other key team members. If not local, a phone or video conference may be acceptable.
Who is the Internal/External Customer: External: State of Colorado's Department of Health Care Policy and Financing
Impact to the
Internal/External Customer: External: The successful execution of the BIDM program will make the MMIS program extremely more effective in its ability to serve the citizens of CO through the use of Business Intelligence. This individual will be directly contributing to how that data is presented and utilized.
Business Challenge: IBM Watson Health is preparing to ramp up their team in order to deliver on the architectural requirements they have been developing with the client. They need to rapidly build this team up in order to begin delivering and meet their deadlines.
EVP: " IBM is leveraging the CO BIDM program as the flagship BI program for Medicaid. They plan to continue winning other states in the country based off their performance here - very high profile. " The contract period will be used as an evaluation period where they plan to retain the best team members. A successful contract can turn into a long term opportunity with IBM. From the company: At IBM, work is more than a job - it's a calling: To build. To design. To code. To consult. To think along with clients and sell. To make markets. To invent. To collaborate. Not just to do something better, but to attempt things you've never thought possible. To lead in this new era of technology and solve some of the world's most challenging problems. IBM is a leading cloud platform and cognitive solutions company. Restlessly reinventing since 1911, we are the largest technology and consulting employer in the world, with more than 380,000 employees serving clients in 170 countries. With Watson, the AI platform for business, powered by data, we are building industry-based solutions to real-world problems. For more than seven decades, IBM Research has defined the future of information technology with more than 3,000 researchers in 12 labs located across six continents.
Non-Technical Skills: " Demonstrated ability to convey complex ideas in an easily understood manner to guide audience through written or verbal communications. " Outstanding project management skills. " Strong Excel skills preferred.
" Experience in applying health analysis methods and measures utilizing basic statistical methods. " Demonstrated ability to understand industry issues and problems, relate them to clients' needs, and propose appropriate solutions.