IT Data Analytics Specialist - Data Engineer
Vertiv
Get a reply from this employer
Your resume and cover letter, tailored to exactly what they’re hiring for.
Job summary
Vertiv is seeking a Data Product Engineer in Westerville, OH to design, build, and optimize data pipelines feeding the Data Marketplace. You will publish certified Data Products and collaborate with analysts, data scientists, and business teams to enable self-service data consumption.
The role requires strong Snowflake and Matillion expertise, along with SQL, Python, and AWS. You will contribute to governance, data contracts, and end-to-end data lineage.
Qualifications
- 5+ years of experience as a Data Engineer or similar role.
- Strong expertise with Snowflake (SQL, performance tuning, data modeling).
- Hands-on experience with Matillion on AWS (or comparable ETL/ELT tools).
- Solid understanding of Data Product and Data Marketplace concepts (data contracts, data‑as‑a‑product).
- Advanced SQL skills; ability to write complex queries and optimize them.
- Strong understanding of data modeling, dimensional models, star schemas, and data warehouse/lake concepts.
- Experience with cloud platforms, specifically AWS.
- Experience with Oracle Business Applications (ERP/EBS) as source systems is a plus.
- Proficiency in Python, Airflow, or other orchestration tools.
- Familiarity with Git, CI/CD, and DevOps practices.
- Knowledge of data governance principles, metadata management, and data cataloging tools.
Responsibilities
- Design, build, and maintain scalable ETL/ELT pipelines using Matillion on AWS to ingest, transform, and curate data across raw/staging, silver, and gold layers in Snowflake.
- Develop and publish certified Data Products — governed, documented, and reusable datasets via the Data Marketplace for self-service consumption.
- Develop and optimize Snowflake objects including warehouses, schemas, tables, views, streams, tasks, and stored procedures.
- Optimize Snowflake performance through clustering, caching, micro-partitioning, and resource monitoring.
Skills
Tools
Job description
We are seeking a highly skilled Data Product's Engineer with deep expertise in Snowflake and strong hands‑on experience with Matillion on AWS. The ideal candidate will design, build, and optimize scalable data pipelines that feed our Data Marketplace and enable the creation, publication, and consumption of certified Data Products across the enterprise.
We are seeking a highly skilled Data Product's Engineer with deep expertise in Snowflake and strong hands‑on experience with Matillion on AWS. The ideal candidate will design, build, and optimize scalable data pipelines that feed our Data Marketplace and enable the creation, publication, and consumption of certified Data Products across the enterprise.
- Design, build, and maintain scalable ETL/ELT pipelines using Matillion on AWS to ingest, transform, and curate data across incoming (raw/staging), silver (cleansed & conformed), and gold (business‑ready/aggregated) layers in Snowflake.
- Develop and publish certified Data Products — governed, documented, and reusable datasets made available through the Data Marketplace for self‑service consumption by analysts, data scientists, and business users.
- Develop and optimize Snowflake objects including warehouses, schemas, tables, views, streams, tasks, and stored procedures to support Data Product pipelines.
- Optimize Snowflake performance through clustering, caching, micro‑partitioning, and resource monitoring to ensure Data Products are delivered with reliability and speed.
- Support the design and population of the Data Marketplace, ensuring Data Products are cataloged, discoverable, and compliant with enterprise data governance standards.
- Define and enforce data contracts, SLAs, and quality standards for each Data Product published to the Marketplace.
- Define and automate data validation, profiling, and quality checks embedded within ETL pipelines to guarantee Data Product integrity.
- Collaborate with data governance teams to implement naming standards, lineage tracking, metadata management, and access policies for Data Products.
- Ensure data lineage is traceable end‑to‑end from source systems through bronze/silver/gold layers to the final Data Product.
- Work closely with data analysts, data scientists, AI/ML teams, product teams, and business stakeholders to understand requirements and translate them into well‑defined Data Products.
- Partner with the Data Marketplace product owner to define the Data Product lifecycle (creation, certification, publication, deprecation).
- Lead code reviews, provide mentorship, and support best practices across the engineering team.
- Contribute to architectural decisions and participate in strategic data roadmap planning.
- Build CI/CD pipelines for Matillion job deployments and Snowflake object management.
- Develop reusable ETL frameworks, templates, and patterns to accelerate the creation of new Data Products.
- Implement monitoring, alerting, and operational excellence practices for data pipelines and Data Product health.
- Automate Data Product certification workflows, including quality gates and approval processes.
- 5+ years of experience as a Data Engineer or similar role.
- Strong expertise with Snowflake (SQL, performance tuning, data modeling, warehouse configuration, streams, tasks).
- Hands‑on experience with Matillion on AWS (or comparable ETL/ELT tools such as Talend, Informatica, dbt, Azure Data Factory).
- Solid understanding of Data Product and Data Marketplace concepts (data contracts, data‑as‑a‑product, self‑service data consumption).
- Advanced SQL skills; ability to write complex queries and optimize them.
- Strong understanding of data modeling, dimensional models, star schemas, and data warehouse/data lake concepts (bronze/silver/gold architecture).
- Experience with cloud platforms, specifically AWS.
- Experience with Oracle Business Applications (ERP/EBS) as source systems is a plus.
- Proficiency in Python, Airflow, or other orchestration tools.
- Familiarity with Git, CI/CD, and general DevOps practices.
- Knowledge of data governance principles, metadata management, and data cataloging tools.
- Experience building or contributing to an enterprise Data Marketplace or Data Catalog.
- Familiarity with data mesh or data product thinking methodologies.
- Experience with near real‑time data ingestion tools (e.g., OpenFlow, Kafka, CDC).
- Exposure to AI/ML data preparation and delivering AI‑enabled datasets.
- Experience with data lineage and impact analysis tooling.
The successful candidate will embrace Vertiv’s Core Principles & Behaviors to help execute our Strategic Priorities.
OUR CORE PRINCIPLES: Safety. Integrity. Respect. Teamwork. Inclusion.
- High‑Performance Culture
- Customer Focus
- Operational Excellence
- Innovation
- Financial Strength
- Own it
- Act with urgency
- Foster a customer‑first mindset
- Think big and execute
- Lead by example
- Drive continuous improvement
- Learn and seek out development
- Promote transparent & open communication
Vertiv (NYSE: VRT) brings together hardware, software, analytics and ongoing services to enable its customers’ vital applications to run continuously, perform optimally and grow with their business needs. Vertiv solves the most important challenges facing today’s data centers, communication networks, and commercial and industrial facilities with a portfolio of power, cooling and IT infrastructure solutions and services that extend from the cloud to the edge of the network. Headquartered in Westerville, Ohio, USA, Vertiv employs around 34,000 people and does business in more than 130 countries. Visit Vertiv.com to learn more.
No calls or agencies please. Vertiv will only employ those who are legally authorized to work in the United States. This is not a position for which sponsorship will be provided. Individuals with temporary visas such as E, F-1, H-1, H-2, L, B, J, or TN or who need sponsorship for work authorization now or in the future, are not eligible for hire.
Vertiv is an Equal Opportunity/Affirmative Action employer. We promote equal opportunities for all with respect to hiring, terms of employment, mobility, training, compensation, and occupational health, without discrimination as to age, race, color, religion, creed, sex, pregnancy status (including childbirth, breastfeeding, or related medical conditions), marital status, sexual orientation, gender identity / expression (including transgender status or sexual stereotypes), genetic information, citizenship status, national origin, protected veteran status, political affiliation, or disability. If you have a disability and are having difficulty accessing or using this website to apply for a position, you can request help by sending an email to help.join@vertiv.com
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
