Staff Site Reliability Engineer, Servicenow Cmdb

Visa Visa · Fintech · Denver, CO

Staff Site Reliability Engineer focused on the ServiceNow CMDB and ITOM Discovery platform, involving development, data management, and operational support. Responsibilities include enhancing ServiceNow features, designing and maintaining ETL solutions using Microsoft SSIS, ingesting and transforming data from various sources, writing SQL queries, ensuring data quality, and collaborating with stakeholders. The role also involves working with cloud discovery capabilities and educating users.

What you'd actually do

  1. Be part of a global team that has operational support responsibilities where you will be required to work with our internal customers to resolve issues using the ServiceNow Incident management process and ticketing system.
  2. Expand and enhance your knowledge of the ServiceNow Platform and its advanced features and capabilities including developing table / attribute level security controls, implementing Business Rules, Flow Designer, Workflows, Client Scripts, UI Policy, and UI Actions as part of development activities for Catalogs, Scoped Apps or other platform activities.
  3. Design, develop, and maintain ETL solutions using Microsoft SSIS to support data warehousing and business intelligence initiatives. Monitor, troubleshoot, and optimize existing SSIS packages and ETL jobs for performance and reliability.
  4. Ingest, transform, and load data from various sources including relational databases, flat files (CSV, TXT), REST APIs, and ODBC connections.
  5. Write and optimize complex SQL queries, stored procedures, triggers, and scripts for data extraction and transformation.

Skills

Required

  • ServiceNow platform development
  • CMDB
  • ITOM Discovery
  • ETL solutions
  • Microsoft SSIS
  • SQL (T-SQL)
  • data warehousing
  • data modeling
  • data governance
  • data quality
  • data security

Nice to have

  • ServiceNow Certified System Administrator
  • source control and deployment processes for SSIS projects
  • data profiling
  • data cleansing techniques
  • ODBC data sources
  • REST APIs (JSON, XML) integration
  • job scheduling
  • automation tools
  • workflow orchestration
  • metadata management
  • data lineage tracking

What the JD emphasized

  • 8+ years of hands-on ServiceNow development and CMDB experience, ETL solutions using Microsoft SSIS.