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.
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
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
Skills Required
- Fluent English at B2 to C1 level, verbal and written
- Experience designing dimensional and enterprise data models, including star schemas, fact and dimension tables, slowly changing dimensions, surrogate keys, and data marts
- Hands-on Snowflake development, including architecture, performance tuning, role-based access control, and end-to-end implementations
- Experience building and optimizing Power BI semantic models, DAX, Power Query, and enterprise-grade reports connected to a cloud data warehouse
- Production experience with data integration pipelines, preferably Azure Data Factory, and familiarity with standardized ingestion frameworks
- Advanced SQL and Python for pipelines and automation
- Experience working directly with business stakeholders in requirements gathering, workshops, co-creation, and solution validation
- Solid experience working in agile teams and participating in agile ceremonies
- DevOps practices, including Git, Azure DevOps, and CI/CD for database change promotion
- Understanding of SAP data structures and extraction patterns
- Experience in the consumer packaged goods industry, especially supply chain data
- Experience with sell-in, sell-out, retail, or market research data
- SnowPro Core or Advanced certification, or Azure Data Engineer Associate certification
- Conversational Spanish for LATAM interaction
What We Do
CI&T is your end-to-end digital transformation partner. As a digital native, we bring a 27-year track record of accelerating business impact through complete and scalable digital solutions. With a global presence of 6,000+ professionals in strategy, research, data science, design and engineering, we unlock top-line growth, improve customer experience and drive operational efficiency.
