Data Engineer Sr.

TriWest Healthcare Alliance Corp.

Phoenix (AZ)

Remote

USD 135,000 - 144,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Medical, Dental and Vision
401(k) with matching
Paid time off
Disability insurance
Tuition reimbursement
Paid volunteer time

Job summary

TriWest Healthcare Alliance is seeking a Senior Data Engineer to lead the design and development of ETL, moving data from source feeds to target systems (SQL Server, Snowflake) using Data Bricks. The role covers SDLC phases with close collaboration with Data Architects.

Requirements include a Bachelor's, 5+ years in data engineering, 2+ years with Azure and 3+ years in data integration using Python/R/SQL, and DoD background investigation clearance.

Qualifications

  • Bachelor's degree in a related field with programming and database coursework.
  • U.S. Citizenship required.
  • 5+ years experience in a Data Engineering role.
  • 2+ years with Azure and 3+ years building data integration in Python, R, or SQL.
  • ETL experience with structured and semi-structured data.
  • Experience gathering business requirements from cross-functional teams.
  • Experience with SDLC processes and DevOps.

Responsibilities

  • Collaborates with users, business analysts, developers, DBAs, and PMs on reporting needs.
  • Collaborates with data architect to create data models for reporting databases.
  • Implements changes and provides post-implementation support.
  • Identifies and advocates beneficial change opportunities.
  • Acts as a technical resource for data users and admins.
  • Ensures compliance with HIPAA and government security policies.
  • Performs other duties as assigned.
  • Regular and reliable attendance is required.

Skills

Data engineering
SDLC & DevOps
Cross-functional collaboration
SQL & ETL
Data modelling

Education

Bachelor's degree in related field

Tools

Azure
Python
R
SQL
Data Bricks
SQL Server
Snowflake
Oracle

Job description

Profile

We offer remote work opportunities in the following locations ONLY: AK, AR, AZ, CO, DC, FL, HI, IA, ID, IL, KS, LA, MD, MN, MO, MT, NE, NV, NM, NC, ND, OK, OR, SC, SD, TN, TX, UT, VA, WA, WI, WY

US Citizenship REQUIRED

Our Department of Defense contract requires US citizenship and a favorably adjudicated DOD background investigation for this position.

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

Job Summary

The Senior Data Engineer will be responsible for design and development of ETL. The role will cover full systems development life cycle (SDLC) phases including requirements gathering, data analysis, system design, development, implementation, and post-implementation support. During the design phase, the role will work closely with Data Architects/Models. The developer will be responsible the ETL movement of data from originating source feeds (files, x12, etc) to target systems (SQL Server, Snowflake) using Data Bricks.

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
  • U.S. Citizenship
  • Must be able to receive a favorable Interim and adjudicated final Department of Defense (DoD) background investigation
  • 5+ years of experience in a Data Engineering role
  • 2+ years of experience with Azure * 3+ years of experience developing data integration related source code in Python, R, SQL, or equivalent
  • Experience in ETL with both structured and semi-structured data
  • Experience in gathering business requirements from cross functional teams
  • Experience with SDLC processes and DevOps
Preferred
  • 2+ years of experience with Data Bricks preferably within Azure Cloud
  • 3+ years of experience with Python
  • Experience with Data Governance
  • Experience with SQL Server and Snowflake in Azure Cloud
  • Experience with x12 data file formats
  • Understanding of ANSI and T-SQL
  • Experience with data analysis in the healthcare industry
Key Responsibilities
  • Collaborates with users, business analysts, developers, database administrators, and project managers on reporting needs.
  • Collaborates with data architect to create conceptual, logical, and physical data models for reporting databases.
  • Implements changes and provide post-implementation user support and system support.
  • Identifies and advocates beneficial change opportunities.
  • Acts as a technical resource for application and data users, data administrators and others.
  • Ensures compliance with TriWest HIPAA, privacy and government security policies.
  • Performs other duties as assigned.
  • Regular and reliable attendance is required.
Competencies

Communication / People Skills: Ability to influence or persuade others under positive or negative circumstances; adapt to different styles; listen critically; collaborate.

Computer Literacy: Ability to function in a multi-system Microsoft environment using Word, Outlook, TriWest Intranet, the Internet, and department software applications.

Coping / Flexibility: Resiliency in adapting to a variety of situations and individuals while maintaining a sense of purpose and mature problem-solving approach is required.

Information Management: Ability to manage large amounts of complex information easily, communicates clearly, and draws sound conclusions.

High Intensity Environment: Ability to function in a fast-paced environment with multiple activities occurring simultaneously while maintaining focus and control of workflow.

Multi-Tasking / Time Management: Prioritize and manage actions to meet changing deadlines and requirements within a high volume, high stress environment.

Organizational Skills: Ability to organize people or tasks, adjust to priorities, learn systems, within time constraints and with available resources; Detail-oriented.

Problem Solving / Analysis: Ability to solve problems through systematic analysis of processes with sound judgment; has a realistic understanding of relevant issues.

Technical Skills: Strong knowledge of data warehouse design; data modeling; proficiency with SQL; strong experience with data extraction, transformation, and loading (ETL); working knowledge of report and dashboard development; strong knowledge of SQL Server / Snowflake databases; working knowledge of Oracle databases.

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
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.

DoD Statement

Our Department of Defense contract requires US citizenship and a favorably adjudicated DOD background investigation for this position.

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
  • 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

TriWest job postings typically include a salary range, which can vary based on the specific role and location, but generally this position ranges from around $135,000 - $144,000 per year.

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 supports diversity at every organizational level, and we highly encourage candidates from all backgrounds to apply. Applicants are considered for positions based on merit and 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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Analyst-Training
Data Analyst-Training

TriWest Healthcare Alliance • Phoenix (AZ)

Remote
USD 73,000 - 77,000
Medical, Dental and Vision Coverage
Paid time off
401(k) Retirement Savings Plan (with‑匹
Healthcare Operations Specialist-CO, KS, MT, ND, NE, NM OK and TX
Healthcare Operations Specialist-CO, KS, MT, ND, NE, NM OK and TX

TriWest Healthcare Alliance Corp. • Houston (TX)

Remote
USD 42,000 - 45,000
Medical, Dental and Vision Coverage
Paid time off
401(k) Retirement Savings Plan
+3
Healthcare Operations Specialist-DC, FL, MD, NC, TN, SC and VA
Healthcare Operations Specialist-DC, FL, MD, NC, TN, SC and VA

TriWest Healthcare Alliance Corp. • Charlotte (NC)

Remote
USD 41,000 - 45,000
Healthcare Operations Specialist (AR, IA, IL, MN, MO, LA, WI)
Healthcare Operations Specialist (AR, IA, IL, MN, MO, LA, WI)

TriWest Healthcare Alliance Corp. • Chicago (IL)

Remote
USD 40,000 - 45,000
Medical/Dental/Vision
401(k) Matching
Paid Time Off
+1
Healthcare Operations Specialist- HI
Healthcare Operations Specialist- HI

TriWest Healthcare Alliance Corp. • Honolulu (HI)

Remote
USD 46,000 - 48,000
Medical, Dental and Vision Coverage
Paid time off
401(k) Retirement Savings Plan
+4
Workforce Analyst Sr - TRICARE
Workforce Analyst Sr - TRICARE

TriWest Healthcare Alliance • Phoenix (AZ)

Remote
USD 68,000 - 75,000
Medical, Dental and Vision Coverage
401(k) Retirement Savings Plan (with""
Paid time off
+1
TRICARE Customer Service Rep
TRICARE Customer Service Rep

TriWest Healthcare Alliance • Phoenix (AZ)

Remote
USD 39,000 - 44,000
Medical, Dental and Vision Coverage
Paid time off
401(k) Retirement Savings Plan (with  
+1
Senior Human Capital Generalist
Senior Human Capital Generalist

TriWest Healthcare Alliance • Phoenix (AZ)

On-site
USD 101,000 - 107,000
Medical coverage
401(k) with match
Paid time off
+2
Referral Specialist
Referral Specialist

TriWest Healthcare Alliance Corp. • Phoenix (AZ)

Remote
USD 38,000 - 45,000
Medical coverage
Dental coverage
Vision coverage
+3
Healthcare Counsel
Healthcare Counsel

TriWest Healthcare Alliance • Phoenix (AZ)

Remote
USD 142,000 - 149,000
Medical, dental and vision coverage
Paid time off
401(k) Retirement Savings Plan