Data Integration

6 giorni fa

Modena, Emilia-Romagna, Italia Hyqoo Tempo pieno
Job Title: Data Integration & Reporting Analyst We are seeking a highly skilled Data Integration & Reporting Analyst to join our client's Global Resiliency team. This role is pivotal in modernizing and enhancing the organization's data reporting capabilities by analyzing, documenting, and improving data flows from ServiceNow into advanced analytics platforms such as Databricks. The successful candidate will play a critical role in transforming fragmented dashboards and limited data views into a federated, scalable data solution that drives better risk insights and decision-making across the enterprise. This position offers a unique opportunity to influence data architecture and reporting modernization without the requirement to write production-level code. Roles and

Responsibilities:
• Build a comprehensive inventory of existing datasets, integrations, dashboards, and reporting assets related to Global Resiliency.
• Document ServiceNow APIs, data structures, and how current reports utilize these data sources.
• Map data movement from ServiceNow and other systems into the reporting environment; create current-state architecture and data flow diagrams.
• Analyze and capture calculations, business rules, and transformations embedded in existing Power BI reports.
• Identify manual processes, documentation gaps, and single-person dependencies to mitigate operational risks.
• Evaluate the adequacy of current ServiceNow data sources and APIs; recommend improvements to optimize data extraction and accessibility.
• Facilitate the migration of Global Resiliency data into the Federated Data Lake built on Databricks and assist in building datasets within this environment.
• Develop source-to-target mappings, business glossaries, data dictionaries, and clearly define agreed metrics.
• Clarify data ownership, support structures, and establish data quality expectations.
• Recommend future-state data architectures and prioritize roadmaps based on value, implementation effort, and operational risk.
• Create runbooks and conduct thorough knowledge transfer sessions to ensure smooth handover and team enablement.

Qualifications:
• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or a related field.
• 5 + years of professional experience in data integration, reporting analysis, or a similar role.
• Proven expertise in extracting and analyzing data from ServiceNow, including deep understanding of its data tables, reporting capabilities, and REST APIs.
• Strong proficiency in SQL for data querying and analysis.
• Hands-on experience with Power BI, including dissecting existing reports, data models, and business logic.
• Experience in data integration analysis including documentation of data flows, source-to-target mappings, and data transformation processes.
• Familiarity with Databricks and cloud-based Federated Data Lake environments is highly desirable.
• Knowledge of data governance principles such as metric definitions, data quality, business glossaries, and data dictionaries is a plus.
• Excellent analytical, documentation, and communication skills with a demonstrated ability to work independently and collaboratively with technical and business stakeholders. Tools and Technologies :
• ServiceNow (including REST APIs)
• Databricks / Federated Data Lake (FDL)
• Power BI
• SQL
• Azure Analytics Environment (preferred)