Keyrus logo
Keyrus

#MakeDataMatter #HumanizingTheFuture

Data Analyst Pleno/Sênior – Excel, VBA, Automação

Data AnalystData AnalystFull TimeRemoteSeniorTeam 1,001-5,000Since 1996H1B SponsorCompany SiteLinkedIn

Location

Brazil

Posted

3 days ago

Salary

0

Seniority

Senior

Bachelor DegreePortugueseVBA

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 Categories

Related Job Pages

More Data Analyst Jobs

Capgemini logo

Data Analyst I

Capgemini

Get the Future You Want

Data Analyst3 days ago
Full TimeRemoteTeam 10,001+Since 1967H1B Sponsor

• 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

Mexico
World Insurance Associates LLC logo

Data Migration Analyst

World Insurance Associates LLC

Large Resources. Local Relationships.

Data Analyst3 days ago
Full TimeRemoteTeam 1,001-5,000Since 2012H1B No Sponsor

• 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

United States
$75K - $85K / year
Full TimeRemoteTeam 11-50Since 1991H1B No Sponsor

• 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

California + 12 moreAll locations: California | Colorado | Florida | Kansas | New Hampshire | New Jersey | New York | Massachusetts | Pennsylvania | Texas | Utah | Virginia | Washington
$110K - $125K / year
Full TimeRemoteTeam 11-50H1B Sponsor

• 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

United States
$93.4K - $144.8K / year