Empresa: 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. 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.