Data Analyst

POSITION IN THE ORGANIZATION

First Level: CEO

Second Level: VP of IT & Data

Third Level: Data Analyst

Job Description

We are pursuing a candidate to join our IT & Data department and lead the oversight and generation of reports and data analytics using Structured Query Language (SQL) to extract and manipulate data from database systems. This role will serve as an internal authority and organizer of datasets originating from a multitude of data sources and work to centralize datasets into a data warehouse. Will inventory existing organizational reports and determine validity of data, original report requester, and whether the dataset remains relevant. This role will also work interdepartmentally to understand the needs of internal and external stakeholders and generate insightful reports and narratives regarding contact center performance and programming.

Primary Responsibilities:

• Responsible for the management and analysis of cross-departmental datasets with an emphasis on contact center data, including contact volume, performance metrics, client data, and service delivery outcome data.
• Ensures the integrity, quality, accuracy, and efficiency of data results through testing, validation, and following best practices.
• Responsible for the development and maintenance of a data dictionary, including data collection requirements per grants and contracts, the data owners, and quality assurance.
• Works closely with department leaders to design analytical plans and perform statistical analysis.
• Manages reporting by working with data contained in relational databases, such as SQL databases to meet ad hoc and recurring reporting needs for organization.
• Supports data interfaces between systems by writing scripts to review data, import/export data, and resolve data format and/or integrity issues.
• Proficient in MS-SQL including: creating tables, views and stored procedures that would be used in the reporting process.
• Organization and standardization of SQL data tables, formatting of data structures, and troubleshooting and providing root cause analysis of errors in the transfer of that data from those alternative sources into SQL.

Other Responsibilities:

• Collaborates with various departments to identify needs and opportunities for improved data management and delivery.
• Responsible for querying and managing data using RMCP reporting tools, such as SQL and Zoho Analytics.
• Identify opportunities for further automation and statistical analysis.
• Develop and communicate reporting timelines and adjust priorities as necessary to meet agreed upon deadlines.
• Other duties as assigned.

Required:

• Associate’s degree
• Competent in other IT disciplines, including professional experience in SQL Reporting Services, report-writing software, and SQL database structures and maintenance
• Minimum 2 years working experience with SQL and writing queries for relational databases as well as importing/exporting datasets.
• Experience in utilizing principles and practices of effective and persuasive communication to elicit and/or present explanatory or interpretive information in an organized, concise manner.
• Ability to manage multiple projects simultaneously and willingness to quickly pivot into new tasks as needed.

Preferred:

• Bachelor’s degree
• Experience utilizing Zoho Analytics platform.
• Experience in contact center and/or behavioral health sectors.
• Superior analytical, problem-structuring, and problem-solving skills; experience managing, cleaning, analyzing and presenting data, and presenting comprehensive analyses concisely.
• Ability to perform troubleshooting techniques to isolate, diagnose, and repair data and reporting issues.
• Experience with Tableau and/or other data visualization tools.

Qualifications:

No single candidate will come in with all desired qualifications - above all else we’re looking for someone with an eagerness and ability to learn new skills and solve dynamic problems in a collaborative, supportive, and inclusive environment.

Salary: $80,000/Yearly

BENEFITS INCLUDE: The following is a list of the benefits offered to all full-time employees. Part-time employees’ benefits are limited to paid leave, training, and the Employee Assistance Line.

• Comprehensive Medical Kaiser Permanente & BC/BS Anthem
• 2 Dental Options
• Vision
• Out of Pocket Reimbursement Coverage – SIS Link or HSA
• Life Insurance - Company Sponsored and Voluntary
• Short-Term and Long-Term Disability - Company Paid
• 401k
• Employee Assistance Line
• Paid Training
• Paid Time Off, Sick and Holidays

A link to our benefits listed on our website is: https://rmcrisispartners.org/about-us/career/

BACKGROUND CHECKING: Finalists for this position may be required to provide date of birth, Social Security and Driver’s License numbers prior to employment for the purpose of background and criminal record checks. Any offers of employment are contingent on successful background and record checks.

WE ARE COMMITTED TO PRINCIPLES OF EQUAL EMPLOYMENT OPPORTUNITY: RMCP is dedicated to the principles of equal employment opportunity. RMCP prohibits unlawful discrimination against applicants or employees on the basis of age 40 and over, race, color, national origin, sex, marital status, religion, disability, military/veteran status, sexual orientation (including transgender status), genetic information, or any other applicable status protected by state or local law. RMCP is committed to making employment decisions based on valid job-related requirements.