Senior Consultant - ServiceNow

Job Description

As a Senior Consultant - ServiceNow, you'll play a pivotal role in transforming our ability to develop life-changing medicines. This position focuses on developing and maintaining comprehensive ServiceNow reports and dashboards across multiple modules, such as ITSM and HRSD. you'll create a variety of reports, leverage performance analytics to build KPIs, and ensure data accuracy and compliance. Your responsibilities will include automating report schedules, transforming ServiceNow data using REST APIs, and collaborating with various teams to refine reporting needs. Additionally, you'll implement standard methodologies for data design in Snowflake, develop ETL/ELT processes, and collaborate with stakeholders to define data strategies. If you have expertise in ServiceNow, SQL, data warehousing, and familiarity with cloud platforms, this is the opportunity for you Accountabilities: Develop and maintain ServiceNow reports and dashboards across various modules (ITSM, HRSD, CSM, SecOps, etc). Create and optimize List, Pie, Bar, Heatmaps, Trend Charts, and Pivot Reports for actionable insights. Use Performance/platform Analytics to build KPIs, scorecards, and trend reports. Implement user experience analytics and Self-Service Analytics. Ensure report accuracy, optimization, and compliance with business and security requirements. Automate and schedule reports to ensure timely data delivery for stakeholders. Extract and transform ServiceNow data using REST APIs and database queries. Collaborate with ServiceNow administrators, developers, and business teams to gather and refine reporting requirements. Develop custom scripts and indicators to enhance analytics capabilities. Provide end-user training and documentation for report generation and dashboard usage. Implement standard methodologies for database design, performance tuning, and querying in Snowflake. Develop ETL/ELT processes to ensure seamless data integration from various sources into Snowflake (not limited to Power BI). Create and maintain documentation for data pipelines, data modeling, and data integration processes. Monitor and optimize the performance of Snowflake instances and fix any issues that arise. Collaborate with data architects, data scientists, and business stakeholders to gather/document the requirements and define data strategies. Collaborate with the product owner to review and document access permissions for Snowflake, as we'll as the associated reports and dashboards. Essential Skills/Experience: 3+ years of hands-on experience in ServiceNow Reporting & Dashboards Proficiency in Platform/Performance Analytics and MetricBase Knowledge in SQL query to extract data from Snowflake. Experience with Filters, Data Sources, and Scheduled Reports Solid understanding of ServiceNow Tables, Query Builder, and Data Schema Experience with REST APIs for data extraction and integration Basic JavaScript & Glide APIs experience for custom reporting (preferred) Experience integrating ServiceNow reports with BI tools (Power BI, Tableau, etc) Solid understanding of data warehousing concepts and standard methodologies. Proficient in SQL for data manipulation and querying. Experience with ETL/ELT tools and processes. Familiarity with cloud platforms such as AWS, Azure, or Google Cloud is a plus