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
