Report Writer

Come join the Sweetser team working as a Report Writer

This position performs professional technical work which requires expert level proficiency in providing for the design, development, implementation and support of business and mission-critical enterprise Business Intelligence (BI) reports and ad hoc reporting. An incumbent of this class may work as a cross-functional team member to supply required data or may be dedicated to a specific assignment. Responsibilities include gathering and aggregating data and using business and technical skills to design, develop, test and implement reports and dashboards that utilize the underlying data store(s) and/or data warehouse(s) to meet agency objectives.

**ESSENTIAL FUNCTIONS**:

- Report writing experience in Crystal Reports, SSRS, PowerBI or similar software.
- Moderate level of expertise writing complex SQL queries.
- Working with data sets (Transforming and loading data).
- Working knowledge of MS O365 Suite.
- Demonstrated ability to communicate orally and in writing.
- Create new reports, visualizations, and workflows based on business logic as provided by manager through conversations with business lines.
- Create ad hoc reports and datasets based on data requests.
- Maintain/update current reports and workflows based on evolving needs.
- Troubleshoot reports or processes to resolve errors.
- Document report or process requirements. Write clear procedures and instructional manuals to build out self-service capabilities.
- Data Quality will be assured through documentation, process, and data validation.
- Manages assigned projects in support of primary data systems and strategic goals.
- Offers training and assistance to less experienced team members and to customers.
- Ensures the security and confidentiality of organizational data and client Protected Health Information.
- Manages End User Acceptance Testing (EUAT) for all system additions and modifications prior to deployment to ensure uninterrupted service and access to systems.
- Participates in oversight of vendor relationships and ensures compliance with agency needs to ensure timely and effective resolution of issues.
- Provide customer service as part of the service desk team, including but not limited to Tier 3 support as identified in the Service Level Agreement (SLA).
- Participates in off hours "on-call" as needed.

**EDUCATION**:

- Associates degree in related field is preferred; Bachelor of Science is desirable.

**EXPERIENCE**:

- Working knowledge of data management concepts and designs and software testing methodologies.
- Demonstrated project management experience in a complex environment.
- Prior operational experience in a healthcare environment desirable.
- Valid Driver's license.
- Persons with lived experience in the Mental Health and/or Substance Abuse system are encouraged to apply.