Digital Transformation Specialist Consultant II - Rio de Janeiro - Hybrid
MANDATORY REQUIREMENTS
- Advanced knowledge in ETL (Extract, Transform, Load) processes
- Advanced knowledge in Power BI (data modeling, DAX, creation of dashboards and reports)
- Advanced knowledge in Power Automate (automated flows, integration with SharePoint, Teams and other Microsoft 365 apps)
- Advanced knowledge in Microsoft Excel (advanced formulas, Power Query, pivot tables)
- Knowledge in Microsoft SharePoint / Power Apps for digitalization of forms and processes
- Knowledge in SQL / Databricks
Specific Technical Knowledge
- Solid Python 3.x (object-oriented, simple patterns, optional typing).
- Flask and FastAPI (advanced ORM, signals, middlewares, migrations).
- Selenium for test automation and web routines.
- pandas for data manipulation and analysis.
- VBA for process automation in Excel.
- PowerApps for low-code development.
- PowerAutomate for integration and flow automation.
- PostgreSQL (relational modeling, query optimization, indexes, explain/analyze).
- JavaScript (ES6), HTML and CSS for frontend development.
- Integration with external services (REST/SOAP or WSDL; resilient consumption).
- Technical English for reading (documentation, libs, issues).
- Basic web security: CSRF, XSS, access control, data sanitization.
EXPERIENCE
Minimum Time of Experience in the area (years):
Solid Experience in the area
EDUCATION
Higher education degree in Administration (CBO 2521-05), Engineering (CBO 214), Accounting (CBO 2522-10), Law (CBO 2410), Economics (CBO 2512-05), Information Technology Analysis (CBO 2124), or Information Technology Administrator (CBO 2123), or Statistics (CBO 2112) or other areas related to the specialty as long as validated by contract management
DESIRABLE REQUIREMENTS
- Knowledge in Python (automation, data manipulation, integration via APIs)
- Notions of data governance and data quality
- Familiarity with APLAT
- Familiarity with offshore processes (crew scheduling, POB, VCP)
RESPONSIBILITIES
- Implement and evolve REST APIs with Flask or FastAPI (versioning, validation, serialization).
- Automate processes using Selenium, VBA, PowerApp and PowerAutomate, integrating systems and optimizing routines.
- Manipulate and transform data with pandas, performing analyses and reports.
- Develop and maintain queries and models in PostgreSQL (indexes, transactions, consistent migrations).
- Create responsive web interfaces with JavaScript, HTML and CSS.
- Integrate and monitor synchronization routines with external systems (e.g.: SAP, REST/SOAP).
- Ensure integrity and security of the permissions and profiles system.
- Review PRs, propose architectural improvements and follow internal standards (lint, app structure, internationalization).
- Diagnose and optimize performance bottlenecks (DB, IO, memory, queries).
- Document: endpoints, critical flows, technical decisions and diagrams (C4 / technical README’s).
- Ensure observability (structured logs, metrics and exception handling).
About CAPCO:
At Capco we promote an inclusive culture. We value diversity in all its expressions.
Together, we always think of diverse inclusion and social responsibility actions through internal committees managed by our internal community, such as the groups for Women, People with Disabilities, Black People, LGBTQIAPN+, Parenthood, Generations, among others.
Our opportunities are designed for everyone!!!
#LifeAtCapco
NEXT STEPS:
If you are eager to progress your career with us, apply and wait for contact from one of our recruiters!