Note: The job is a remote job and is open to candidates in USA. TriWest Healthcare Alliance is a healthcare company dedicated to connecting America’s heroes with community health care. The Senior Data Engineer will design and develop ETL solutions across the full systems development life cycle, moving data from source feeds to target systems such as SQL Server and Snowflake using Databricks. The role also involves data analysis, collaboration with architects and cross-functional teams, implementation, and post-implementation support.
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
Skills
- 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
- 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
Benefits
- Remote work opportunities (AK, AR, AZ, CO, FL, HI, IA, ID, IL, KS, LA, MD, MN, MO, MT, NE, NV, NM, NC, ND, OK, OR, SC, SD, TN, TX, UT, VA/DC, WA, WI & WY only).
- Frequent pay raises may be considered for eligible employees.
- Overtime opportunities to earn even more.
- Recognition and reward programs.
- 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
Company Overview