Responsibilities
- Build, optimize, and maintain ELT/ETL pipelines that ingest, clean, and organize operational data from ServiceNow, mainframe environments, distributed systems, and cloud platforms.
- Develop robust extraction, transformation, and ingestion patterns for ServiceNow operational data (incidents, alerts, changes, requests), ensuring it is reliable, well-modeled, and ready for AI/ML use cases.
- Design scalable data models, storage frameworks, and integration layers in Snowflake and related modern data platforms, with an emphasis on performance, reliability, and operational relevance.
- Implement data quality standards, monitoring, validation, and lineage to ensure pipelines produce clean, trustworthy, and auditable datasets.
- Partner with Data Scientists, ML Engineers, and MLOps to deliver and maintain production-grade feature pipelines, training datasets, and inference-ready data, supporting predictive models, anomaly detection, and intelligent runbooks.
- Support ML production workflows by enabling model registration, versioning, and lifecycle management within Snowflake, working alongside ML and MLOps teams (model development itself is not the primary responsibility of this role).
- Integrate Snowflake AI components, including Cortex LLMs, into data workflows for use cases such as enrichment, summarization, and operational intelligence.
- Identify opportunities to streamline data workflows, reduce manual intervention, and lower operational costs while improving reliability and scalability.
- Work with Finance, Procurement, Cloud Operations, Mainframe Operations, and Service Operations teams to ensure data products align with high-value business outcomes.
Requirements
- Strong SQL skills and solid data modeling fundamentals
- Expertise in ELT/ETL pipeline development and orchestration
- Python (required) plus experience with at least one of Java, Scala, or C++
- Hands-on experience with Snowflake or equivalent cloud data warehouse platforms
- Minimum of 2 years Snowflake experience required
- Proven experience extracting, transforming, and operationalizing data from ServiceNow and/or other enterprise operational systems (e.g., monitoring platforms, ITSM, finance, or HR systems such as Workday or Concur)
- Familiarity with observability tooling and distributed data systems
- Knowledge of enterprise data governance, compliance, and data lineage practices
- Experience supporting AI/ML feature pipelines in production environments
- 7+ years’ experience is required
Benefits
- Unlimited Paid Days Off
- Three health plan options
- 401k with company match
- Eligibility for dental, vision, short and long-term disability, life and AD&D coverage, and flexible spending accounts
- Family Forming Benefit including fertility coverage and adoption/surrogacy reimbursement
- Paid childbearing and paternal leave
- Education Reimbursement, Student Loan Assistance or 529 College Funding
- Sabbatical leave
- Wellness program
- Flexible work schedule
Work Arrangement
Hybrid
Additional Information
- Positions that are not required to be onsite to support a client may offer the ability to work remotely or hybrid at an Ensono office location.
