SQL Report Writer - Ardmore, OK

A Lighthouse is needed to help guide the way; to emit a light that helps navigate turbulent times and warn against the possible dangers ahead. Lighthouse Behavioral Wellness Centers is just such a place, guided by its core values of Hope, Dedication and Community.

As a SQL Report Writer SME, you are responsible for the creation, development, and revision of SSRS Reports and Echo Form Designer reports within Lighthouse Behavioral Wellness Centers. You will develop and implement processes and procedures for the development and administration of all SSRS Reports and Echo Form Designer forms.

To meet the increasing needs of our communities it is imperative that all team members understand and successfully reach and maintain the expected performance standard levels. To achieve total and sustainable success, each person must do their part. Lighthouse will do its part in providing all necessary tools and training required to help team members be successful.

DEFINITION:

Under immediate to general supervision:

• Will oversee the development and implementation of Echo Form Designer forms, Print Reports, and SSRS Reports.
• Will work with Clinical Teams to determine needed data extractions and develop reports.
• Will develop process and advise on data entry and integrity around outcomes that support the mission of Lighthouse.
• Will participate in decisions and processes of new implementations and processes.

This position is supervised by the Chief Information Officer (CIO).

EDUCATION AND EXPERIENCE:

• BA/BS degree in Information Management, Computer Science, Healthcare Administration, or another related field preferred. 3 years experience may be used in place of degree.
• 2-3 years of experience in writing SQL queries
• 2-3 years of experience in creating and maintaining SSRS
• Healthcare informatics background preferred.

KNOWLEDGE AND SKILLS:

• Strong understanding of relational databases & data structure (SQL)
• Strong technical foundation in data analysis and visualization tools. (SSRS)
• Ability to communicate clearly and concisely both orally and in writing.
• Ability to prioritize multiple tasks and organize large amounts of information.
• Experience in creating stored procedures with efficient and accurate data retrieval
• A working knowledge of computer technology and management procedures.
• Superior analytical and critical thinking skills.
• Excellent organizational skills.
• Communication and interpersonal abilities.
• Excellent interpersonal skills with the ability to establish and maintain effective working relationships with staff.
• High energy level, enjoyment of challenges and a fast-paced environment, and a record of self-motivation and personal initiative.
• Ability to understand and follow complex oral and written instructions and technical or legal terminology.
• Demonstrated skill and comfort in training and presenting to large groups.

JOB DUTIES AND RESPONSIBILITIES:

• Complete objectives and implement strategies for the IT department in response to an assessment of needs and Lighthouse strategic plans as directed by Leadership.
• Advise on and implement best practices for Form and Report design.
• Produce accurate representations of data that is aligned with the goals of Lighthouse.
• Administer Echo Form revisions, additions, removals, and adjustments.
• Use SSRS to develop needed data reports to ensure accurate visibility.
• Develop specialized reports, utilizing SQL, Power BI, SSRS, EHR software, and reporting tools such as and Crystal reports to gain transparency and visibility into business operations.
• Employee must be willing and able to perform all job-related travel normally associated with this position.
• Must meet satisfactory expectations at any scheduled job performance evaluation, coaching and/or Performance Improvement Plans.
• Must complete Lighthouse required training and resulting follow up and consultation as required at hire, annually and as directed by Supervisor.
• Performs other related duties as assigned by the immediate supervisor or other management as requested.

Must perform the specific job duties as listed above to meet position expectations.

Benefits:

Lighthouse offers an excellent benefits package to full-time employees. Benefits include: 100% employer-paid premiums for health, dental, life, and vision insurance; generous paid leave including PTO, sick, and agency holidays, employer matching 401K plan, and paid continuing education.

• 401(k)
• 401(k) matching
• Dental insurance
• Employee assistance program
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Professional development assistance
• Vision insurance

Work Remotely

• No

Job Type

• Full-time

Salary:

• $33.66 - (Hourly)

Schedule:

• 8-hour shift
• Day shift
• Monday to Friday

Ability to commute/relocate:

• Ardmore, Oklahoma: Reliably commute or planning to relocate before starting work (Required)

Work Location:

• One location