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. 

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.