Remote Excel Vba Jobs in Rochester, NY (NOW HIRING)

Duties Description Under the direction of the Data Analyst 3 in the Office of Strategic Information Management (OSIM), the Data Analyst 2 will provide cross-unit support of the data management and analysis in all areas of OASAS Divisions of Recovery, Harm Reduction, and Addiction Treatment Centers (ATC), and Information Management and Reporting Unit. Illustrative duties include: Assist in design of visualizations, maps, and dashboards, using EHR and visualization tools (e.g., NetSmart, Tableau) for public and internal use. Gather and leverage information from various sources, including databases, spreadsheets, APIs, and other repositories

Advise on requirements for development of new data systems and applications. Scrub, filter, and preprocess data to remove inconsistencies, errors, and missing values. Convert raw data into usable formats by performing tasks such as normalization, aggregation, and restructuring.

Recommend actions and strategies based on data analysis to optimize performance and achieve business objectives. Prepare and deliver regular reports, presentations, and summaries of data analysis findings to management and other relevant parties. Stay updated on industry trends, emerging technologies, and best practices in data analysis through self-study and professional development activities.

Document data analysis methodologies, processes, and outcomes for future reference and knowledge sharing. Summarize and interpret historical data to identify trends, patterns, and anomalies. Understand statistical information software (SAS, Excel, R, etc.) to select/provide data analyses of OASAS systems or other related databases

Provide advanced geographic information systems (GIS) analysis as appropriate. Play a key role in developing and communicating Key Performance Indicators (KPI) for providers, programs, and Addiction Treatment Centers (ATCs). Respond to requests from agency staff.

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. This position requires travel (approximately 25%) occasionally to areas that may not be served by public transportation. Additional Comments This position may be located either at: 1732 South Avenue Rochester, NY 14620 or 200 Canal View Blvd.

Suite 102 Rochester, NY 14623-2850 The salary range listed for this posting reflects the full range for this graded position, factoring in annual performance advances based on satisfactory annual performance reviews. Candidates with no previous State service will begin at the hiring rate (starting rate of the salary range) listed above, plus any applicable Location Pay/Geographic Pay/Shift Pay differentials. 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.

Generous benefits package, which may include: medical, dental and vision coverage; NYS Employees Retirement System (pension); optional Deferred Compensation Program; tuition assistance; generous paid leave benefits; compensation for 13 State holidays per year; access to NY 529 and NY ABLE College Savings Programs; and Flex Spending Accounts. Telecommuting may be discussed as part of the interview process. The Public Service Loan Forgiveness (PSLF) Program allows public service employees to have the remaining balance on direct loans forgiven after 120 qualifying payments are made under an accepted repayment plan while working full-time for an eligible employer.

New York State is an eligible employer. More information is available at https://oer.ny.gov/public-service-loan-forgiveness. OASAS recognizes the value that different people, perspectives and cultures bring to the agency

We strive to create an inclusive culture that uplifts and supports our staff, fostering a sense of belonging in the workplace. Individuals with lived substance use and/or gambling experience are encouraged to apply. New York State OASAS is an equal opportunity employer and provides opportunity for all regardless of race, gender, religion, national original, sexual orientation, gender identity, age, veteran status, ability, or any other protected class.

OASAS encourages people with disabilities to apply. If you need a reasonable accommodation at any point in the application or hiring process, please reach out to Accessibility@oasas.ny.gov. Some positions may require additional credentials or a background check to verify your identity.