Business Intell Ops Developer at TriWest Healthcare Alliance in Phoenix, Arizona

Job Description:

We offer remote work opportunities for those residing in the following states ONLY:

AZ, AK, AR, *CO, FL, HI, IA, ID, IL, KS, LA, MD, MN, MO, MT, NE, NV, NM, NC, ND, OK, OR, SC, SD, TX, UT, VA/DC, *WA, WI, WY

~Veterans, Reservists, Guardsmen and military family members are encouraged to apply~

Job Summary

The BI Operations Developer will be responsible for supporting ETL and reporting solutions associated with the TriWest enterprise data warehouse. The role will perform troubleshooting, root-cause analysis, and issue resolution specific development activities associated with production data warehouse and business intelligence solutions. The role will participate in the production release and post implementation portions of the systems development life cycle (SDLC) including facilitation of production release, emergency change facilitation and post-implementation support. The role will provide support to all user communities for the TriWest data warehouse and business intelligence technologies and solutions.

Education & Experience

Required:

• Bachelor's Degree in Business Administration, Computer Science, Mathematics, Engineering, or related field with programming and database systems coursework, OR equivalent database development experience
• 2+ years' experience developing ETL in Data Management, Data Warehousing, or Business Intelligence
• 3+ years' experience with SQL
• Experience developing SQL Integration Services (SSIS) solutions
• Experience managing, troubleshooting and developing database solutions in Microsoft SQL Server
• Experience using Visual Studio
• Working knowledge of TFS, or comparable source control tool

Preferred:

• 3+ years' experience in an ETL development role
• Experience with SQL Server Integration Services (SSIS) version 2015 and MSSQL Server 2015
• Experience with structured change management processes
• Experience in IT Operations supporting mission critical technology solutions
• Experience with Tableau Server administration
• Experience with SSRS administration

Key Responsibilities

• Performs root cause analysis on ETL packages and related data sets to resolve data load issues.
• Supports, troubleshoots, and performs remediative development on production ETL packages servicing an enterprise data warehouse.
• Proactively assesses ETL performance and identifies opportunities to tune ETL jobs to improve load times.
• Manages access control structures for Business Intelligence reporting environments.
• Performs root-cause analysis on performance issues impacting report; dashboard generation.
• Services support requests from Business Intelligence analysts, developers, and leaders.
• Supports technically junior members of the Data Management Operations team.
• Manages Tableau Server and SSRS environments for stability and performance.
• Identifies and advocates beneficial change opportunities.
• Serves as a point of contact for application and data users, data administrators and others.
• Ensures compliance with TriWest HIPAA, privacy and government security policies.
• Performs other duties as assigned.

Working Conditions:

• Works non-standard hours as required
• Works within a standard office environment, with less than 10% travel
• Extensive computer work with prolonged periods of sitting
• Participates in a weekly on-call rotation

• Department of Defense security clearance may be required - must be eligible to complete the clearance process

Company Overview

Taking Care of Our Nation's Heroes.

It's Who We Are. It's What We Do.

Do you have a passion for serving those who served?

Join the TriWest Healthcare Alliance Team! We're On a Mission to Serve®!

Our job is to make sure that America's heroes get connected to health care in the community.

At TriWest Healthcare Alliance, we've proudly been on that important mission since 1996.

Benefits

We're more than just a health care company. We're passionate about serving others! We believe in rewarding loyal, hard-working people who are willing to learn as they grow. TriWest Healthcare Alliance values teamwork. Join our team, fulfill your responsibilities, and you may also be considered for frequent pay raises, overtime opportunities to earn even more, recognition and reward programs, and much more. Of course, we also offer a comprehensive and progressive compensation and benefits package that includes:

• Medical, Dental and Vision Coverage


• Generous paid time off


• 401(k) Retirement Savings Plan (with matching)


• Short-term and long-term disability, basic life, and accidental death and dismemberment insurance


• Tuition reimbursement


• Paid volunteer time

*Annual base salary for Colorado and Washington State residents: $102,000 - $118,000 depending on experience

Equal Employment Opportunity

TriWest Healthcare Alliance is an equal employment opportunity employer. We are proud to have an inclusive work environment and know that a diverse team is a strength that will drive our success. To that end, TriWest strives to create an inclusive environment that cultivates and supports diversity at every organizational level, including hiring and retaining a diverse workforce, and we highly encourages candidates from all backgrounds to apply. Applicants are considered for positions without discrimination on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or any other consideration made unlawful by applicable federal, state, or local laws.