Data Integrity Engineer Jobs in Illinois (NOW HIRING)

We offer 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).
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 Salesforce HealthCloud Data Engineer is responsible for the design and development of ETL jobs and related data integrations supporting TriWest's Salesforce HealthCloud implementation. The role spans the full systems development life cycle (SDLC) including requirements gathering, data analysis, system design, development, implementation, and post-implementation support. During the design phase, the role works closely with Salesforce Architects and various Application Development teams. The engineer is responsible for the bidirectional ETL movement of data to and from originating source feeds (files, x12, etc.) to target systems using Salesforce Data Loader and Azure Tools.
This role operates under general supervision with significant latitude for independent action, applying advanced knowledge of data engineering principles, Salesforce HealthCloud platform integration, and healthcare data interoperability. The role engages regularly with Application Development teams, Salesforce Architects, Data Architects, business analysts, project managers, and end users on integration design and reporting needs. Decisions are guided by established enterprise architecture standards and TriWest HIPAA, privacy, and federal security policies, with escalation to the Manager, Business Applications on matters affecting platform strategy or cross-departmental dependencies. Work is performed in a federal healthcare contracting environment requiring compliance with HIPAA, DoD, and TriWest data security standards.
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 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 Databricks, preferably within Azure Cloud
• Experience with Python
• Experience with Data Governance
• Experience with Azure Data Factory or Microsoft SSIS data integration services
• Experience with SQL Server and Snowflake in Azure Cloud
Key Responsibilities
• Collaborates with Salesforce Architects to create conceptual, logical, and physical data models for Salesforce data repositories to ensure alignment with defined solution architecture.
• Promotes and ensures data integrity and accuracy within the Salesforce HealthCloud application.
• Ingests, validates, and processes incoming data. Applies business rules utilizing application development and integration within Salesforce. Performs data conversions, creates data backloads, and creates outgoing data files.
• Develops and coordinates unit and integration test plans. Prepares or obtains test data. Conducts testing. Evaluates test results and defect logs and provides necessary code revisions.
• Analyzes, designs, and develops code in support of Salesforce data integration activities with third-party applications and vendors, including coordination with API development teams and other application developers.
• Implements changes and provides post-implementation user support and system support.
• Identifies and advocates beneficial change opportunities. Provides data-driven insights and recommendations.
• Evaluates and determines root cause and resolves critical data issues.
• Acts as an IT technical resource for application developers, data administrators, and department data users.
• Supports data collection and analysis of business needs, translating them into technical requirements.
• 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; adapts to different styles, listens critically, and collaborates effectively across technical and business teams.
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.
Independent Thinking / Self-Initiative: Critical thinker with the ability to focus on what matters most to achieving outcomes. Commitment to task completion to produce outcomes without direction and to find necessary resources.
Information Management: Ability to manage large amounts of complex information easily, communicate clearly, and draw 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 and identifies root causes of complex data and integration problems.
Technical Skills: Strong knowledge of data warehouse design, data modeling, and SQL proficiency. Strong experience with data extraction, transformation, and loading (ETL). Working knowledge of report and dashboard development. Strong knowledge of SQL Server and working knowledge of Azure environment and services. Demonstrated ability to design and implement data integrations within the Salesforce HealthCloud platform.
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.
• Remote work eligible per TriWest telecommuting policy with periodic office attendance as needed.
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 $137,000 - $152,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.