Excel Data Reporting Analyst

IQVIA Solutions do Brasil Ltda (BR01); São Paulo; Teletrabalho; BRL 80.000 - 120.000; Tempo integral

Resumo da oferta

A leading clinical research provider in São Paulo is seeking a detail-oriented Excel Data Reporting Analyst to enhance data organization, reporting, and visualization across various departments. The ideal candidate should have a strong understanding of Excel, experience with data validation, and excellent problem-solving skills. Join a dynamic team dedicated to improving healthcare outcomes through data-driven decision-making.

Qualificações

• Comprehensive understanding of Microsoft Excel, including formulas and dashboards.
• Experience in creating end user reports from complex datasets.
• Strong analytical and problem-solving abilities.

Responsabilidades

• Lead creation and maintenance of complex Excel spreadsheets.
• Support data analysis by preparing datasets and performing validation.
• Collaborate to develop reporting templates and dashboards.

Conhecimentos

Microsoft Excel

Data visualization

VBA

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