BIP Brasil

• Support strategic and tactical planning of logistics operations related to Exploration & Production (E&P). • Conduct analyses and studies to determine optimal inventory levels that meet business needs. • Define and monitor logistics performance metrics to measure operational efficiency and quality. • Generate technical insights and recommendations to support stakeholders in critical E&P logistics decisions. • Participate in strategic meetings with clients, presenting studies, analyses, and tailored logistics solutions. • Identify opportunities to optimize and innovate logistics processes through market studies and knowledge of industry best practices.

• Develop and maintain ETL/ELT processes to integrate data from multiple systems. • Design analytical data stores for consumption in Power BI and other analytics tools. • Build scalable, high-performance, and maintainable data models. • Create executive dashboards, metrics, and KPI frameworks. • Perform complex analyses to identify inconsistencies, integration failures, and data quality issues. • Investigate root causes of discrepancies between systems and propose corrective actions. • Work with large volumes of data, complex relationships, and performance optimization. • Implement transformations using SQL, Power Query, and Python when necessary. • Work on the semantic layer using Azure Analysis Services (when applicable). • Participate in defining data architecture and modeling best practices. • Document processes, business rules, data flows, and analytical models. • Collaborate with multidisciplinary teams on strategic Analytics and Business Intelligence projects. • Support less experienced colleagues by sharing knowledge and best practices.

• Build predictive and prescriptive models to anticipate trends in turnover, engagement, and performance. • Translate complex analyses into strategic insights and clear narratives for leadership and clients. • Automate data collection, validation, and governance processes, ensuring data quality and security. • Conduct benchmarks and monitor people-related KPIs to support proactive decision-making.

• Execute diagnostics based on data analysis, KPIs, and other metrics for business areas across companies in diverse industries; • Develop management and executive presentations summarizing the results of process diagnostics and build the presentation materials; • Define and quantify improvement initiatives for the processes analyzed, design implementation plans and monitor the results achieved; • Conduct interviews and lead workshops with area stakeholders to map processes, identify deviations/bottlenecks and root causes; • Support project scope control and manage the escalation process to ensure compliance with schedule and scope; • Work collaboratively in teams with clear and assertive communication; • Serve as a project point of reference, proposing solutions and proactively supporting project demands; • Support other consultants with project tasks; • Analyze documents, databases/reports and produce analyses

• Perform diagnostics based on data analyses, KPIs, etc., for business areas across companies in diverse industries • Develop management and executive presentations with the results of the conducted process diagnostics and prepare the presentation • Define and evaluate process improvement initiatives for the analyzed processes, design implementation plans and monitor the results achieved • Conduct interviews and facilitate workshops with area stakeholders to map processes, identify deviations/bottlenecks and root causes • Support scope control and escalation management to ensure adherence to schedule and scope • Work as part of a team and communicate assertively • Act as the project reference, proposing solutions and proactively supporting project demands • Interact with the project team, the client and other stakeholders to diagnose needs and review solution designs; able to define and execute stakeholder engagement strategies and develop/apply action plans for stakeholder management • Support other consultants with project tasks • Analyze documents, databases/reports and build analyses

• Map reports, information, databases and data flows involved in regulatory processes. • Gather primary sources, auxiliary datasets, support tables, integrations, transformations, volumes and technical dependencies. • Identify manual processes, parallel spreadsheets, macros, local controls and non-industrialized steps. • Support the creation of a data and report inventory, including sources, owners, flows, criticality and recurrence. • Structure and maintain governance artifacts such as a data catalog, data dictionary, business glossary and data lineage. • Design and document technical and functional lineage, from data origin to final consumption/regulatory reporting. • Define and implement data quality metrics for dimensions such as accuracy, completeness, consistency, integrity, traceability, reliability, timeliness, clarity and accessibility. • Support the design of quality controls, reconciliations, pre- and post-processing validations and audit trails. • Build or specify scorecards, indicators and executive dashboards for monitoring information quality. • Support the identification of gaps in data, processes, controls, documentation, architecture and governance. • Contribute to remediation action plans to address gaps, prioritize reports and evolve quality governance. • Collaborate with business, technology, architecture, risk, accounting, compliance, internal controls and audit teams. • Support the definition of tactical and target architecture for governance, data quality and monitoring. • Produce clear, traceable and auditable technical and functional documentation.

• Execução de diagnósticos com base em análises de dados, KPIs, etc... de áreas de negócios em empresas de segmentos diversos; • Desenvolvimento de apresentações (gerenciais e executivas) com os resultados do diagnóstico de processos realizado e construir a apresentação • Definição e Valoração de iniciativas de melhoria dos processos estudados, desenho de plano de implementação e acompanhamento dos resultados obtidos. • Realizar entrevistas e conduzir workshops com stakeholders das áreas para mapeamento de processos, identificação de desvios / gargalos e causas raízes; • Apoiar no controle do escopo do projeto e a gestão do processo de escalonamento para garantir o respeito do cronograma e do escopo; • Atuar com trabalho em equipe, boa assertividade na comunicação; • Ser a referência do projeto, propondo soluções e suportando as demandas do projeto de forma pró-ativa. • Interagir com a equipe do projeto, com o cliente e outros Stakeholders para diagnóstico de necessidades e revisão de desenho de soluções, sendo capaz de definir/executar estratégia de engajamento dos stakeholders e desenvolver/ aplicar o plano de ação para a gestão dos Stakeholders; • Suportar os demais consultores nas demandas de projeto • Analisar documentos, bases de dados/relatórios e construir análises

• Interagir com a equipe do projeto, com o cliente e outros stakeholders para diagnóstico de necessidades e desenho de soluções taylor made • Desenvolver análises, formular hipóteses e apresentar soluções para as necessidades do cliente • Atuar em projetos de diferentes escopos: planejamento estratégico, mapeamento e redefinição de processos, modelos operacionais, orçamento base-zero, finanças, logística, definição e gestão de indicadores de performance, gestão de mudança, entre outros.

• Desenvolver dashboards interativos e eficientes em Power BI, com foco na geração de insights para as áreas de negócio. • Manter e evoluir relatórios e painéis existentes, garantindo a atualização e a consistência dos dados. • Estruturar e modelar dados de diferentes fontes para suportar a visualização no Power BI. • Criar e gerenciar fluxos de trabalho automatizados no Power Automate, visando ganho de eficiência em processos operacionais. • Atuar junto às áreas usuárias para entender requisitos, identificar oportunidades de melhoria e propor soluções baseadas em dados. • Documentar os processos, fluxos e modelos de dados desenvolvidos. • Monitorar e garantir a qualidade e performance das soluções implementadas.

• Collect, process, and load data from diverse sources • Elicit requirements from stakeholders • Develop integrations between different platforms • Create and improve Business Intelligence platforms • Ensure delivery quality through rigorous reviews