1 month ago
Westerville, OH, USASenior
Responsibilities
- Design, build, maintain, and optimize scalable ETL/ELT pipelines using Matillion on AWS and Snowflake.
- Develop, certify, document, and publish reusable Data Products through the enterprise Data Marketplace.
- Create and optimize Snowflake warehouses, schemas, tables, views, streams, tasks, and stored procedures.
- Improve Snowflake performance through clustering, caching, micro-partitioning, and resource monitoring.
- Define and enforce data contracts, SLAs, data quality standards, validation checks, profiling, and governance policies.
- Implement data cataloging, metadata management, naming standards, access policies, and end-to-end lineage tracking.
- Collaborate with analysts, data scientists, AI/ML teams, product teams, governance teams, and business stakeholders.
- Lead code reviews, mentor engineers, contribute to architecture decisions, and support strategic data roadmap planning.
- Build deployment automation, reusable ETL frameworks, monitoring, alerting, quality gates, and Data Product certification workflows.
Requirements
- At least 5 years of experience as a Data Engineer or in a similar role.
- Strong expertise with Snowflake, including SQL, performance tuning, data modeling, warehouse configuration, streams, and tasks.
- Hands-on experience with Matillion on AWS or comparable tools such as Talend, Informatica, dbt, or Azure Data Factory.
- Strong understanding of Data Products, Data Marketplaces, data contracts, data-as-a-product, and self-service data consumption.
- Advanced SQL skills, including writing complex queries and optimizing query performance.
- Knowledge of dimensional modeling, star schemas, data warehouses, data lakes, and bronze/silver/gold architectures.
- Experience with AWS and proficiency in Python, Airflow, or other orchestration tools.
- Familiarity with Git, CI/CD, DevOps practices, data governance, metadata management, and data cataloging tools.
- Preferred experience includes enterprise Data Marketplaces or Data Catalogs, data mesh, near-real-time ingestion, OpenFlow, Kafka, CDC, AI/ML data preparation, data lineage, and impact analysis tooling.
- Experience with Oracle Business Applications, ERP, or EBS as source systems is a plus.
Tech Stack
Categories
Data Engineering
About Vertiv
Vertiv builds power, cooling, and IT infrastructure for data centers, communication networks, and industrial facilities, sold as hardware, software, and services. Its portfolio spans UPS systems, thermal management, racks, prefabricated modules, and monitoring/management software, backed by global field service and commissioning. Headquartered in Columbus, Ohio, Vertiv was formed from Emerson Network Power and became a publicly traded company on the NYSE.