Report Developer

Overview

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.

Report Developer

Job Code: 13058

Location:

Saco 04072

Department:
Other

FT/PT Status:
Full Time

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.

• Report writing experience in Crystal Reports, SSRS, Power
  
  BI 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.

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

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