Report Writer

Becoming part of the Sweetser family means you can make a difference in the lives of Maine children, adults, and families every day. As a nationally recognized and accredited leader, we offer competitive salaries, a wide range of benefits and the opportunity to join a passionate team of more than 700 employees.

Start Over with your Job Search

Returning Applicant? Login Now

Report Writer

Job Code:12351 Location:Saco 04072 Department:Other FT/PT Status:Full Time Summary: 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:

• Five (5) years' experience implementing and/or supporting software applications.

• Working knowledge of data management concepts and designs and software testing methodologies.

• Prior business systems experience preferred, including reporting and data visualization applications.

• 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.