Senior Consultant - ServiceNow

Job Title: Senior Consultant - ServiceNow

Career Level: D2

Introduction to role:

Are you ready to disrupt an industry and change lives? 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 well 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.

Desirable Skills/Experience:

NA

When we put unexpected teams in the same room, we unleash bold thinking with the power to inspire life-changing medicines. In-person working gives us the platform we need to connect, work at pace and challenge perceptions. That's why we work, on average, a minimum of three days per week from the office. But that doesn't mean we're not flexible. We balance the expectation of being in the office while respecting individual flexibility. Join us in our unique and ambitious world.

At AstraZeneca, our work has a direct impact on patients by transforming our ability to develop life-changing medicines. We empower the business to perform at its peak by combining ground breaking science with leading digital technology platforms. With a passion for impacting lives through data, analytics, AI, machine learning, and more, we are at a crucial stage of our journey in becoming a digital and data-led enterprise. Here you can innovate, take ownership, experiment with groundbreaking technology, and tackle challenges that might never have been addressed before. Our dynamic environment offers countless opportunities to learn and grow while chipping in to something far bigger.

Ready to make a meaningful impact? Apply now to join our team!

AstraZeneca embraces diversity and equality of opportunity. We are committed to building an inclusive and diverse team representing all backgrounds, with as wide a range of perspectives as possible, and harnessing industry-leading skills. We believe that the more inclusive we are, the better our work will be. We welcome and consider applications to join our team from all qualified candidates, regardless of their characteristics. We comply with all applicable laws and regulations on non-discrimination in employment (and recruitment), as well as work authorisation and employment eligibility verification requirements.