Terros
Business Intelligence SQL Developer 3
Terros, Phoenix, Arizona, United States, 85003
Job Details
Job Location
Central Avenue - Phoenix, AZ
Position Type
Full Time
Education Level
Bachelor's Degree
Travel Percentage
In-Office
Job Shift
Day Shift
Job Category
Information Technology Description
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 2022Terros 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 Arizona8 years of experience in T-SQL programming and SQL Server development4 years of working with EHR systems like NextGen, McKesson, EPIC, Cerner, etc. preferredBachelor's degree in Computer Science, Engineering or equivalent experienceFamiliarity with structured and unstructured data sources including csv, excel, xml, HL7, databases and data streamsProficiency with Microsoft Office applicationsFull-Time: Monday - FridayHighly Competitive Compensation & Full Benefits Package, Including 401K and Generous PTOThe 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 analysisSchedule jobs to automate different database relate activities including backup, monitoring database health, disk space, backup verificationWrite ad-hoc SQL queries and scripts to support various job functions and requests for reportsMaintain data within an Enterprise Data Warehouse to support business processes; Create and maintain automated EDI processes using SSIS, HL7, SFTP and other technologiesLead the development of optimal design adhering to architectural best practices; considers scalability, reliability and performance of systems/contexts affected when defining technical designsOversee product performance and make corrections and enhancements as necessaryEnsure all aspects of product development follow compliance and security best practicesMeets deadlines appropriate to the assigned projectsWork with other team members and/or independently to deliver projects on timeTrain and support other developers and data analysts as neededConfigure reporting products by mapping fields and validating result setsContribute to BI Knowledge Base articles and best practices documentationProvides training and support to end users of BI reports and productsPerforms any other duties as assigned
Apply with your resume at wwwterroshealth.orgBenefits & WellnessMultiple medical plans - including a no premium plan for employees and their familiesMultiple dental plans - including orthodontiaFinancial well-being - 401(k) with a company match, interest free medical line of credit, financial education, planning, and support4 Weeks of paid time off in the first yearWellness programChild Care Support ProgramPet InsuranceGroup life and disability insuranceEmployee Assistance Program for the Whole FamilyPersonal and family mental and physical health accessProfessional growth & development - including scholarships, clinical supervision, and CEUsEmployee perks and discountsGym membershipsTuition at GCU and University of PhoenixCar rentals
Qualifications
8+ years of experience as a SQL Developer or similar role4+ years of working with EHR systems like NextGen, McKesson, EPIC, Cerner, etc. desiredAdvance level of Proficiency in T-SQL programming and SQL Server managementBachelor's degree in Computer Science, Engineering or equivalent experienceProficiency with Microsoft Office applicationsExpert in structured/unstructured data sources including csv, excel, xml, HL7, databases and data streamsExperience with front-end development and design preferredAbility to work strategically, prioritize appropriately and meet critical deadlinesSelf-motivated and detail-oriented with strong analytical and problem-solving skillsExcellent verbal and technical writing skillsMust 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 policyMust 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.
Job Location
Central Avenue - Phoenix, AZ
Position Type
Full Time
Education Level
Bachelor's Degree
Travel Percentage
In-Office
Job Shift
Day Shift
Job Category
Information Technology Description
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 2022Terros 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 Arizona8 years of experience in T-SQL programming and SQL Server development4 years of working with EHR systems like NextGen, McKesson, EPIC, Cerner, etc. preferredBachelor's degree in Computer Science, Engineering or equivalent experienceFamiliarity with structured and unstructured data sources including csv, excel, xml, HL7, databases and data streamsProficiency with Microsoft Office applicationsFull-Time: Monday - FridayHighly Competitive Compensation & Full Benefits Package, Including 401K and Generous PTOThe 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 analysisSchedule jobs to automate different database relate activities including backup, monitoring database health, disk space, backup verificationWrite ad-hoc SQL queries and scripts to support various job functions and requests for reportsMaintain data within an Enterprise Data Warehouse to support business processes; Create and maintain automated EDI processes using SSIS, HL7, SFTP and other technologiesLead the development of optimal design adhering to architectural best practices; considers scalability, reliability and performance of systems/contexts affected when defining technical designsOversee product performance and make corrections and enhancements as necessaryEnsure all aspects of product development follow compliance and security best practicesMeets deadlines appropriate to the assigned projectsWork with other team members and/or independently to deliver projects on timeTrain and support other developers and data analysts as neededConfigure reporting products by mapping fields and validating result setsContribute to BI Knowledge Base articles and best practices documentationProvides training and support to end users of BI reports and productsPerforms any other duties as assigned
Apply with your resume at wwwterroshealth.orgBenefits & WellnessMultiple medical plans - including a no premium plan for employees and their familiesMultiple dental plans - including orthodontiaFinancial well-being - 401(k) with a company match, interest free medical line of credit, financial education, planning, and support4 Weeks of paid time off in the first yearWellness programChild Care Support ProgramPet InsuranceGroup life and disability insuranceEmployee Assistance Program for the Whole FamilyPersonal and family mental and physical health accessProfessional growth & development - including scholarships, clinical supervision, and CEUsEmployee perks and discountsGym membershipsTuition at GCU and University of PhoenixCar rentals
Qualifications
8+ years of experience as a SQL Developer or similar role4+ years of working with EHR systems like NextGen, McKesson, EPIC, Cerner, etc. desiredAdvance level of Proficiency in T-SQL programming and SQL Server managementBachelor's degree in Computer Science, Engineering or equivalent experienceProficiency with Microsoft Office applicationsExpert in structured/unstructured data sources including csv, excel, xml, HL7, databases and data streamsExperience with front-end development and design preferredAbility to work strategically, prioritize appropriately and meet critical deadlinesSelf-motivated and detail-oriented with strong analytical and problem-solving skillsExcellent verbal and technical writing skillsMust 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 policyMust 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.