Data analyst

NY HELP No

Agency Children & Family Services, Office of

Title Data Analyst 2

Occupational Category Other Professional Careers

Salary Grade 23

Bargaining Unit PS&T - Professional, Scientific, and Technical (PEF)

Salary Range From $86681 to $109650 Annually

Employment Type Full-Time

Appointment Type Permanent

Jurisdictional Class Non-competitive Class

Travel Percentage 0%

Workweek Mon-Fri

Hours Per Week 37.5

Workday

From 9 AM

To 5 PM

Flextime allowed? No

Mandatory overtime? No

Compressed workweek allowed? No

Telecommuting allowed? Yes

County Rensselaer

Street Address Capital View Office Park - YDAPS

52 Washington Street

City Rensselaer

State NY

Zip Code 12144

Duties Description - Develop in-depth knowledge of agency administrative databases and data warehouse data marts/tables, including all ERD diagrams and refresh schedules in order to be able to provide technical advice, consultation and guidance on data field identification, mapping and use.- Employ systems knowledge to create and manage analytical datasets capable of serving agency needs related to multi-level analytical approaches, including admission, in-care, and discharge samples, as well as child, family and event level analyses.- Use SQL and various business tools such as COGNOS, SAS, and SPSS to perform analyses, create reports, complete ad hoc requests, and monitor performance.- Create and maintain data warehouse-based dashboards and visualizations per specified requirements.- Identify and provide analysis of issues for existing systems resulting from errors detected during implementation or in production.- Conduct in-depth requirements-gathering activities to determine needs and scope of a program request.- Present results of analytics in multiple formats, include dashboards, visualizations, fact sheets and written reports for various stakeholder audiences.- Supervise junior unit staff to ensure unit goals and objectives are met and ensure that subordinate staff acquire the necessary skills to be successful, which may include the development of training programs for staff, including techniques in analytics, data use and management, written and visual presentation. Provide technical guidance to subordinate staff and data warehouse users.Additional duties will be discussed during the interview process.

Minimum Qualifications Non-competitive: one year of permanent service as a Data Analyst 1 OR bachelor's degree in data or computer science, informatics, economics, statistics, mathematics, or a related field, and three years of experience* in data visualization, and statistical models and data mining tools.*Substitution: A master's degree in the above fields may substitute for one year of the specialized experience. A Ph.D. in the above fields may substitute for two years of the specialized experience.

Additional Comments Preferred qualifications: Prior experience with child welfare or juvenile justice services subject matter and data reporting, SQL and tableau visualizationBackground Investigation Requirements:1) All prospective employees will be investigated through a Criminal Background Check (CBC), which includes State and federal Criminal History Record Checks. All convictions must be reported; conviction of a felony or misdemeanor, or any falsified or omitted information on the prospective appointee's employment application, may bar appointment or result in removal after appointment. Each case will be determined on its own merits, consistent with the applicable provisions of State and federal laws, rules, and regulations. Prospective employees will be fingerprinted in order to obtain a record of their criminal history information, and may be required to pay any necessary fees. 2) All prospective employees will be screened against the Statewide Central Register of Child Abuse and Maltreatment (SCR). Prospective employees will be required to pay any necessary fees. 3) For Division of Juvenile Justice and Opportunities for Youth (DJJOY) prospective appointees will be checked against the Staff Exclusion List (SEL) maintained by the Justice Center for the Protection of People with Special Needs. Prospective employees whose names appear on the SEL as having been found responsible for serious or repeated acts of abuse or neglect will be barred from appointment and may have their names removed from the eligible list(s) for the title(s) if applicable. The Office of Children and Family Services (OCFS) is an equal opportunity employer. OCFS does not discriminate based upon age, race, creed, color, national origin, sexual orientation, gender identity or expression, religion, military or veteran status, sex, disability (including pregnancy-related conditions), predisposing genetic characteristics, familial status, marital status or status as a victim of domestic violence, or other applicable legally protected characteristics. We devote special attention to dismantling racial injustice and recognize that diversity in our workforce is critical to fulfilling our mission. We are committed to the diversity of our staff and encourage applicants from marginalized communities to apply. In furtherance of Executive Order 31 and OCFS's mission to have a diverse workforce, all people with disabilities are encouraged to apply. All applicants must be dedicated to working in and sustaining an environment of inclusion that affirms and celebrates the backgrounds, learned and lived expertise, whole identities, and individual perspectives of our staff. Applicants of all backgrounds and experiences are encouraged to self-identify during the application process.

Some positions may require additional credentials or a background check to verify your identity.

Name New York State Office of Children and Family Services

Telephone 518-473-7936

Fax 518-473-6122

Email Address [email protected]

Address

Street Bureau of Personnel - CMV

52 Washington Street, 231 North

City Rensselaer

State NY

Zip Code 12144

Notes on Applying Qualified candidates should e-mail their resume and letter of interest to [email protected] You MUST include the Vacancy number of the position in the subject line of your email and/or cover letter to ensure receipt of your application. In order to qualify you for the position when you have current or prior New York State employment, you may be contacted by OCFS Personnel for your social security number to confirm your employment history.