Business Intelligence SQL Developer 3- IT- Healthcare - Phoenix, AZ - Terros Health - Remote

Terros Health; Phoenix (AZ); Remote; USD 95,000 - 120,000; Full time

Job summary

Join Terros Health as a Business Intelligence SQL Developer 3 in Phoenix, AZ. This role involves managing and developing SQL databases to enhance data insights for Clinical, Operational, and Financial activities in a leading healthcare organization. Candidates should possess at least 8 years of SQL experience and a Bachelor's degree in a related field, enjoying benefits that promote financial well-being and work-life balance.

Benefits

Multiple medical plans

401(k) with company match

Four weeks of paid time off

Wellness programs

Child Care Support

Qualifications

• 8+ years of experience as a SQL Developer or similar role.
• Familiarity with EHR systems like NextGen, McKesson, EPIC.
• Strong analytical and problem-solving skills.

Responsibilities

• Develop complex T-SQL queries and oversee data performance.
• Maintain an Enterprise Data Warehouse to support business processes.
• Provide training and support to end users of BI reports.

Skills

T-SQL

SQL Server management

Analytical skills

Problem-solving

Communication skills

Education

Bachelor’s degree in Computer Science

Engineering degree or equivalent

Tools

Microsoft Office

Job description

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

Terros Health is a healthcare 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.

Responsibilities

We are 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 and reside in Arizona.

• 8 years of experience in T-SQL programming and SQL Server development.
• 4 years of experience 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.

Work Schedule: Monday - Friday, Full-Time

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 database activities including backup, monitoring database health, disk space, and backup verification.
• Write ad-hoc SQL queries and scripts to support various 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 designs adhering to architectural best practices, considering scalability, reliability, and performance.
• Oversee product performance and implement corrections and enhancements as necessary.
• Ensure all product development follows compliance and security best practices.
• Meet deadlines and work independently or with team members to deliver projects on time.
• Train and support other developers and data analysts as needed.
• Configure reporting products by mapping fields and validating results.
• Contribute to BI knowledge base articles and best practices documentation.
• Provide training and support to end users of BI reports and products.
• Perform other duties as assigned.

Benefits & Wellness

• Multiple medical plans, including a no-premium plan for employees and families.
• Financial well-being benefits including 401(k) with company match, interest-free medical line of credit, and financial education.
• Four weeks of paid time off in the first year.
• Wellness programs, Child Care Support, Pet Insurance, and more.

Qualifications

• 8+ years of experience as a SQL Developer or similar role.
• 4+ years of experience with EHR systems like NextGen, McKesson, EPIC, Cerner, etc. (desired).
• Advanced proficiency in T-SQL and SQL Server management.
• Bachelor’s degree in Computer Science, Engineering, or equivalent.
• Proficiency with Microsoft Office applications.
• Expertise in structured and unstructured data sources including CSV, Excel, XML, HL7, databases, and data streams.
• Experience with front-end development and design (preferred).
• Ability to prioritize and meet deadlines.
• Strong analytical, problem-solving, and communication skills.
• Must have a valid Arizona driver’s license, be 21+, and meet driving policy requirements.
• Must have or apply for a valid Arizona Level 1 Fingerprint Clearance card within 7 days.
• Must pass a TB Test.

Physical demands are representative of those required to perform the essential functions of this job. Reasonable accommodations may be made for individuals with disabilities.