IT Data Analytics Specialist - Data Engineer

Vertiv is seeking an IT Data Analytics Specialist and Data Engineer to design, build, and optimize scalable data pipelines in support of a governed Data Marketplace. The role emphasizes certified, reusable Data Products delivered through Snowflake and Matillion on AWS, with strong focus on governance, automation, and pipeline reliability.

Responsibilities

• Design, build, and maintain scalable ETL/ELT pipelines using Matillion on AWS to ingest, transform, and curate data across Snowflake layers: raw/staging, silver (cleansed and conformed), and gold (business-ready and aggregated).
• Develop and publish certified Data Products that are governed, documented, reusable, and made available through the Data Marketplace for self-service use by analysts, data scientists, and business stakeholders.
• Develop and optimize Snowflake objects including warehouses, schemas, tables, views, streams, tasks, and stored procedures to support Data Product pipelines.
• Improve Snowflake performance using clustering, caching, micro-partitioning, and resource monitoring to ensure reliable and fast Data Product delivery.
• Support the design and population of the Data Marketplace by ensuring Data Products are cataloged, discoverable, and compliant with enterprise data governance requirements.
• 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 within ETL pipelines to maintain Data Product integrity.
• Collaborate with data governance teams to implement naming standards, lineage tracking, metadata management, and access policies for Data Products.
• Ensure end-to-end data lineage is traceable from source systems through bronze/silver/gold layers to the final Data Product.
• Work with data analysts, data scientists, AI/ML teams, product teams, and business stakeholders to translate requirements into well-defined Data Products.
• Partner with the Data Marketplace product owner to define the Data Product lifecycle: creation, certification, publication, and deprecation.
• Lead code reviews, provide mentorship, and support engineering best practices.
• Contribute to architectural decisions and participate in strategic data roadmap planning.
• Build CI/CD pipelines for Matillion job deployments and Snowflake object management.
• Create reusable ETL frameworks, templates, and patterns to speed up new Data Product delivery.
• Implement monitoring, alerting, and operational excellence practices for pipeline health and Data Product operations.
• Automate Data Product certification workflows, including quality gates and approval processes.

Requirements

• 5+ years of experience as a Data Engineer or in a similar role.
• Strong expertise in Snowflake, including SQL, performance tuning, data modeling, warehouse configuration, streams, and tasks.
• Hands-on experience with Matillion on AWS (or comparable ETL/ELT tools such as Talend, Informatica, dbt, or Azure Data Factory).
• Solid understanding of Data Product and Data Marketplace concepts, including data contracts, data-as-a-product, and self-service data consumption.
• Advanced SQL skills, including complex query writing and optimization.
• Strong understanding of data modeling and warehouse/lake concepts, including dimensional models, star schemas, and bronze/silver/gold architecture.
• Experience with AWS.
• Proficiency in Python and/or 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.

Technologies

• Snowflake, SQL, Matillion, AWS
• Talend, Informatica, dbt, Azure Data Factory
• Python, Airflow, Git, CI/CD

Preferred Qualifications

• 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 such as OpenFlow, Kafka, or CDC.
• Exposure to AI/ML data preparation and delivering AI-enabled datasets.
• Experience with data lineage and impact analysis tooling.

Location and Experience

• Location: Westerville, OH (onsite)
• Minimum Experience: 5 years