Senior Dimensional Data Modeler
The Sr. Data Solutions Engineer works directly with business stakeholders to design data and analytics capabilities that support business strategies and to develop the data models and structures that enable data-driven solutions. The Sr Data Solutions Engineer develops data models and structures that can be used within the business to find data driven solutions.
Work with business stakeholders to identify how data can be leveraged to improve decision making
Work with technology teams to analyze data requirements (functional and non-functional) and provide data architectural design solutions for business and technology initiatives
Assess the effectiveness and accuracy of data sources and data gathering techniques
Design data structures, data models and data pipelines, leveraging the support of subject matter experts to deliver business intelligence / data science capabilities for the organization
Create data models at all levels including conceptual, logical, and physical
Collaborate within an agile, multi-disciplinary team of data engineers, data analysts, UX designers and scrum master to deliver solution
Work with Data Scientists on optimizing batch and real-time processes for feature engineering, training models, and serving predictions Research, promote, and develop data architecture best practices, guidelines, procedures and scalable frameworks Participate in architecture, governance and design reviews
Participate in evaluations of existing and emerging analytical technologies and provide recommendations Job Specifications Typically has the following skills or abilities: Bachelor’s degree in computer science, data science, statistics, economics or related functional area; or equivalent experience
Excellent written and verbal communication skills with the ability to gather requirements and effectively communicate technical concepts and ideas to all levels of employees and management
6 years’ experience working with end users in development of analytical capabilities
6 years of hands-on experience in the data space spanning data modeling, SQL-based database management systems, integration, ETL/data pipeline design and data visualization
Expert level SQL coding experience
Preferred Skills
Expert dimensional modeling skills with an aptitude for translating business needs into solutions
Design fit-for-purpose models that balance performance, extensibility and maintainability
Expert level SQL skills & Python skills
Experience working in Snowflake or equivalent cloud warehouse environment
Preference for prior experience modeling in Data Vault 2.0
Prior experience using VaultSpeed
Experience using ER Studio or similar modeling environment
#LI-VISIONCARE
Compensation range for the role is listed below. Applicable salary ranges may differ across markets. Actual pay will be determined based on experience and other job-related factors permitted by law. As a part of the compensation package, this role may include eligible bonuses and commissions. For more information regarding VSP Vision benefits, please click here.
Salary Ranges: $84,000.00 - $141,750.00
VSP Vision is an equal opportunity employer and gives consideration for employment to qualified applicants without regard to age, gender, race, color, religion, sex, national origin, disability or protected veteran status. We maintain a drug-free workplace and perform pre-employment substance abuse testing.
Unincorporated LA County Residents: Qualified Applicants with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act, and any other similar laws.
Notice to Candidates: Fraud Alert - Fake Job Opportunity Solicitations Used to Collect Fees/Personal Information.
We have been made aware that fake job opportunities are being offered by individuals posing as VSP Vision and affiliate recruiters. Click here to learn about our application process and what to watch for regarding false job opportunities.
As a regular part of doing business, VSP Vision (“VSP”) collects many different types of personal information, including protected health information, about our audiences, including members, doctors, clients, brokers, business partners, and employees. VSP Vision employees will have access to this sensitive personal information and are subject to follow Information Security and Privacy Policies.
About the job
Apply for this position
Senior Dimensional Data Modeler
The Sr. Data Solutions Engineer works directly with business stakeholders to design data and analytics capabilities that support business strategies and to develop the data models and structures that enable data-driven solutions. The Sr Data Solutions Engineer develops data models and structures that can be used within the business to find data driven solutions.
Work with business stakeholders to identify how data can be leveraged to improve decision making
Work with technology teams to analyze data requirements (functional and non-functional) and provide data architectural design solutions for business and technology initiatives
Assess the effectiveness and accuracy of data sources and data gathering techniques
Design data structures, data models and data pipelines, leveraging the support of subject matter experts to deliver business intelligence / data science capabilities for the organization
Create data models at all levels including conceptual, logical, and physical
Collaborate within an agile, multi-disciplinary team of data engineers, data analysts, UX designers and scrum master to deliver solution
Work with Data Scientists on optimizing batch and real-time processes for feature engineering, training models, and serving predictions Research, promote, and develop data architecture best practices, guidelines, procedures and scalable frameworks Participate in architecture, governance and design reviews
Participate in evaluations of existing and emerging analytical technologies and provide recommendations Job Specifications Typically has the following skills or abilities: Bachelor’s degree in computer science, data science, statistics, economics or related functional area; or equivalent experience
Excellent written and verbal communication skills with the ability to gather requirements and effectively communicate technical concepts and ideas to all levels of employees and management
6 years’ experience working with end users in development of analytical capabilities
6 years of hands-on experience in the data space spanning data modeling, SQL-based database management systems, integration, ETL/data pipeline design and data visualization
Expert level SQL coding experience
Preferred Skills
Expert dimensional modeling skills with an aptitude for translating business needs into solutions
Design fit-for-purpose models that balance performance, extensibility and maintainability
Expert level SQL skills & Python skills
Experience working in Snowflake or equivalent cloud warehouse environment
Preference for prior experience modeling in Data Vault 2.0
Prior experience using VaultSpeed
Experience using ER Studio or similar modeling environment
#LI-VISIONCARE
Compensation range for the role is listed below. Applicable salary ranges may differ across markets. Actual pay will be determined based on experience and other job-related factors permitted by law. As a part of the compensation package, this role may include eligible bonuses and commissions. For more information regarding VSP Vision benefits, please click here.
Salary Ranges: $84,000.00 - $141,750.00
VSP Vision is an equal opportunity employer and gives consideration for employment to qualified applicants without regard to age, gender, race, color, religion, sex, national origin, disability or protected veteran status. We maintain a drug-free workplace and perform pre-employment substance abuse testing.
Unincorporated LA County Residents: Qualified Applicants with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act, and any other similar laws.
Notice to Candidates: Fraud Alert - Fake Job Opportunity Solicitations Used to Collect Fees/Personal Information.
We have been made aware that fake job opportunities are being offered by individuals posing as VSP Vision and affiliate recruiters. Click here to learn about our application process and what to watch for regarding false job opportunities.
As a regular part of doing business, VSP Vision (“VSP”) collects many different types of personal information, including protected health information, about our audiences, including members, doctors, clients, brokers, business partners, and employees. VSP Vision employees will have access to this sensitive personal information and are subject to follow Information Security and Privacy Policies.