BI Healthcare Developer

Terros Health - Phoenix, AZ (30+ days ago)3.3

Terros Health, Inc. is a four decade old, fully integrated community healthcare provider: With over 30 clinics throughout the Phoenix metro area, including Tucson, Flagstaff and Prescott Arizona. We have an exciting and immediate need for an experienced Informatics Developer - I. As one of the state’s leading, healthcare providers: Terros Health offers great work-life-balance, and continued career progression. Each new hire is eligible to participate in our best-in-class employee benefit plan the 1st of the month following their date of hire.

Benefits include:
Medical insurance: PPO Health Reimbursement, HDHP Health Savings Account, and a traditional PPO
Vision insurance
Dental and Orthodontics insurance
Flexible Spending Accounts
Accidental Death & Dismemberment insurance
Disability insurance
Paid Life insurance
401K with company matching (Company matching after 6 months of employment)
Employee Assistance Program
Financial Consultation and Referrals
Family & Caregiving Resources and Referrals
Legal Consultations
Paid Holidays
Generous paid time off/Vacation time
Paid sick time
Tuition discounts through our strategic partnership
Employee discounts on car rental through Enterprise Rental Car
If you've been in search of a growing organization with a forward thinking, and caring culture: Terros Health may be the company you’ve been looking for.

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. The BI Healthcare Developer will work within the Business Intelligence department to provide sustainable solutions to a variety of business needs for Terros Health. The developer will follow established best practices to write, test and deploy SQL procedures, SSAS tabular models and reports through Excel, PowerBI, SSRS, Crystal or other presentation layers.

Create or modify SQL stored procedures, tables, views and functions
Create or modify SSAS tabular models using SQL Server Data Tools through Visual Studio
Develop or modify calculated measures using DAX within SSAS models
Deploy reports through Excel PowerPivot, PowerBI, SSRS or Crystal based on need
Maintain data within an Enterprise Data Warehouse to support business processes
Create and maintain automated EDI processes using SSIS, HL7, SFTP and other technologies
Participate in peer review and testing
Participate in scheduled development sprint cycles and targeted performance goals
Work with analysts, clinical specialists and administrators to plan, scope, review and deliver solutions to meet the objectives of a project
Develop plans and estimate timelines for meeting anticipated deadlines
Communicate barriers, risks and assumptions to providing requested data or meeting deadlines to management
Contribute to documentation including report definitions, user guides, knowledge-base articles or data dictionaries as needed
Work independently or on a team to meet deliverables within the scope of a project
Learn new technologies, methods and strategies as needed
4+ years of MSSQL development experience
2+ years of working with EHR systems like NextGen, McKesson, EPIC, Cerner, etc.
2+ years of data modelling and visualization with SSAS, PowerBI, tableau or other platforms
2+ years relevant application or systems development experience desired
Familiarity with statistical methods, machine learning and tools preferred
Solid understanding of structured and unstructured data sources including csv, excel, xml, HL7, databases and data streams
Proficiency with Visual Studio tools
Self-motivated and detail-oriented with strong analytical and problem-solving skills
Ability to work strategically and prioritize appropriately
Must possess a commitment to meeting mission-critical deadlines
Must possess a desire to collaborate with and elevate peer developers and coworkers
Excellent verbal and technical writing skills
Excellent customer service skills