Terros Health is pleased to share an exciting and rewarding opportunity for an Business Intelligence SQL Developer 3 in Phoenix, AZ.

(Remote ONLY TO Arizona RESIDENTS)

Terros Health is a health care company focused on the whole person, providing primary care and specializing in mental health and substance use treatment for over 50 years. We help people live their lives in recovery and we save lives every day. Our vision is to provide extraordinary care by empowered people, achieving exceptional outcomes. We are guided by our core values of integrity, compassion and empowerment, with diversity woven throughout. Together, we are Inspiring Change for Life!

If you are interested in working for one of the State's Leading Integrated Healthcare Organizations that promotes Integrity, Compassion, and Empowerment, we encourage you to apply!

Recently awarded among Arizona's Most Admired Companies in 2022

Terros Health is hiring a Full-Time Business Intelligence SQL Developer 3 at our Central Avenue location in Phoenix, AZ.

(Remote to Arizona Residents Only!)

Must be a US Citizen or Permanent Resident Visa Status and Reside in Arizona

8 years of experience in T-SQL programming and SQL Server development

4 years of working with EHR systems like NextGen, McKesson, EPIC, Cerner, etc. preferred

Bachelor's degree in Computer Science, Engineering or equivalent experience

Familiarity with structured and unstructured data sources including csv, excel, xml, HL7, databases and data streams

Proficiency with Microsoft Office applications

Full-Time: Monday - Friday

Highly Competitive Compensation & Full Benefits Package, Including 401K and Generous PTO

The Business Intelligence department provides key insights into the Clinical, Operational and Financial activities of Terros Health through the design, development, and maintenance of metrics, data models, visualizations and reports.

Develop complex T-SQL queries, stored procedures, triggers and SSIS to support application development and data analysis
• Schedule jobs to automate different database relate activities including backup, monitoring database health, disk space, backup verification
• Write ad-hoc SQL queries and scripts to support various job functions and requests for reports
• Maintain data within an Enterprise Data Warehouse to support business processes; Create and maintain automated EDI processes using SSIS, HL7, SFTP and other technologies
• Lead the development of optimal design adhering to architectural best practices; considers scalability, reliability and performance of systems/contexts affected when defining technical designs
• Oversee product performance and make corrections and enhancements as necessary
• Ensure all aspects of product development follow compliance and security best practices
• Meets deadlines appropriate to the assigned projects
• Work with other team members and/or independently to deliver projects on time
• Train and support other developers and data analysts as needed
• Configure reporting products by mapping fields and validating result sets
• Contribute to BI Knowledge Base articles and best practices documentation
• Provides training and support to end users of BI reports and products
• Performs any other duties as assigned

Apply with your resume at wwwterroshealth.org

Benefits & Wellness

• Multiple medical plans - including a no premium plan for employees and their families
• Multiple dental plans - including orthodontia
• Financial well-being - 401(k) with a company match, interest free medical line of credit, financial education, planning, and support
• 4 Weeks of paid time off in the first year
• Wellness program
• Child Care Support Program
• Pet Insurance
• Group life and disability insurance
• Employee Assistance Program for the Whole Family
• Personal and family mental and physical health access
• Professional growth & development - including scholarships, clinical supervision, and CEUs
• Employee perks and discounts
• Gym memberships
• Tuition at GCU and University of Phoenix
• Car rentals

• 8+ years of experience as a SQL Developer or similar role
• 4+ years of working with EHR systems like NextGen, McKesson, EPIC, Cerner, etc. desired
• Advance level of Proficiency in T-SQL programming and SQL Server management
• Bachelor's degree in Computer Science, Engineering or equivalent experience
• Proficiency with Microsoft Office applications
• Expert in structured/unstructured data sources including csv, excel, xml, HL7, databases and data streams
• Experience with front-end development and design preferred
• Ability to work strategically, prioritize appropriately and meet critical deadlines
• Self-motivated and detail-oriented with strong analytical and problem-solving skills
• Excellent verbal and technical writing skills
• Must have valid Arizona driver's license, be 21 years of age with minimum 4 years driving experience, and meet requirements of Terros Health's driving policy
• Must have a valid Arizona Level 1 Fingerprint Clearance card or apply for one within 7 working days of assuming role (HR will assist with the process.)
• Must pass a TB Test

Physical demands of this position are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.