Excel Data Reporting Analyst

IQVIA; Ciudad de México; Presencial; MXN 554,000 - 925,000; Jornada completa

Descripción de la vacante

A leading global clinical research provider is seeking a detail-oriented Excel Data Reporting Analyst to enhance data organization and reporting processes. This role involves creating complex Excel spreadsheets, collaborating with cross-functional teams, and developing automated reporting solutions. Ideal candidates will have strong analytical skills, knowledge of VBA, and a commitment to accuracy. It offers an excellent opportunity to contribute to decision-making across various departments.

Formación

• Comprehensive understanding of Microsoft Excel, including formulas and 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.

Responsabilidades

• Lead the creation and maintenance of complex Excel spreadsheets.
• Support data analysis initiatives by preparing datasets.
• Collaborate with team members to develop standardized reporting templates.
• Participate in the documentation of processes and best practices.
• Design, build, and maintain dynamic dashboards and reports.
• Develop and implement VBA macros to automate tasks.

Conocimientos

Microsoft Excel

Data analysis

VBA

Data validation

Problem-solving

Communication skills

Herramientas

Power Query

Data visualization tools

Descripción del empleo

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 at https://jobs.iqvia.com