OverviewTerros Health is pleased to share an exciting and rewarding opportunity for an Business Intelligence SQL Developer 1 in Phoenix, AZ. (Remote ONLY TO Arizona RESIDENTS) Terros Health (http://www.terroshealth.org) 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 appl y! Recently awarded among Arizona’s Most Admired Companies in 2022 ResponsibilitiesTerros Health (http://www.terroshealth.org) is hiring a Full-Time Business Intelligence SQL Developer 1 at our Central Avenue location in Phoenix, AZ . (Remote to Arizona Residents Only!) 2+ years of experience in T-SQL programming and SQL Server development 2+ 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.
Will work within the Business Intelligence department to provide sustainable solutions to a variety of business needs
Will follow established best practices to write, test and deploy SQL procedures
Develops or modify T-SQL queries, stored procedures, tables, functions, and triggers to support application development and data analysis
Writes ad-hoc SQL queries and scripts to support various job functions and requests for reports
Participates in peer review and testing
Maintains data within an Enterprise Data Warehouse to support business processes; Create and maintain automated EDI processes using SSIS, MIRTH/HL7, SFTP and other technologies
Works with stakeholders to plan, scope, review and deliver solutions to meet the objectives of a project
Consistently creates optimal design adhering to architectural best practices; considers scalability, reliability and performance of systems/contexts affected when defining technical designs
Ensures all aspects of product development follow compliance and security best practices
Performs development activities based on business requirements and technical specifications
Meets deadlines appropriate to the assigned projects
Works with team members and/or independently to deliver products on time
Learns new applications and technologies as needed
Co ntributes to BI Knowledge Base articles and best practices documentation
Configures reporting products by mapping fields and validating result sets
Provides training and support to end users of BI reports and products
Apply with your resume atwwwterroshealth.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
Qualifications
2+ years of experience in T-SQL programming and SQL Server development
2+ 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
Self-motivated and detail-oriented with strong analytical and problem-solving skills
Ability to work strategically, prioritize appropriately and meet critical deadlines
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 positio n 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.
Job LocationsUS-AZ-PhoenixJob ID 2024-9311 of Openings 1Category Information Technology Program Clinical Analytics Weekly Hours 40