ON-SITE: BI Datawarehouse Consultant w/ PL/SQL, SQL - HBITS-04-12651

25 Mar 2024

Vacancy expired!

Job Title: BI Data warehouse Consultant w/ PL/SQL, SQL - HBITS-04-12651

Location: Albany, NY

Duration: Long-term(30)

Job Description:
  • Bachelor’s Degree in Information Technology or Computer Science.
  • 42 months of experience with developing reports specializing on Eligibility/Enrollment/Coverage data generated through NYS health exchange for Medicaid, CHP, and Essential Plan programs; NOT claims
  • 42 months of experience with NYS health exchange, or other State- based or Federal health exchange, with specific focus on eligibility determination rules and NYS Affordable Care Act (federal) rules , NOT claims data.
  • 42 months of experience in developing reports used for resolving data discrepancies between the NYS health exchange and other NYS state-based systems, including eMedNY, WMS, KIDS, and OTDA.
  • 42 months of experience designing and developing complex analytic/reporting systems for NYS Affordable Care Act (ACA), or other Statebased or Federal health exchanges
  • 84 months of experience with enterprise strategic BI DW Assessment that includes data interrogation/data profiling by writing complex PL/SQl procedures and SQL queries, and based on the assessment outcome, preparing Enterprise BI DW roadmap.
  • 84 months of experience with various reporting and data transformation tools by providing support to business community with various data requests and issue analysis

Agency: New York State Department of Health

Project: New York State of Health

Detailed Job Description: New York State of Health (NYSOH) is New York's official health plan marketplace established by Executive Order No. 42. Development and design of the marketplace is funded with federal Exchange establishment grant funds. The temporary personnel services requested are needed to support the on-going design and development of information technology systems consistent with enrollment goals and federal and state law and rules. The Software Architect will work closely with NYSOH program staff, vendors and other stakeholders to define requirements for the NYSOH and in Operations and Maintenance of the system. The Software Architect will apply a wide range of specialized knowledge, skills, tools, and techniques to elicit, analyze, communicate, and validate requirements for the NYSOH and to troubleshoot production issues.

Max: SEVEN 32.800.2838

Kevin:- SEVEN 32.800.2373

  • ID: #49539352
  • State: New York Albany 12201 Albany USA
  • City: Albany
  • Salary: Up to $82
  • Job type: Contract
  • Showed: 2023-03-25
  • Deadline: 2023-05-22
  • Category: Et cetera