Overview
On Site
USD 103,000.00 - 114,000.00 per year
Full Time
Skills
Computer science
Information Technology
Data modeling
Meta-data management
Data management
Data structure
Statistics
Team management
Data flow
Data engineering
Metadata modeling
People skills
Computer literacy
Internet
Problem solving
Information management
Multitasking
Time management
Organizational skills
Attention to detail
Data warehouse
Microsoft SQL Server
Health care
Data
Military
Augmented reality
Impact analysis
Marketing operations
SD
Oracle
NoSQL
Snow flake schema
Scripting
Management
ERwin
Software development methodology
DevOps
Communication
Presentations
Collaboration
Microsoft
Microsoft Outlook
Intranet
FOCUS
Workflow
Design
SQL
Reporting
Dashboard
Database
Value engineering
Teamwork
Insurance
Recruiting
SAP BASIS
Job Details
Veterans, Reservists, Guardsmen and military family members are encouraged to apply!!
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, TX, UT, VA/DC, *WA, WI & WY only)
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:
*Annual base salary for Colorado 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.
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, TX, UT, VA/DC, *WA, WI & WY only)
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 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.