Job Information
TRIWEST HEALTHCARE ALLIANCE CORP Data Engineer Senior in PHOENIX, Arizona
We offer remote work opportunities (AK, AR, AZ, CA, *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 and WY only).
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 and 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 eadlines 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
Annual base salary for Colorado, Hawaii, Washington D.C. and Washington State residents: $138,000 - $177,000 depending on experience