Excel Data Reporting Analyst

IQVIA; São Paulo; Híbrido; BRL 60.000 - 80.000; Tempo integral

Resumo da oferta

A leading global provider of clinical research services is seeking an Excel Data Reporting Analyst in São Paulo. The role involves leading the creation of complex spreadsheets and supporting data analysis through effective reporting and visualization. Candidates should have strong Excel skills and experience with automation tools. This position offers the opportunity to collaborate with cross-functional teams in a dynamic environment.

Qualificações

• Strong understanding of Excel, including formulas and pivot tables.
• Experience with creating end-user reports from complex datasets.
• Knowledge of VBA for automation.

Responsabilidades

• Lead creation and maintenance of complex Excel spreadsheets.
• Support data analysis by preparing datasets and validation.
• Develop standardized reporting templates and dashboards.
• Design and maintain dashboards to visualize key performance indicators.

Conhecimentos

Microsoft Excel

VBA

Data visualization tools

Analytical skills

Problem-solving

Attention to detail

Communication skills

Ferramentas

Power Query

Reporting software

Descrição da oferta de emprego

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 functions and features.
• Experience and knowledge of data visualization tools or reporting software.

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