• Report Developer

    Sweetser (Saco, ME)


    Report Developer

     

    Job Code:12825

     

    Department:Other

     

    FT/PT Status:Full Time

    Summary:

    Come join the Sweetser team working as a Report Writer!

     

    $2,000 Sign-On Bonus!

     

    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.