The Role
Manage and improve Power BI reports, dashboards, semantic models, SSIS packages, ETL workflows, data pipelines, data warehouses, and OData integrations. Monitor scheduled jobs and refreshes, troubleshoot failures, optimize SQL and processing performance, maintain data quality, and support reliable enterprise data integration. Collaborate with technical and business teams to enable data-driven decision-making.
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.
We are currently offering an opportunity for a Mid-Level Data Analyst to join our team. The role focuses on supporting, maintaining, and improving our data and business intelligence solutions, ensuring reliable data integration, efficient processing, and high-quality reporting.
We are looking for a professional with intermediate-level experience in data analysis, business intelligence, and data integration, with strong analytical and problem-solving skills. The ideal candidate should be comfortable working with SQL Server, Power BI, SSIS, data warehouses, and enterprise data integration processes, while collaborating with technical and business teams to support data-driven decision-making.
Required Skills and Responsibilities
- Power BI Management: Develop, maintain, and optimize Power BI reports, dashboards, semantic models, and data refresh processes.
- SSIS Package Management: Develop, maintain, troubleshoot, and optimize SQL Server Integration Services (SSIS) packages and ETL workflows.
- Data Pipeline Management: Monitor, maintain, and optimize data pipelines to ensure reliable, efficient, and timely data processing.
- Data Warehouse Management: Maintain and enhance data warehouse solutions, ensuring data integrity, consistency, performance, and availability.
- Data Integration: Manage and support integrations between enterprise systems, databases, and external data sources.
- OData Services: Maintain, monitor, and troubleshoot OData endpoints, ensuring efficient data extraction, pagination, and integration with downstream systems.
- Troubleshooting and Performance Optimization: Identify root causes of technical issues, investigate pipeline failures, optimize SQL queries and data processing workflows, and implement corrective actions.
- Monitoring and Operational Support: Monitor scheduled jobs, data refreshes, integrations, and pipeline execution to ensure operational stability and adherence to service-level expectations.
- Data Quality and Integrity: Implement validation mechanisms and resolve data inconsistencies across source systems, integration layers, and data warehouse environments.
- Continuous Improvement: Identify opportunities to improve system reliability, processing performance, maintainability, and operational efficiency.
- English: Advanced english is required.
#LI-GP1
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.
Skills Required
- Intermediate-level experience in data analysis, business intelligence, and data integration
- Experience with Power BI reports, dashboards, semantic models, and data refresh processes
- Experience developing, maintaining, troubleshooting, and optimizing SQL Server Integration Services packages and ETL workflows
- Experience with SQL Server, data warehouses, data pipelines, and enterprise data integration
- Experience maintaining, monitoring, and troubleshooting OData services and endpoints
- Strong analytical and problem-solving skills
- Advanced English proficiency
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.
