Data Engineer

TriWest Healthcare Alliance connects America’s heroes with health care in the community. The Data Engineer designs and develops ETL solutions across the full systems development life cycle, moving data from source feeds to target systems using Databricks. The role also supports data modeling, implementation, system support, and collaboration with technical and business stakeholders.

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

Requirements:

• 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
• • 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. Citizen
• • Must be able to receive a favorable Interim and adjudicated final Department of Defense (DoD) background investigation
• • 3+ years' experience in a Data Engineering role
• • 1+ years' experience with Data Bricks preferably within Azure Cloud
• • Experience in gathering business requirements from cross functional teams
• • Experience with SDLC processes and DevOps
• Ability to influence or persuade others under positive or negative circumstances; adapt to different styles; listen critically; collaborate
• Ability to function in a multi-system Microsoft environment using Word, Outlook, TriWest Intranet, the Internet, and department software applications
• Resiliency in adapting to a variety of situations and individuals while maintaining a sense of purpose and mature problem-solving approach is required
• Ability to manage large amounts of complex information easily, communicates clearly, and draws sound conclusions
• Ability to function in a fast-paced environment with multiple activities occurring simultaneously while maintaining focus and control of workflow
• Prioritize and manage actions to meet changing deadlines and requirements within a high volume, high stress environment
• Ability to organize people or tasks, adjust to priorities, learn systems within time constraints and with available resources; detail-oriented
• Ability to solve problems through systematic analysis of processes with sound judgment; has a realistic understanding of relevant issues
• 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
• 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
• • 3+ years' experience in Healthcare provider data
• • 3+ years' experience with Profisee Master Data Management Software Experience with Data Governance
• • Experience with SQLServer and Snowflake in Azure Cloud
• • Experience in ETL with both structured and semi-structured data
• • Understanding of ANSI and T-SQL
• • Experience in a team or project lead role, with a focus on mentoring