We embrace diversity and equality in a serious way. We are committed to building a team with a variety of backgrounds, skills and views. The more inclusive we are, the better our work will be in fulfilling our mission of “Building Brighter Futures for 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.

Our DEI Vision and Mission

Our mission is to foster a company culture where diversity and inclusion is embedded in our core belief system. Our vision is to increase our fundamental awareness around inclusive best practices and execute plans to support an equitable environment. We will work to create an environment where every employee is considered and valued. We will resist hate, judgment, shame, and blame, focusing instead on difference, choice, compromise, and respect. We will adopt an understanding that DEI is a journey, not a destination. Through intentionality, we will meet others where they are and learn how to bring each other along.

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

About the Opportunity:

SQL Report Writer

Job Summary: The SQL Report Writer 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.

Full-time - Monday through Friday / Remote: Candidates must reside in either Oregon or Washington state.

About the position:

• 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.

About You:

To perform the job successfully, an individual should demonstrate the following competencies:

• SQL query writing experience
• Report management and optimization experience
• SQL stored procedure/database management experience
• 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.

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.

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

Benefits:

We offer an excellent benefits package, including the following:

• 100% Employer Paid Medical, Vision, and Dental for Full Time Employees
• 401k retirement plan matches.
• Growth | Career track, continuing education, and professional development.
• Paid Training
• Generous Vacation and Sick Leave
• And more!

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.

Application Details: Consideration of candidates will be on-going, and position may close after three days of original postings.

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 ORS 181.536.727.537 and agency policy. We are an Equal Opportunity Employer and Service Provider and support culturally linguistically diverse governance, leadership, and workforce.