Data Analyst​/Trainee

Description

The Data Analyst 1 will produce analytics engineering solutions in the Data Engineering Unit in the Center for Health Data Innovation. The Data Engineering Unit is responsible for developing and operating large scale, enterprise data solutions and application that helps to guide policy and decision‑making in healthcare and public health. The Data Engineering unit is a highly collaborative team that requires effective communication and problem‑solving skills, as well as strong technical skills.

Work with Product Manager’s and Senior Data Engineers to conduct technical requirements gathering and project scoping sessions with subject matter experts and stakeholders to discover and define data needs.

Work with analysts to design and test data pipelines, focused on dbt modeling and data transformations.

Work with Senior Data Engineers to build automations and ELT solutions.

Achieve standards in data reliability, data integrity and data governance, enabling accurate, consistent, and trustworthy data sets, business intelligence products, and analyses.

Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, and re‑designing infrastructure for greater scalability.

Minimum Qualifications

Four years of experience
* in data visualization, and statistical models and data mining tools and satisfactory completion of a two‑year traineeship; OR six 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:

• Strong skills in SQL, including joins, aggregations, and window functions.
• A basic understanding of data warehouse concepts and modeling techniques.
• Basic to intermediate proficiency in Python scripting and automation.
• Familiarity with version control systems (Git).
• Familiarity with dbt and jinja.
• Quick learner with ability to swiftly grasp new methods and technologies.
• Proven ability to work both independently on projects and as part of a larger team.
• Possess strong analytical thinking and critical reasoning skills with an aptitude for problem‑solving.

Technical skills needed for this role:
Intermediate SQL, Beginner Python, Beginner Git, and familiarity writing code in an IDE.

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 (Use the "Apply for this Job" box below)..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 518‑486‑1812 or email doh.sm.reasonable.accommodation.gov 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.