Report Developer Job Code:12825 Location:Saco 04072 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.