Overview
On Site
USD 138,000.00 - 154,000.00 per year
Full Time
Skills
Technical Support
Change data capture
DoD
Systems engineering
Requirements elicitation
Data Analysis
Systems design
ASC X12
Microsoft SQL Server
Business administration
Computer science
Database
Data engineering
Business requirements
Data governance
File formats
Transact-SQL
Project management
People skills
Computer literacy
Internet
Problem solving
Information management
Multitasking
Time management
Organizational skills
Attention to detail
Data warehouse
Data modeling
Data extraction
Health care
Data
Augmented reality
Information architecture
Marketing operations
SD
Military
Design
Extract
transform
load
Software development methodology
Snow flake schema
Mathematics
Software development
Microsoft Azure
Cloud computing
Python
DevOps
ANSI
JSON
Administration
Databricks
FOCUS
Mentorship
Reporting
Regulatory Compliance
HIPAA
Privacy
Policies
Communication
Collaboration
Microsoft
Microsoft Outlook
Intranet
Management
Workflow
SQL
Transformation
Dashboard
Oracle
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 strongly 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
5+ years of experience in a Data Engineering role
2+ years of experience with Data Bricks preferably within Azure Cloud
3+ years of experience with Python
3+ years of experience with Azure
Experience in gathering business requirements from cross functional teams
Experience with SDLC processes and DevOps
Preferred:
Experience with Data Governance
Experience with SQL Server and Snowflake in Azure Cloud
Experience in ETL with both structured and semi-structured data
Experience with x12 data file formats
Understanding of ANSI and T-SQL
Experience with data analysis in the healthcare industry
Experience with Event Hubs and Change Data Capture (JSON)
Experience with cloud administration in Azure (ADLS2, DataBricks, Event Hubs)
Experience in a team or project lead role, with a focus on mentoring
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
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 ship 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:
*Annual base salary for Colorado, Hawaii and Washington State residents: $138,000 - $154,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 strongly 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
5+ years of experience in a Data Engineering role
2+ years of experience with Data Bricks preferably within Azure Cloud
3+ years of experience with Python
3+ years of experience with Azure
Experience in gathering business requirements from cross functional teams
Experience with SDLC processes and DevOps
Preferred:
Experience with Data Governance
Experience with SQL Server and Snowflake in Azure Cloud
Experience in ETL with both structured and semi-structured data
Experience with x12 data file formats
Understanding of ANSI and T-SQL
Experience with data analysis in the healthcare industry
Experience with Event Hubs and Change Data Capture (JSON)
Experience with cloud administration in Azure (ADLS2, DataBricks, Event Hubs)
Experience in a team or project lead role, with a focus on mentoring
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
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 ship 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
- 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, Hawaii and Washington State residents: $138,000 - $154,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.