Data Analyst 2 - 276

New York State Department of Health; City of Albany (NY); On-site; USD 85,000 - 105,000; Full time

Benefits offered by this job

Public Service Loan Forgiveness (PSLF)

Pension from NYS Employees’ Retirement

Holiday & Paid Time Off

Shift & Geographic pay differentials

Affordable Health Care options

Family dental and vision benefits

Job summary

The New York State Department of Health seeks a Data Analyst 2 to support NYSOH’s Reporting and Data Analytics Director in meeting evolving requirements from the Legislature, Governor’s office, and CMS. You will analyze data, generate reports, oversee vendor activities, and ensure alignment with department planning.

Responsibilities include building BI solutions, examining data sources, and communicating results effectively; experience with Tableau, R, Cognos, and SQL is preferred.

Qualifications

• Seven years of experience in data visualization, statistics, and data mining tools.
• Associate or bachelor’s degree substitutions described may apply; master’s or PhD can substitute for experience.

Responsibilities

• Produce BI solutions by querying data repositories and generating periodic reports.
• Identify data patterns and trends across data sources to inform decisions.
• Assess data structures to support requested reports and outcomes.
• Research new data sources and analytical tools; recommend solutions.
• Coordinate tests to ensure BI solutions meet defined needs.
• Test and refine models to accurately predict outcomes of interest.
• Create data flow diagrams representing business needs.

Skills

Data analysis

SQL

Tableau

R

Cognos

Data visualization

Data quality

Education

Bachelor's degree in data-related field

Tools

Tableau

Cognos

SQL

Job description

Duties Description

The Data Analyst 2 will have responsibility to assist the New York State of Health’s (NYSOH’s) Reporting and Data Analytics Director (Data Analyst 3) in meeting continually evolving system requirements from the New York State Legislature and Governor’s office, the Federal Government and the Center for Medicare and Medicaid Services.

Duties Description

The Data Analyst 2 will have responsibility to assist the New York State of Health’s (NYSOH’s) Reporting and Data Analytics Director (Data Analyst 3) in meeting continually evolving system requirements from the New York State Legislature and Governor’s office, the Federal Government and the Center for Medicare and Medicaid Services. Responsibilities will focus on data analytics including collecting, analyzing and reporting and vendor oversight and reporting. Participation and oversight include solution platform design review, internal and external interface specification review, consulting regularly with contractor staff, and working closely with vendor solution and technical teams to ensure alignment with Department planning and support. Additionally, the incumbent will assist NYSOH management as directed including with regular audits reviews from various oversight entities, including CMS, OSC, MA IG and will assist in the completion of required quarterly and annual submissions to these oversight entities. Experience with data analytics and data quality is required, including data modeling and reporting.

Specific Duties Include

• Producing business intelligence solutions by querying data repositories and generating periodic reports.
• Devising methods for identifying data patterns and trends in data sources.
• Assessing data structures and how they can be used to produce desired reports to help drive outcome-based results.
• Researching new data sources and analytical tools and recommends solutions.
• Conducting or coordinating tests to ensure that business intelligence solutions are consistent with defined needs.
• Testing, validating, and reformulating models to ensure accurate prediction of outcomes of interest.
• Following industry standards, creating data flow and other diagrams which accurately represent the needs of the business.
• Drafting new functions or applications in programming languages to conduct analyses.
• Creating written reports and effectively communicates/presents results.
• Working with data visualization tools like Tableau, using querying languages R, Cognos, sequel as well as others.
• Working with project staff to transition solutions into an operational model.
• Supervising staff.

Qualifications

Minimum Qualifications

Non-competitive: seven years of experience* in data visualization, and statistical models and data mining tools.

• Substitution: An associate’s degree may substitute for two years of general experience; or a bachelor’s degree may substitute for four years of general experience. A master’s degree in data or computer science, informatics, economics, statistics, mathematics, or a related field, may substitute for one year of general experience; or a Ph.D. in these fields may substitute for two years of general experience.

Preferred Qualifications

Demonstrated experience in data mining, data visualization and statistical models;
Demonstrated experience in data analysis and management (e.g., database design, database optimization, transformation and load activities, query design and optimization, and experience with large-scale multi tier/multi environment databases);
Demonstrated experience in a Medicaid or health insurance related information technology program;
Experience with Tableau and;
Demonstrated strong analytical, organizational, reporting and communication abilities.

Additional Comments

The NYSOH System is key component of New York’s Medicaid Enterprise system portfolio and provides critical support for eligibility and enrollment policy and operations for Medicaid, Child Health Plus (CHP), the Essential Plan (EP), and Qualified Health Plans (QHPs), as well as tax credits for QHPs. NYSOH is a highly-complex integrated system that assists consumers in real time determination of eligibility for coverage across multiple health care plans, serving the Modified Adjusted Gross Income (MAGI) eligible Medicaid population, CHP, and EP, as well as individuals seeking subsidized or non-subsidized coverage through QHPs. The system annually supports 250,000 webpage views, sends 20 million notices, and processes over 6 million eligibility determinations as it facilitates enrolling individuals into coverage, along with exchanging data with numerous internal and external parties, including the IRS, CMS, and the State’s core Medicaid Management Information System (MMIS).

When reviewing qualifications, omissions and vagueness cannot be interpreted in the candidate’s favor. Candidates are responsible for providing accurate and clear descriptions of their experience demonstrating how they meet the minimum qualifications.

We offer a work-life balance and a generous benefits package, worth 65% of salary, including:

• Holiday & Paid Time Off
• Public Service Loan Forgiveness (PSLF)
• Pension from New York State Employees’ Retirement System
• Shift & Geographic pay differentials
• Affordable Health Care options
• Family dental and vision benefits at no additional cost
• NYS Deferred Compensation plan
• Access to NY 529 and NY ABLE College Savings Programs, and U.S. Savings Bonds
• And many more...

The NYS Department of Health is committed to making New York a safer, healthier, and more equitable place to live. Understanding health equity, social determinants of health and health disparities is critical to accomplish our goal of eliminating health disparities. For more information on the NYS Department of Health’s Mission, Vision, Values and Strategic Plan, please visit: https://health.ny.gov/commissioner/index.htm

If you require reasonable accommodation to complete a job application, a job interview or to otherwise participate in the hiring process, please contact by phone [phone] or email [e-mail] to make a request.

NYS Department of Health does not participate in E-Verify and does not sponsor visa applications.

For new State employees appointed to graded positions, the annual salary is the hiring rate (beginning of the Salary Range) of the position. Promotion salaries are calculated by the NYS Office of the State Comptroller in accordance with NYS Civil Service Law, OSC Payroll rules and regulations and negotiated union contracts.