Overview
On Site
USD 102,000.00 - 118,000.00 per year
Full Time
Skills
Root cause analysis
Technical Support
Microsoft SSIS
Microsoft SQL Server
DoD
Data warehouse
Issue resolution
Business intelligence
Systems engineering
Business administration
Computer science
Database
Data management
Microsoft Visual Studio
Version control
Extract
transform
load
Change management
IT operations
Server administration
Data loading
Access control
Security clearance
Health care
Augmented reality
Impact analysis
Marketing operations
SD
Military
Operations
Reporting
Software development methodology
Facilitation
Mathematics
Software development
SQL
Management
Microsoft TFS
Tableau
Microsoft SSRS
Administration
Data
Dashboard
Regulatory Compliance
HIPAA
Privacy
Policies
Value engineering
Teamwork
Insurance
Recruiting
SAP BASIS
Job Details
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:
*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.
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.