View Our Website View All Jobs

SQL Report Writer

Family Service Association is a comprehensive private, non-profit social service agency dedicated to the development and implementation of services designed to provide strength and support to individuals and families throughout southeastern Massachusetts.  Headquartered in Fall River, Family Service Association strives to increase the capacity of individuals and families to cope with the stresses of family life and interpersonal relationships in a positive, productive and health-improving manner.  This agency is a leading provider of professional social services in the South Coast region of Massachusetts, with a 125-year tradition of high quality.

We are seeking a full time (35 hours per week) SQL Report Writer.  The SQL report writer will provide business intelligence, and administrative support in the advancement of FSA’s Electronic Health Record (EHR) (Qualifacts Carelogic); perform various operational data maintenance functions along with preparing routine and ad hoc data extractions, provide scheduled & ad-hoc reports, and analysis summaries. Additional responsibilities include delivering routine information/data to programs and departments and assisting in the development of workflows and configurable forms within the EHR for customized data entry.

Duties and Responsibilities:

  1. Design, write and test Oracle SQL queries and reports using Pentaho Report Designer.
  2. Consult with program staff to determine and understand their reporting needs.  
  3. Perform independent analysis of data outputs to ensure accuracy.
  4. Review current reports and outputs for accuracy, efficiency and viability.
  5. Handle specialized database and data manipulation projects and assist in data migration projects.
  6. Work with programs to develop or enhance workflows for electronic documentation in the EHR.
  7. Develop configurable forms and service documentation within the EHR.
  8. Document processes to allow for consistent approach to future initiatives.
  9. Serve as an assistant EHR System Administrator.
  10. Function as a member of the IT Team and provide backup for other team members as needed.
  11. Maintain discretion and client confidentiality at all times.

Two or four year college degree preferred.  Must have experience with SQL (Oracle SQL preferred), experience with report writing, business intelligence and data analytics.  Proficiency with Microsoft Office, including MS Access.  Strong organizational, verbal and communication skills and the ability to handle changing priorities.  Excellent analytical and problem-solving skills, ability to work independently, train others and acquire new skills as needed.  Experience with electronic health records (EHR) desirable.

The hours are Monday through Friday, 9:00 a.m. - 5:00 p.m. (flexible).  This is a benefits eligible position.  We offer medical, dental, short term, long term and life insurance, 403(b), flexible spending account along with a generous time off package.  

Family Service Association is an Equal Opportunity Employer.  




Read More

Apply for this position

Apply with Indeed
Attach resume as .pdf, .doc, or .docx (limit 2MB) or Paste resume

Paste your resume here or Attach resume file