The Role
Design, develop, maintain, and evolve scalable data transformation pipelines and AI/data products using dbt, SQL, Python/PySpark, Azure data services, Delta Lake, and Power BI. Apply software engineering best practices, CI/CD, and role-based access control integration.
Summary Generated by Built In
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.
The Analytics Engineer will contribute to the design, development, maintenance, and evolution of AI and Data Products.
Required Experience
- Expertise in creating and managing data transformation pipelines using DBT.
- Advanced knowledge of SQL for data querying, transformation, and aggregation.
- Strong coding skills in Python, especially with libraries related to data manipulation (e.g., Pandas).
- Experience in applying good software engineering practices such as testing, clean code, code formatting, and peer review.
- Ability to design scalable and robust data pipelines.
- Proficiency in Azure Data Lake, Azure Data Factory, Azure Blob Storage, Azure SQL Database, and other related Azure services.
- Working knowledge of Azure Databricks for deploying & running Spark jobs.
- Prior knowledge of PySpark for data processing, particularly DataFrame API.
- Understanding of Delta Lake for reliable data lakes.
- Knowledge of both relational (SQL Server) and NoSQL databases (like Cosmos DB).
- Proficiency in tools like Python libraries (e.g., Pandas, NumPy) and data analysis platforms (e.g., Jupyter Notebooks).
- Experience in cleaning, transforming, and preparing raw data for analysis and modeling.
- Proficiency in data visualization with Power BI for creating impactful visualizations and dashboards.
- Understanding of role-based access controls and integration with Azure Active Directory.
- Experience with continuous integration and continuous deployment tools like Azure DevOps.
Desired Knowledge
- Knowledge of tooling in the Python ecosystem such as dependency management tooling (poetry, venv).
- Ability to create interactive dashboards and reports to communicate analytical insights effectively.
- Knowledge of both relational (SQL Server) and NoSQL databases (like Cosmos DB).
#Li-MG4
#Midsenior
Why join us?
- Competitive Salary
- Generous paid vacation days
- Generous sick time
- 100% paid health & dental benefits starting day one
- Annual profit-sharing distribution
- Paid parental leave
- Dedicated career advisor
And so much more…
Collaboration is our superpower, diversity unites us, and excellence is our standard.
We value diverse identities and life experiences, fostering a diverse, inclusive, and safe work environment. We encourage applications from diverse and underrepresented groups to our job positions.
Skills Required
- Experience creating and managing data transformation pipelines using dbt
- Advanced SQL for querying, transformation, and aggregation
- Strong Python coding skills, including data libraries (Pandas)
- Experience with PySpark and Spark DataFrame API for data processing
- Proficiency with Azure Data Lake, Azure Data Factory, Azure Blob Storage
- Experience with Azure Databricks for deploying and running Spark jobs
- Understanding of Delta Lake for reliable data lakes
- Knowledge of relational (SQL Server) and NoSQL (Cosmos DB) databases
- Experience with Azure SQL Database
- Experience applying software engineering practices: testing, clean code, code review, formatting
- Ability to design scalable and robust data pipelines
- Experience cleaning, transforming, and preparing raw data for analysis and modeling
- Proficiency with data analysis platforms and notebooks (Jupyter Notebooks)
- Proficiency in data visualization with Power BI to create dashboards
- Understanding of role-based access controls and integration with Azure Active Directory
- Experience with CI/CD tools like Azure DevOps
- Familiarity with Python ecosystem tools and dependency management (poetry, venv)
- Familiarity with NumPy and other Python data libraries
- Ability to create interactive dashboards and reports to communicate analytical insights
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
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.
