jobapplier

[Job-32428] Senior Data & Analytics Specialist, Brazil

CI&T

This job is closed: the employer no longer lists it.

Skills

Required

  • semantic models
  • Snowflake
  • cloud data warehouse
  • pipelines
  • agile
  • control
  • data models
  • star schema
  • fact and dimension tables
  • surrogate keys
  • data marts
  • Python
  • SQL

Preferred

  • supply chain data
  • DevOps
  • Git
  • Azure DevOps
  • continuous integration and delivery
  • CI/CD
  • SAP data structures and extraction patterns
  • sell-out

The Analytics Developer Senior turns existing data views into a reliable dimensional model and builds the semantic layer that feeds business dashboards. Once the model is stable, the professional evolves current dashboards and proposes new ones. The role combines hands-on development with direct interaction with client management and product leadership.

About CI&T

At CI&T, we help large enterprises transform the potential of AI into real business impact with AI Deployment, AI-native execution, and tech-integrated business solutions.

With 30 years of experience in technological transformation, we accelerate innovation with expertise in Agentic SDLC, Application modernization, Data & AI, Martech and Business strategy.

We are 8,000 CI&Ters across more than 25 countries, collaborating to build solutions with real impact. AI is already part of how we work, evolve, and innovate every day.

Our client is a global leader in the consumer packaged goods (CPG) industry. Its supply chain division is moving reporting to a cloud data warehouse. A first migration kept reports running, and the semantic models now need structure and best practices. This role opens a new engagement and shapes the data foundation that every future report depends on.

Responsibilities

  • Designs dimensional and enterprise data models (star schema, fact and dimension tables, slowly changing dimensions, surrogate keys, data marts) by translating existing views into a structured, high-quality model.
  • Builds and optimizes Power BI semantic models with Data Analysis Expressions (DAX) and Power Query, connected to the cloud data warehouse.
  • Develops enterprise-grade reports and migrates existing ones to the new data foundation.
  • Improves current dashboards and proposes new ones by learning supply chain data and business needs.
  • Builds and monitors data integration pipelines with Python and orchestration tools such as Azure Data Factory, using standardized ingestion frameworks.
  • Gathers requirements, leads workshops, and validates solutions with client management and product leadership by co-creating solutions instead of taking orders.

Requirements

  • Builds and tunes Snowflake structures by applying best practices in architecture, performance, and role-based access control.
  • Works in agile teams and takes part in team ceremonies to deliver in short cycles.
  • Fluent English (B2 to C1), verbal and written, for global interaction
  • Proven experience designing dimensional and enterprise data models (star schema, fact and dimension tables, slowly changing dimensions, surrogate keys, data marts)
  • Hands-on Snowflake development, including architecture, performance tuning, role-based access control, and end-to-end implementations
  • Proven experience building and optimizing Power BI semantic models, Data Analysis Expressions (DAX), Power Query, and enterprise-grade reports connected to a cloud data warehouse
  • Hands-on experience with data integration pipelines in production, preferably Azure Data Factory (equivalent experience in other cloud platforms is considered), and familiarity with standardized ingestion frameworks
  • Advanced SQL and Python for pipelines and automation
  • Proven experience working directly with business stakeholders in requirements gathering, workshops, co-creation, and solution validation (not an order-taker profile)
  • Solid experience in agile teams and their ceremonies

Preferred

  • DevOps practices: Git, Azure DevOps, and continuous integration and delivery (CI/CD) for database change promotion

Understanding of SAP data structures and extraction patterns

  • Experience in the CPG industry, especially with supply chain data
  • Experience with sell-in, sell-out, and retail or market research data
  • Certifications such as SnowPro Core or Advanced and Azure Data Engineer Associate
  • Conversational Spanish for LATAM interaction

Benefits

  • -Meal and food allowance
  • -Partnership with gyms and health and wellness professionals via Wellhub (Gympass) TotalPass;
  • -Profit Sharing and Results Participation (PLR);
  • -Continuous learning platform (CI&T University);
  • -Discount club
  • -Free online platform dedicated to physical, mental, and overall well-being
  • -Pregnancy and responsible parenting course
  • -Partnerships with online learning platforms
  • -Language learning platform
  • And many more!
  • More details about our benefits here: https://ciandt.com/br/pt-br/carreiras

-Life insurance

At CI&T, inclusion starts at the first contact. If you are a person with a disability, it is important to present your assessment during the selection process. See which data needs to be included in the report by clicking here.This way, we can ensure the support and accommodations that you deserve. If you do not yet have the assessment, don't worry: we can support you in obtaining it.

We have a dedicated Health and Well-being team, inclusion specialists, and affinity groups who will be with you at every stage. Count on us to make this journey side by side.