[Hiring] Senior Data & Analytics Specialist @CI&T

Role Description

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.

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

Qualifications

• 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

Requirements

• 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

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!