Database Report Writer jobs in Lewiston, ME

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.