#MakeDataMatter #HumanizingTheFuture
Data Analyst Pleno/Sênior – Excel, VBA, Automação
Location
Brazil
Posted
3 days ago
Salary
0
Seniority
Senior
Job Description
Data Analyst Pleno/Sênior – Excel, VBA, Automação
Keyrus
• Estruturar, consolidar e organizar bases de dados utilizadas nos processos de precificação • Desenvolver, manter e otimizar modelos analíticos em Excel • Criar automações utilizando VBA e Macros para ganho de produtividade e redução de atividades manuais • Mapear, transformar e integrar dados provenientes de diferentes fontes • Construir e evoluir modelos de dados que suportem a estratégia de precificação • Garantir a qualidade, consistência e rastreabilidade das informações • Levantar requisitos junto às áreas de negócio e traduzir necessidades em soluções orientadas por dados • Elaborar análises, estudos e simulações para apoiar decisões comerciais e financeiras • Documentar regras de negócio, premissas e cálculos dos modelos desenvolvidos • Atuar em parceria com equipes técnicas e áreas de negócio na evolução contínua das soluções
Job Requirements
- Experiência como Analista de Dados Pleno ou Sênior
- Excel avançado
- Domínio em VBA e desenvolvimento de Macros
- Sólido conhecimento em modelagem e estruturação de dados
- Experiência com organização, consolidação e tratamento de grandes volumes de dados
- Vivência no levantamento de requisitos junto às áreas de negócio
- Perfil analítico, organizado, proativo e com autonomia para conduzir atividades
- Boa comunicação e facilidade para atuar em equipes multidisciplinares
Benefits
- Cultura de igualdade
- Diversidade 🏳🌈 e multiculturalismo 🌍
Related Guides
Related Categories
Related Job Pages
More Data Analyst Jobs
• Design, develop, and maintain interactive Power BI dashboards and reports that support Finance and Business Insurance initiatives • Partner with business stakeholders to gather reporting requirements and translate business needs into analytical solutions • Build data models and develop DAX measures to deliver scalable, user-friendly dashboards • Extract, clean, validate, and transform data from multiple sources using SQL, Power BI, Excel, and other reporting tools • Develop automated reporting solutions using Excel macros, VBA, Python, or similar technologies • Perform data quality analysis, identify inconsistencies, and implement corrective actions to ensure reporting accuracy • Support financial planning, trend analysis, capital expense reporting, and business performance monitoring • Build dynamic reporting models to support agent segmentation, promotions, profitability analysis, and strategic growth initiatives • Collaborate with business and implementation teams to validate results and monitor post-launch performance • Support system enhancements, testing activities, and reporting infrastructure improvements • Clearly communicate technical findings and business insights to both technical and non-technical stakeholders • Continuously improve reporting processes, dashboard usability, and data visualization standards
• Collaborate with third-party vendors to complete required steps for extracting data from multiple source systems • Analyze legacy systems to understand data structures, relationships, and business rules • Translate legacy data into target system formats, including field-level mappings, source to destination code mapping, default values, and conditional logic • Communicate and collaborate with business owners and internal teams to improve data quality and resolve data issues prior to conversion • Lead and manage all data conversion-related meetings and calls • Work closely with the system vendor to identify, analyze, and resolve data discrepancies • Validate migrated data to ensure accuracy, completeness, and reconciliation with source systems • Perform data testing and validation for each sample delivery • Provide post-migration support and assist with data-related issues following go-live • Adhere to defined process timelines and milestones while managing data conversion activities across multiple concurrent projects
• Serve as the primary analytics partner for Marketing, supporting both Conference and Membership business lines • Develop and maintain reporting frameworks for marketing campaign performance across channels • Analyze marketing effectiveness and provide actionable recommendations to improve acquisition, engagement, and retention outcomes • Measure campaign ROI and support data-driven budget allocation decisions • Establish standardized marketing KPI definitions and reporting methodologies • Develop and maintain marketing attribution frameworks across Conference and Membership initiatives • Analyze acquisition channels, conversion funnels, and customer journeys to identify opportunities for optimization • Support conference registration reporting and performance measurement • Analyze subscriber acquisition, activation, retention, and lifetime value metrics • Design and maintain executive dashboards that provide visibility into marketing performance and business outcomes
• Analyze large healthcare datasets to identify trends, patterns, and actionable insights • Develop and maintain dashboards, scorecards, and key performance indicators (KPIs) • Extract, transform, and load (ETL) data from multiple systems into the enterprise data warehouse • Collaborate with clinical and operational teams to understand business needs and deliver reporting solutions • Perform data modeling, mapping, and visualization for quality improvement initiatives • Present findings and recommendations through clear, compelling visual and written communication • Support data governance, data quality, and performance improvement initiatives • Leverage benchmarking tools (e.g., Vizient and external datasets) to evaluate performance • Design and optimize SQL queries, tables, views, and stored procedures




