PRIMARY CARE INFORMATION PROJECT
Senior Business Intelligence Specialist
The NYC Department of Health and Mental Hygiene (DOHMH) Primary Care Information Project
(PCIP) is devoted to improving population health in underserved neighborhoods through health
information technology. PCIP was awarded funding to become the Regional Extension Center
in New York City -- the NYC Regional Electronic Adoption Center for Health (NYC REACH). To find
out more about this ground-breaking project visit us at www.nyc.gov/pcip or www.nycreach.org
In collaboration with The Fund for Public Health in New York (FPHNY), a not for profit corporation
serving as program partner with DOHMH to implement and advance public health initiatives, we
are seeking a Senior Business Intelligence Specialist to oversee the development, maintenance
and implementation of a large multipurpose data warehouse. The data warehouse, also
referred to as the Healthcare Quality Information Network (HQIN), houses information about
primary care practices’ data on delivery of priority preventive services, health care provider use
of electronic health records, aggregate patient characteristics seen by the providers and other
program operational indicators for New York City. The candidate will be responsible for working
with staff of varying levels and identifying innovative and strategic solutions to integrate data
transmissions from electronic health records (EHR) or other health information exchange projects
into key processes at PCIP and NYC REACH. Responsibilities include:
Design and Expand HQIN Data Warehouse
Lead ongoing and new HQIN Data Integration related initiatives by identifying solutions;
provide expert recommendations, and estimating resource needs for implementation.
Evaluate requirements, analyze various data sources and propose technological
Identify and ensure best practices are implemented in maintaining a data warehouse.
Evaluate existing products and tools and provide recommendations.
Lead the setup and migration of the data warehouse in varying environments as needed
(e.g. development, staging, and production environments).
Establish documentation of data warehouse requirements, architecture, and quality
Manage processes that impact the fidelity of the data warehouse by establishing
change management processes, policies and procedures
Oversee the maintenance and support of the existing data warehouse
Evaluate Health IT Security Standards relevant to the data warehouse and implement
best practices solutions
Establish project plans and manage timelines for different aspect of the data warehouse
Manage staff assigned to the HQIN data warehouse projects
Advise and direct staff at varying stages of the data warehouse maintenance process:
requirements gathering, project planning, monitoring progress, review of deliverables,
process management, training end users, and management of changes and upgrades
Represent PCIP in working with data vendors and managing relationships
Negotiate clear scope of work with vendors and implement as appropriate for PCIP
Train other HQIN staff on critical operational procedures related to reporting from the
Participate in agency wide required activities for emergency preparedness. Follow up on
emergency or emergency preparedness as necessary promptly and accurately
Public speaking or meeting with other agencies or external entities regarding the
technical aspects of data warehouse or applications used.
Attend Health IT conference to understand on going improvement in HIE (Health
Candidate will act as the expert user and assist staff with:
Programming, deployment of integration and reporting services SQL Server (2005,2008)
Dunda’s Charts or similar software that is integrated with SQL data for generating
graphics in reports
Integration of SalesForce.com or similar contacts relationship management database
with the HQIN data warehouse
Applying NHIN standards and other quality reporting or health information exchange
requirements for state or federal initiatives to the data warehouse
Implementing InfoPath or similar software that can be used to track requests and easily
accessible for end users making requests
Customizing Microsoft Office SharePoint Server or Similar for document management
and multi-user access to view portions of the HQIN data warehouse
5 Years or more total IT experience in database development and business intelligence.
At least 3 Years (4 or more years preferred) of Project Management Experience in
managing project in Business Integration and Intelligence technology areas such as SQL
At least 3 Years (4 or more years preferred) of experience with solid programming
experience in Microsoft SQL Server (2005,2008) and related technologies like SSRS, SSIS
At least 3 Years (4 or more years preferred) of experience in SharePoint and related
technologies like InfoPath, Web-Part development, ASP.NET and C#.
Minimum of 3 years of experience on SOA (service oriented architecture) using XML web-
Familiarity with electronic medical records (e.g. eClinicalWorks™, NextGen, EPIC) data
Ability to work independently and collaboratively
Detailed oriented and meticulous with documentation
Experience with project management tools
Excellent communication, interpersonal and leadership skills.
FPHNY offers a competitive salary and benefits package.
If you would like to be considered for this opportunity, please submit your resume, with cover
letter including salary requirements, to firstname.lastname@example.org
The Fund for Public Health in New York, Inc. is an Equal Opportunity Employer and
encourages a diverse pool of candidates to apply.