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

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.

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.

Responsibilities:

• Data modeling: 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.

• Snowflake development: Builds and tunes Snowflake structures by applying best practices in architecture, performance, and role-based access control.

• Semantic models: Builds and optimizes Power BI semantic models with Data Analysis Expressions (DAX) and Power Query, connected to the cloud data warehouse.

• Reporting: Develops enterprise-grade reports and migrates existing ones to the new data foundation.

• Dashboard evolution: Improves current dashboards and proposes new ones by learning supply chain data and business needs.

• Data integration: Builds and monitors data integration pipelines with Python and orchestration tools such as Azure Data Factory, using standardized ingestion frameworks.

• Business partnership: Gathers requirements, leads workshops, and validates solutions with client management and product leadership by co-creating solutions instead of taking orders.

• Agile delivery: Works in agile teams and takes part in team ceremonies to deliver in short cycles.

Requirements:

• 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

Nice to Have:

• 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

#LI-TO1

Our benefits:   -Health and dental insurance -Meal and food allowance -Childcare assistance -Extended paternity leave -Partnership with gyms and health and wellness professionals via Wellhub (Gympass) TotalPass; -Profit Sharing and Results Participation (PLR); -Life insurance -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   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.