Planning & Rationalization Support – Business Process Analyst

Location: LATAM 

Contract: 12 months with possible extension 

Overview 

Join KellyOCG as a Business Process Analyst in Regulatory Affairs. The role’s objective is to drive continuous improvement and digital transformation in the planning and budgeting processes of the Latin America Regulatory Affairs area, ensuring efficient data integration and automation of critical tasks. The position requires a combination of technical expertise in analytical and automation tools, along with skills to lead optimization projects and collaborate with cross-functional teams in a regional and global corporate environment. 

Main Responsibilitie 

• Support in the preparation of reports and data collection for the Submission Planning and Work Plan process of the Regional Regulatory Affairs area.
• Develop analytical solutions and automations that optimize decision-making.
• Provide ongoing support in the improvement of regulatory planning and budgeting processes for the Latin America Regulatory Affairs area through the development of technological tools and improvements to those already in place.
• Collaborate in the technical implementation of dashboards and metrics designed to monitor planning and budgeting processes for the Regional Regulatory Affairs area. Ensure the development of tools and techniques for the automatic generation, at defined frequencies, of such metrics.
• Assist in identifying and implementing transformative improvements in the processes, tools, and systems used by the area, aiming for continuous improvement and increased efficiency. Examples include, but are not limited to:
• Automating manual processes with Power Automate flows to reduce time and errors.
• Integrating data across platforms (Smartsheet, SharePoint, Dataverse) to ensure consistency and traceability.
• Optimizing analytical models in Power BI by applying best practices in modeling and performance.
• Developing applications in Power Apps to centralize information management and facilitate decision-making.
• Implementing simple ETLs (Extract, Transform, Load) in Python for cleaning and validating data from multiple sources. 

Technical Skills Advanced Excel (required): 

• Advanced formulas: XLOOKUP, INDEX/MATCH, LET, LAMBDA
• Use of Power Query (M language)
• Analytical models, pivot tables, and scenarios Power BI (required):
  • Languages: DAX, Power Query M, basic-intermediate SQL
  • Data modeling, star schema design and relationships
  • Data cleaning and transformation from multiple sources
  • Integration with SharePoint, Smartsheet, Excel, Dataverse
• Model and performance optimization Power Automate (required):
  • Languages and structures: Expressions, JSON, REST APIs
  • End-to-end flow design
  • Integrations with Power Apps, Smartsheet, SharePoint
  • Handling variables, conditions, loops, and connectors
• Automation of approvals, notifications, and critical processes Power Apps (Canvas Apps) (required):
  • Language: Power Fx
  • Creating applications connected to SharePoint, Excel, Smartsheet, Dataverse
  • Managing collections, forms, business logic, and patch function
  • Building functional and efficient interfaces in Power Apps 

Soft Skills:

• Effective communication: Ability to clearly convey technical and strategic information to cross-functional teams and stakeholders.
• Analytical thinking and problem-solving: Skill to identify opportunities for improvement and propose innovative, data-driven solutions.
• Time management and organization: Prioritize tasks and meet deadlines on complex, simultaneous projects.
• Collaboration and teamwork: Work with regional teams, promoting cooperation and sharing best practices.
• Adaptability and continuous learning: Adjust to changes in processes, tools, and priorities in a dynamic environment.
• Results-oriented: Focus on delivering solutions that provide tangible impact in efficiency and quality.
• Ability to coordinate improvement initiatives and motivate teams toward common goals. 

Additional Requirements: 

• Spanish language (oral and written), advanced level.
• Mandatory: Advanced command of English (oral and written), for interaction with global teams and technical documentation.
• Not mandatory: Portuguese language (oral and written).