Senior Data Engineer

VSP Vision Care

United States

Hybrid

USD 84,000 - 142,000

Full time

19 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

VSP Vision Care is seeking a Senior Data Engineer to design, build, and optimize data pipelines that power analytics enterprise-wide. You will work with analytics, warehousing staff, DBAs and SMEs to ensure reliable, high-quality data loading and availability for business insights.

The role requires strongSQL, data modeling and experience with ETL/ELT, data virtualization, and modern data prep tools. Collaboration in agile teams and emphasis on data quality are essential.

Qualifications

  • Bachelor’s degree in computer science, data science, statistics, economics or related area; or equivalent experience.
  • Excellent written and verbal communication skills to gather requirements and communicate technical concepts to all levels.
  • 6+ years’ experience in development teams delivering analytical capabilities.
  • 6+ years’ hands-on experience in data space including data prep, SQL, integration tools, ETL/ELT and data pipelines.
  • Strong SQL coding experience.
  • Experience in agile development (Scrum/Kanban) focused on CI/CD.

Responsibilities

  • Design, build, maintain and operationalize data pipelines for high-volume data with integrity and quality.
  • Collaborate in an agile team to deliver data integration and transformation solutions.
  • Develop data mappings, programs and SQL to acquire data from legacy, web, cloud and bought packages.
  • Apply ELT/ETL, data virtualization and related methods for performance and minimal data movement.
  • Automate data pipeline prep and integration tasks using modern tools and metadata management.
  • Monitor data quality using auditing facilities and define transformation rules.
  • Participate in architecture reviews, governance and design discussions.

Skills

Data pipelines
ETL/ELT
SQL
Data warehousing
Agile
Data quality

Education

Bachelor’s degree in CS/DS/Statistics or related field

Tools

IBM InfoSphere DataStage
Oracle Data Integrator
Informatica PowerCenter
MS SSIS
AWS Glue
Denodo
Snowflake
Kafka/Confluent
Airflow
Jenkins
GitHub

Job description

Job Specifications

The Senior Data Engineer designs, builds and optimizes data pipelines for key data and analytics capabilities in the enterprise. This position works in collaboration with analytics and data warehousing staff, DBAs and subject matter experts to create reliable processes that load targeted data with integrity and quality, enabling it for strategic use by the business.


Collaborate within an agile, multi-disciplinary team to deliver optimal data integration and transformation solutions


Analyze data requirements (functional and non-functional) to develop and design robust scalable automated, fault-tolerant data pipeline solutions for business and technology initiatives


Profile data to assess the accuracy and completeness of data sources and provide feedback in data gathering sessions


Design, build, maintain and operationalize data pipelines for high volume and complex data using appropriate tools and practices in development, test and production environments


Design with modularity to leverage reuse of code wherever possible


Develop and design data mappings, programs, routines and SQL to acquire data from legacy, web, cloud and purchased package environments into the analytics environment


Understand and apply the appropriate use of ELT, ETL, data virtualization and other methods to optimize the balance of minimal data movement against performance, and mentor others on their appropriate use


Drive automation of data pipeline preparation and integration tasks to minimize manual and error-prone processes and improve productivity using modern data preparation, integration and AI-enabled metadata management tools and techniques


Leverage auditing facilities that will enable monitoring of data quality to detect emerging issues


Deploy transformation rules to cleanse against defined rules and standards


Participate in architecture, governance and design reviews, identifying opportunities and making recommendations


Participate in health check assessments of the existing environment and evaluations of emerging technologies


Collaborate with architects to design and model application data structures, storage and integration in accordance with enterprise-wide architecture standards across legacy, web, cloud and purchased package environments


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 in development team providing analytical capabilities


6+ years of hands‑on experience in the data space spanning data preparation, SQL, integration tools, ETL/ELT / data pipeline design


SQL coding experience


Experience working in an agile development environment (Scrum, Kanban) with a focus on Continuous Integration and Delivery


Knowledge about various data architectures, patterns and capabilities such as event-driven architecture, real-time data flows, non-relational repositories, data virtualization, cloud storage, etc.


Knowledge of and experience with multiple data integration platforms (IBM InfoSphere DataStage, Oracle Data Integrator, Informatica PowerCenter, MS SSIS, AWS Glue, Denodo), and data warehouse MPP platforms such Snowflake, Netezza, Teradata, Redshift, etc.


Familiarity with DataOps practices and their application within analytics environments as well as their ability to extend data and analytics capabilities to other operational systems and consumers


Familiarity with event store and stream processing (Apache Kafka and platforms like Confluent) and with API development and management platforms (MuleSoft, Axway) is beneficial


Capable of focusing on a specific set of tasks while also ensuring alignment to a broader strategic design


For roles that are remote (i.e., Work From Home (WFH)) or hybrid (i.e., partial onsite at a VSP location and WFH), must demonstrate a high level of engagement in virtual environments, including maintaining camera presence during meetings to support effective communication and team alignment


Preferred Skills

Snowflake Certification/Strong hands‑on experience with Snowflake (data modeling, performance tuning, security, optimization and architecture


Experience with DataStage (ETL development and maintenance)


Understanding the concept of Data Vault modeling


Experience with workflow orchestration tools such as Apache Airflow or Jenkins


Proficiency with GitHub (version control, branching strategies, code reviews, CI/CD integration)


Experience building and maintaining ETL/ELT pipelines


Strong SQL and data transformation skills


Familiarity with cloud platforms (AWS/Azure/GCP)


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.


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.


As a regular part of doing business, VSPVision (\"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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Engineer
Senior Data Engineer

VSP Vision • United States

Hybrid
USD 84,000 - 142,000
Bonus eligibility
Commissions
Senior Data Engineer
Senior Data Engineer

VSP • California

Hybrid
USD 84,000 - 142,000
Senior Data Engineer
Senior Data Engineer

VSP • United States

Remote
USD 84,000 - 142,000
Senior Data Scientist/AI Application Solutions Engineer
Senior Data Scientist/AI Application Solutions Engineer

VSP Vision Care • United States

Remote
USD 84,000 - 142,000
Manager, Analytics
Manager, Analytics

VSP Vision Care • United States

Hybrid
USD 74,000 - 131,000
Manager, Analytics
Manager, Analytics

VSP Vision • Rancho Cordova (CA)

On-site
USD 74,000 - 131,000
Senior Data Scientist/AI Application Solutions Engineer
Senior Data Scientist/AI Application Solutions Engineer

VSP • California

Hybrid
USD 84,000 - 142,000
Principal Business Data Analyst
Principal Business Data Analyst

Vrijwilligers Service Punt • United States

Hybrid
USD 84,000 - 142,000
Bonus potential
Commission opportunities
Principal Business Data Analyst
Principal Business Data Analyst

VSP • California

Hybrid
USD 84,000 - 142,000
Director, AI Platforms & Engineering
Director, AI Platforms & Engineering

VSP Vision Care • United States

Hybrid
USD 105,000 - 165,000