SQL Report Writer

Location: Portland - Parry Center for Children
Program/Department: Information Technology
Schedule: Full Time; Exempt

Meet Trillium Family Services:

We are guided by the simple yet crucial mission of building brighter futures with children and families.

Our vision is to create safe communities where children are healthy, and every family has the opportunity for success. Families get the support they need – when and where they need it. There is a focus on prevention and health; organizations and systems are connected in a synergistic sanctuary community that generates: Non –violence, Growth and Change, Democracy, Emotional intelligence, Social learning, Open communication, and Social Responsibility.

Our investment in the future of each child means that the next generation of Oregonians will have the skills to contribute meaningfully through employment, community service, and raising their own healthy families.

At TFS we believe that every child and family can have a brighter future, through the love we bring together we can make this possible. There is so much need for mental and emotional support at all levels of our communities.

To take a behind the scenes look our programs please visit our website at www.trilliumfamily.org

Are you ready to help “Build a Brighter Future?”

Main purpose of the SQL Report Writer role:  works in conjunction with multiple teams to develop and support organization-wide reporting. This position is responsible for end-to-end report development which may include interaction with end users to gather requirements. The SQL Report Writer is required to understand report objectives, designing, and developing reports using the available tools delivering reports to end users.

Demonstrates Competency in the Following Areas:    

  • Assist with development of business and functional requirements for reports.
  • Design, develop, test and implement reports as necessary to fulfill business requirements.
  • Serve as a subject matter expert for reporting across the organization and assist users with reporting and analysis activities and tools, including ad hoc reporting.
  • Support user training, testing, documentation, and roll-out of reports and end-user reporting tools.
  • Maintain knowledge of business processes and understand cross-functional business relationships and their use of information.
  • Construct reusable reports based on common reporting requests using available tools.
  • Initiate and maintain cooperative relationships with co-workers, managers and supervisors, customers/clients.
  • Contribute and develop insights into leveraging collected data to improve operational performance and customer experience.
  • Assist in the evaluation and implementation of data integration between operational processes, as necessary.
  • Document sources of reports and steps necessary to generate complex reports.
  • Utilize business intelligence tools to design, construct, test, and deploy self-service reports and visualizations.
  • Provide support as required to ensure the availability and performance of developed reports
  • and dashboards.
  • Provide technical assistance and cross training to other team members.
  • Complete all required training

Professional Requirements:     

  • Knowledge of SQL including creating view, tables and stored procedures for reporting purposes
  • Knowledge of SQL SSRS reporting design and structure.
  • Experience translating business questions / requirements into meaningful reports.
  • Ability to communicate effectively, both orally and in writing, with all levels of staff and outside vendors.
  • Ability to listen to end users’ needs and provide innovative and proficient reporting solutions
  • Ability to work with frequent interruptions and changes in priorities.

ADDITIONAL RESPONSIBILITIES: Other duties may be assigned.


Education: Graduation from an accredited four-year College, University or Institute with major course work in Information Systems/Technology, or commensurate experience related to the position.

Certificates, Licenses, Registrations:  Maintain a driving record acceptable by the agency and a current driver’s license for state of residence, when authorized to use own vehicle for agency business, employee must maintain personal insurance.

Experience: Minimum of 2 year of experience in SQL and Data Visualization tools (Power BI preferred). Experience in reporting needs in a healthcare environment is preferred.

Job Knowledge: Team player with excellent communication skills and have the ability to manage assignments independently. Operates and makes decisions within established guidelines, organizational policy and procedure, federal, state, and local laws, rules and regulations.  Job involves a high degree of complexity in that employee deals with highly sensitive and confidential information.

Skills: Computer and customer service skills

Physical Demands:  For physical demands of position, including vision, hearing, repetitive motion and environment, please contact the HR department.  Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of the position without compromising client care.

Consideration of applicants will begin as soon as 1/3, and may close without notice.


If you need accommodation to review the information and/or complete the application process, please contact the Human Resources Department.

Trillium Family Services is a drug free workplace. All final applicants will be subject to a criminal record identification check pursuant to OARS 181.536.727.537 and agency policy. We are an Equal Opportunity Employer and Service Provider and support a culturally linguistically diverse governance, lead