Excel Data Reporting Analyst

hace 2 semanas

Ciudad de México, Ciudad de México IQVIA A tiempo completo

Description

Detail-oriented Excel Data Reporting Analyst is needed to join our team at IQVIA-Cronos. In this role, you will leverage your foundational Excel skills to support data-driven decision-making across various departments. You will work closely with system developers, database administrators, and operational users to enhance data organization, reporting, and visualization processes.

Responsibilities

· Lead the creation and maintenance of complex Excel spreadsheets, ensuring data accuracy and integrity.

· Support data analysis initiatives by preparing datasets and performing preliminary data validation and cleaning.

· Collaborate with team members to develop standardized reporting templates and dashboards to streamline data presentation.

· Participate in the documentation of processes and best practices to enhance team efficiency.

· Report and dashboard creation: Design, build, and maintain dynamic dashboards and reports to visualize key performance indicators and present findings clearly.

· Automation: Develop and implement VBA macros and other scripts to automate repetitive tasks and streamline reporting processes.

· Data management: Use tools to clean, transform, and consolidate large datasets, ensuring data accuracy and integrity.

· Collaboration: Work with cross-functional teams to understand their data needs and provide solutions that support business strategies.

· Problem-solving: Troubleshoot and resolve complex issues within spreadsheets and data models.

· Documentation and support: Document processes, best practices, and provide training to other users.

Required skills and qualifications

· Comprehensive understanding of Microsoft Excel, including formulas, pivot tables, data visualization tools and building dashboards.

· Experience with creating end user reports from complex Excel datasets

· Knowledge of automation tools like VBA and Power Query.

· Strong analytical and problem-solving abilities.

· Excellent attention to detail.

· Strong communication skills, both written and verbal.

· Experience with data validation and data integrity checks.

· Ability to perform repetitive tasks accurately.

· Ability to work collaboratively in a remote environment while maintaining high standards of accountability.

Technical Skills and Relevant Technologies

  • Proficiency in Microsoft Excel, including advanced formulas and functions, PivotTables & PivotCharts, Conditional Formatting, Data Validation & Integrity Checks
  • Experience and knowledge of data visualization tools or reporting software including Dynamic Dashboards, Advanced Charting Techniques, Integration with BI Tools
  • Data Handling and Automation, e.g.   Power Query, Macros & VBA, Data Import/Export
  • Integration with AI features for predictive insights and automated summaries.

IQVIA is a leading global provider of clinical research services, commercial insights and healthcare intelligence to the life sciences and healthcare industries. We create intelligent connections to accelerate the development and commercialization of innovative medical treatments to help improve patient outcomes and population health worldwide. Learn more

  • Reporting Analyst

    hace 6 días

    Ciudad de México, Ciudad de México AVI-SPL México A tiempo completo

    Descripción GeneralWho We AreAVI-SPL is a digital enablement solutions provider who transforms how people and technology connect to elevate experiences, create new value, and enable organizations to thrive and grow. We are the largest provider of collaboration technology solutions, which include our award-winning managed services.Our highly certified...

  • Data Analyst

    hace 2 semanas

    Ciudad de México, Ciudad de México International Data Group A tiempo completo

    OverviewIDC is seeking a Data Analyst to join the Enterprise Infrastructure team. In this role, you will conduct market research and analysis across our programs, helping to shape business strategy through data-driven insights. The ideal candidate can interpret complex quantitative and qualitative data, identify patterns, and translate findings into...

  • Data Analyst

    hace 2 semanas

    Ciudad de México, Ciudad de México International Data Group, Inc. A tiempo completo

    Overview:IDC is seeking a Data Analyst to join the Enterprise Infrastructure team. In this role, you will conduct market research and analysis across our programs, helping to shape business strategy through data-driven insights. The ideal candidate can interpret complex quantitative and qualitative data, identify patterns, and translate findings into...

  • HR Reporting Analyst

    hace 3 días

    Ciudad de México, Ciudad de México Kraft Heinz A tiempo completo

    Job DescriptionJob Title HR Insights Analysts – Band B15GBSJob Summary HR Insights Analyst will support HR data management, reporting and dashboard development to help HR and business partners make informed decisions. You will maintain data quality, assist with analytics and collaborate with the Employee Data Management (EDM) team to ensure smooth HRIS...

  • HR Reporting and Data Analyst

    hace 2 semanas

    Ciudad de México, Ciudad de México Infoblox A tiempo completo

    Job DescriptionAt Infoblox, every breakthrough begins with a bold"what if."What ifyour ideas could ignite global innovation?What ifyour curiosity could redefine the future?We invite you to step into the next exciting chapter ofyourcareer journey. Bring your creativity, drive, your daring spirit, and feel what it's like to thrive on a team big enough to make...

  • Finance Data Analyst

    hace 2 semanas

    Ciudad de México, Ciudad de México Stagwell Global A tiempo completo

    About UsLocaria is a specialist multilingual content and creative adaptation agency. We are experts in developing global brand marketing campaigns, delivering localised e-commerce content, optimising multimarket media and scaling asset development across culturesOverviewThe role supports the FP&A function through automation and data-driven reporting. It...

  • Sales Force Data Hygiene Analyst

    hace 6 días

    Ciudad de México, Ciudad de México Logitech A tiempo completo

    Logitech is the Sweet Spot for people who want their actions to have a positive global impact while having the flexibility to do it in their own way.Job Summary:We're seeking an experienced Salesforce Data Hygiene Analyst to join our team. As a Data Hygiene Analyst, you will be responsible for ensuring the accuracy, completeness, and consistency of our...

  • Sales Force Data Hygiene Analyst

    hace 3 días

    Ciudad de México, Ciudad de México Logitech A tiempo completo

    Logitech is the Sweet Spot for people who want their actions to have a positive global impact while having the flexibility to do it in their own way.Job Summary:We're seeking an experienced Salesforce Data Hygiene Analyst to join our team. As a Data Hygiene Analyst, you will be responsible for ensuring the accuracy, completeness, and consistency of our...

  • Operations Analyst

    hace 6 días

    Ciudad de México, Ciudad de México NTT DATA A tiempo completo

    Req ID: NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Operations Analyst to join our team in Mexico City, México (MX-MEX), Mexico (MX). GTM Operations Analyst --- Support our go...

  • Data Analyst

    hace 2 semanas

    Ciudad de México, Ciudad de México Qualcomm A tiempo completo

    CompanyQualcomm Intl Inc., Mexico Branch OfficeJob AreaMiscellaneous Group, Miscellaneous Group > Data AnalystQualcomm OverviewQualcomm is a company of inventors that unlocked 5G ushering in an age of rapid acceleration in connectivity and new possibilities that will transform industries, create jobs, and enrich lives. But this is just the beginning. It...