Data Analyst - Information Technology

The Arc Mid-Hudson, with locations in Ulster, Greene, Putnam, and Columbia counties, has a full-time opportunity on our Information Technology team for a Data Analyst.

This position, reporting to the Senior Manager of Enterprise Data and Applications, will lend technical expertise to staff of the agency, specifically geared towards supplying data products, systems, and programs, that serve the mission of The Arc of Mid-Hudson.

Key responsibilities of the position will involve, but are not limited to:

• Be the primary person who builds and maintains solutions that enable the export, conversion, import and visualization of data, from both on-premises and cloud-based data systems.
• Work with staff throughout the agency to understand their data needs.
• Design queries and stored procedures as needed to create functional datasets, and troubleshoot and optimize queries and procedures to provide efficient, up-to-date access to data.
• Develop and maintain scripts, processes, or applications that simplify and automate workflows, including the transfer and transmission of data internally within the agency or with external partners.
• Monitor and validate data quality and integrity across systems used by the agency and handle PHI in accordance with the minimum necessary standard and agency privacy policies
• Improve data governance, backup and security, specifically around data systems.
• Help identify and select relevant products and solutions that serve the agency.
• Create documentation on in-house developed solutions.
• Shares responsibility within the Data team for managing and maintaining the agency’s SharePoint Online site and Power Platform applications (Power Apps, Power Automate workflows, etc.), primarily providing ongoing support, troubleshooting, and user guidance, with occasional development of new solutions as needs arise.

HOURS: 40/Monday through Friday/must be flexible

Minimum Requirements:

• Bachelor’s degree in computer/data related discipline and 2 years’ experience in related work; OR
• Associates Degree in computer/data related discipline and 4 years’ experience in related work; OR
• High School Diploma and 6 years’ experience in related work.
• Self-directing team player with an interest in the field of Business Intelligence.
• Willing to work a hybrid work schedule located in Kingston NY; travel to other agency sites in Ulster, Greene and Putnam counties as needed.
• Passionate about users’ needs and helping them address their challenges, and able to communicate effectively with technical and non-technical staff to understand their needs and explore possible solutions.
• Quick learner and good teacher.
• Willingness to own a problem, figure out solutions in independent manner while collaborating intensively with the rest of the IT team on any IT related topic that may need attention.
• Experience with expression languages (e.g. Excel formulas, SQL queries, R, Python, PowerShell, and Regular expressions) and/or other scripting languages.
• Understand the automation of tasks, i.e. export, import, and reporting tasks in a Windows environment.
• Understand data models, data warehousing, and the ETL process, and able to make use of data dictionaries, information schema views, and other tools to quickly learn database structures and relations.
• Comfortable with a Windows computer environment, running MS Office Productivity Software.
• Understand and implement security best practices to ensure the security and integrity of agency’s data.
• Excellent verbal and written communication skills.
• Familiar with the data privacy and security requirements of HIPAA, HITECH, and the NY SHIELD Act.
• Detail oriented and organized.

Additional Qualifications

• Experience with Business Intelligence tools, particularly Microsoft Power BI.
• Knowledge of healthcare data, specifically centered on those with developmental disabilities.
• Familiarity with SharePoint, MS Dynamics or other financial package, HR and EHR Systems.
• Experience with various data types, including financial, HR, health-care.
• A passion for working in a field that serves those with developmental disabilities.
• Experience managing SharePoint Online sites and developing/maintaining Power Platform applications (Power Apps, Power Automate) is a plus; this responsibility is shared across the Data team rather than owned by a single individual.

Job Type

Full-time

Pay: $69,159.35 - $80,570.65 per year

Benefits:

• Dental insurance
• Flexible schedule
• Flexible spending account
• Health insurance
• Life insurance
• Paid time off
• Professional development assistance
• Retirement plan
• Tuition reimbursement

Work Location: Hybrid remote in Kingston, NY 12401