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

Ciandt; Brasil; Híbrido; BRL 180.000 - 300.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Health insurance

Meal allowance

Childcare assistance

Extended paternity leave

Wellness partnerships

Profit sharing

Life insurance

CI&T University learning platform

Discount club

Wellbeing platform

Language learning platform

Descripción de la vacante

CI&T, a global tech transformation partner, seeks an Analytics Developer Senior to turn existing data views into a robust dimensional model and to build the semantic layer powering dashboards. You will interact directly with client management and product leadership, combining hands-on development with strategic advisory.

Expect to evolve current dashboards, propose new ones, and contribute to data integration pipelines using Python and Azure Data Factory within agile teams.

Formación

• Fluent English (B2 to C1) 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, and access control
• Proven experience building and optimizing Power BI semantic models and enterprise-grade reports connected to a cloud data warehouse
• Experience with data integration pipelines (preferably Azure Data Factory) and standardized ingestion frameworks
• Advanced SQL and Python for pipelines and automation
• Experience working with business stakeholders in requirements gathering, workshops, and co-creation in agile teams

Responsabilidades

• Data modeling: design dimensional models (star schema, facts, dimensions, SCDs) from existing views
• Snowflake development: build and tune Snowflake structures with best practices
• Semantic models: develop Power BI models using DAX and Power Query
• Reporting: migrate and create enterprise-grade reports
• Dashboard evolution: enhance dashboards based on supply chain data needs
• Data integration: build and monitor pipelines using Python and Azure Data Factory

Conocimientos

Dimensional modeling

Snowflake development

Power BI modeling

SQL

Python

Stakeholder collaboration

Agile ceremonies

Herramientas

Snowflake

Power BI

Azure Data Factory

SQL

Python

Descripción del empleo

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

• -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.