Senior Data Engineer POST NUMBER: 448081
Location: 5 days on-site in Irvine, CA
Duration: Direct-Hire Opportunity
About the Role:
We're looking for a Data Engineer who is equal parts builder and strategist, someone who can architect, optimize, and explain data flows with confidence. In this role, you’ll develop scalable data pipelines using Snowflake and Matillion (or comparable tools), contribute to data modeling, and apply best practices across the data lifecycle.
This is your opportunity to turn raw data into trusted, intelligent insights and to be a key contributor in a growing, high-impact analytics function.
What You’ll Be Doing
-
Collaborate closely with Product Owners, Business Analysts, and Architects to translate user stories into effective and efficient data solutions.
-
Design and implement scalable ETL/ELT pipelines using Matillion (or similar tools) and Snowflake, moving data from diverse sources into staging, warehouse, and reporting layers.
-
Apply methodological thinking to pipeline development, explaining not just what you’re doing, but why it’s the right solution for performance, maintainability, and scalability.
-
Write optimized SQL queries and stored procedures to transform raw data into trusted assets.
-
Contribute to data modeling, helping design both normalized and denormalized structures tailored to business needs.
-
Build reusable components for robust and recoverable data pipelines, logging, error handling, and fault tolerance included.
-
Partner with cross-functional stakeholders to communicate complex data flows in simple terms, and provide strategic input on data architecture decisions.
-
Improve continuously refining development patterns, advocating for best practices, and supporting an evolving data engineering roadmap.
What You Bring
-
3 years of hands-on experience with Snowflake.
-
Strong SQL development skills with demonstrated success in ETL/ELT pipeline design.
-
Experience working in both OLTP and dimensional (data warehouse) environments.
-
Experience using Matillion or similar tools (e.g., dbt, SSIS, Talend, Informatica).
-
Strong understanding of data engineering methodologies and best practices and the ability to explain technical decisions clearly.
-
Experience working in Agile development teams and using version control (Bitbucket/GitHub).
-
Exceptional communication skills able to interface with technical and non-technical stakeholders alike.
Preferred:
-
Integration experience with APIs and external vendor datasets.
-
Python scripting skills for data transformation or orchestration.
-
Background in performance tuning and query optimization in large datasets.
-
Experience with Microsoft SSIS and familiarity with CI/CD data deployment pipelines.
Who You Are
-
You don’t just code, you engineer with intent and purpose.
-
You have a consultative mindset and love helping others understand how data works under the hood.
-
You balance speed with scalability and always have an eye on long-term maintainability.
-
You bring clarity to complexity and aren’t afraid to challenge assumptions.
-
You’re detail-oriented, analytical, and deeply curious about what makes data systems efficient and impactful.
Determining compensation for this role (and others) at Vaco/Highspring depends upon a wide array of factors including but not limited to the individual’s skill sets, experience and training, licensure and certifications, office location and other geographic considerations, as well as other business and organizational needs. With that said, as required by local law in geographies that require salary range disclosure, Vaco/Highspring notes the salary range for the role is noted in this job posting. The individual may also be eligible for discretionary bonuses, and can participate in medical, dental, and vision benefits as well as the company’s 401(k) retirement plan.
Vaco by Highspring values a diverse workplace and strongly encourages women, people of color, LGBTQ+ individuals, people with disabilities, members of ethnic minorities, foreign-born residents, and veterans to apply.
EEO Notice
Vaco by Highspring is an Equal Opportunity Employer and does not discriminate against any employee or applicant for employment because of race (including but not limited to traits historically associated with race such as hair texture and hair style), color, sex (includes pregnancy or related conditions), religion or creed, national origin, citizenship, age, disability, status as a veteran, union membership, ethnicity, gender, gender identity, gender expression, sexual orientation, marital status, political affiliation, or any other protected characteristics as required by federal, state or local law.
Vaco by Highspring and its parents, affiliates, and subsidiaries are committed to the full inclusion of all qualified individuals. As part of this commitment, Vaco by Highspring and its parents, affiliates, and subsidiaries will ensure that persons with disabilities are provided reasonable accommodations. If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact HR@vaco.com .
Vaco by Highspring also wants all applicants to know their rights that workplace discrimination is illegal.
By submitting to this position, you agree that you will be giving Vaco by Highspring the exclusive right to present your as a candidate for the foregoing employment opportunity. You further agree that you have represented information about yourself accurately and have not affirmatively misrepresented your qualifications. You also agree to maintain as confidential, to the fullest extent permitted by law, any information you learn from Vaco by Highspring about the position and you will limit disclosure of information about the position only to the extent necessary to perform any obligations in furtherance of your application. In exchange, Vaco by Highspring agrees to exercise reasonable efforts to represent you through all solicitation, job screening and resume dispersal.
Privacy Notice
Vaco by Highspring and its parents, affiliates, and subsidiaries (“we,” “our,” or “Vaco by Highspring”) respects your privacy and are committed to providing transparent notice of our policies.
- California residents may access Vaco by Highspring HR Notice at Collection for California Applicants and Employees here.
- Virginia residents may access our state specific policies here.
- Residents of all other states may access our policies here.
- Canadian residents may access our policies in English here and in French here.
- Residents of countries governed by GDPR may access our policies here.
Pay Transparency Notice
Determining compensation for this role (and others) at Vaco by Highspring depends upon a wide array of factors including but not limited to:
- the individual’s skill sets, experience and training;
- licensure and certification requirements;
- office location and other geographic considerations;
- other business and organizational needs.
With that said, as required by local law, Vaco by Highspring believes that the following salary range referenced above reasonably estimates the base compensation for an individual hired into this position in geographies that require salary range disclosure. The individual may also be eligible for discretionary bonuses.