Role: Medcaid Sr. Tech Architect- Expert
Client : Government of North Carolina(DHB)
Work Type : Hybrid
Location : Raleigh,NC
Payrate : 62$ Per Hour
Duration : 12 Months
eSystems Inc. is a fast-growing Systems Integrator based in Princeton, New Jersey. We provide strategic IT solutions and services with primary practice areas in Java and Microsoft centric e-Business solutions, ERP solutions, Enterprise Application Integration, Data Warehousing and Business Intelligence solutions.
Our clients include Fortune 500 corporations, government agencies, small and mid-sized local businesses, and non-profit organizations.
As an equal opportunity employer, eSystems complies with all applicable laws, rules and regulations preventing discrimination against job applicants based on: race, ethnicity, religious beliefs, gender, gender identity, age, veteran status, marital status, physical challenges, or any other relevant factor
THE JD and the required skillset are below. Please make sure that the suitable candidate has atleast 90% of the skillset mentioned
Division of Health Benefits (DHB) is seeking an Expert Technical Solution Architect to provide data warehouse and Cognos analytical solution services. The candidate will deliver strategic insight to DHB management by leveraging predictive data analysis techniques, sophisticated technology tools, and information management principles to help our stakeholders make well-informed decisions. The candidate is expected to work without assistance; provide consultative team leadership and coaching to business intelligence staff to elevate overall analytical capabilities; able to manage highly complex work efforts; may have advanced education; must have extensive industry experience. The candidate will report to Analytics Manager.
Description (including, but not limited to):
1.Technical expertise centered around Cognos metadata modeling using data modules/Framework Manager, fact & dimensional modeling, data mining, SAS, SQL, and quality control.
2.Lead full development lifecycle within Cognos reporting solution deployment.
3.Design, Develop and develop efficient Cognos framework manager sustainable packages and Cognos data modules according to best practices.
4. Specialization in solution architecture for healthcare data management to propose dashboards and operational reporting that improves executive decision making and provides analytical capabilities for the staff analytical reporting, including design and implementation of solutions.
5. Successful development and maintenance of formal strategies, sourcing guidance, technical standards, blueprints, reference architectures, architecture patterns and technology roadmaps for a given architecture domain.
6. Analyzing and estimating feasibility and compatibility of Cognos solutions with a normalized, denormalized and/or fact & dimensional Data Warehouse including hardware, network and other programs. Guide decision makers toward the final solution architecture which is most compliant with their policies and programs.
7. Development of data workflows, processes, and standard operating procedures that pertain to analytics delivery as appropriate; ensure the practical alignment of analytical solutions to workflows and processes.
8.Increase reporting efficiencies/accuracy rates through quantitative and qualitative analytical techniques.
9.Prepare and present analytical data initiatives and deliverables to various audiences including executive management; participate in the dissemination of analytical results through written and oral presentations.
10. Engaging agency subject matter experts, business liaisons, and vendor representatives as to ensure proper alignment between business and IT.
| Required / Desired | Amount(Years) |
Expert knowledge of SAS tools, SAS MACROS, Enterprise Guide, Design Studio. | Required | 7 |
Expert Cognos and SQL experience including table joins to extract data in a normalized data warehouse. | Required | 7 |
Expert ability to effectively diagnose, isolate, and resolve complex problems pertaining to data and its infrastructure. | Required | 7 |
Expert ability to manage client data requests and/or issues; experienced with discerning requirements for analysis, hands-on design, and development. | Required | 7 |
Desirable to have experience working with Medicaid claims data and information. | Highly desired | |
Demonstrated experience with Cognos framework manager, dashboard/report design, and deployment. | Required | 7 |
Excellent communication and organizational skills. Able to effectively work with broad spectrum of constituents. | Highly desired | |
Expertise in Cognos report performance tuning processing terabytes of data | Required | |
Demonstrated experience in design & development of advanced drill down reports and dashboards using Cognos Analytics | Required | |
Demonstrated experience in architecting efficient Cognos metadata models using Cognos framework manager and Data modules | Required | |
Desirable to have experience working with Medicaid claims data and information. | Highly desired | |