Profile
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 & 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 Data Modeler will be responsible for developing logical and physical data models, in Traditional Data Stores (MSSQL, Oracle) and NoSQL (Snowflake). The role will develop, test and implement scripts, programs, and related processes to collect, manage, publish metadata from data models. The data modeler will work closely with architects, developers and other data consumers to understand their needs and create appropriate data models.
Education & Experience
Required:
- Bachelor's Degree in computer science, information technology or a similar field, or equivalent work experience
- 3 Years of hands on data modeling
- Experience with metadata management and related tools
- Experience with relational, dimensional, and NoSQL data modeling
- Experience with data management standards and data model practices
- Experience with physical data structures in MSSQL, Oracle and Snowflake using Erwin
- Experience with SDLC and DevOps
Preferred
- Knowledge of Healthcare Industry and Healthcare Data files
- Knowledge of mathematical foundations and statistical analysis
- Strong interpersonal skills
- Experience with team management
- Excellent communication and presentation skills
- Advanced troubleshooting skills
Key Responsibilities
- Analyzing and translating business needs into long-term solution data models.
- Evaluating existing data systems.
- Working with the development team to create conceptual data models and data flows.
- Developing best practices for data coding to ensure consistency within the system.
- Reviewing modifications of existing systems for cross-compatibility.
- Implementing data strategies and developing physical data models.
- Updating and optimizing local and metadata models.
- Evaluating implemented data systems for variances, discrepancies, and efficiency.
- Troubleshooting and optimizing data systems.
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; 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 or remote, 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.
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, Washington D.C. and Washington State residents: $103,000 - $114,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.
