Sr. Analyst, Financial Systems

Overview

This position reports to: Marco Menchaca

Recruiter: Zulema Rivera

Staff level: IV

Site: Las Fuentes

POSITION SUMMARY STATEMENT: 

The role is an integral part of the FP&A Financial Systems Reporting team, tasked with providing advanced reporting and automation support to users worldwide. This role involves deep technical work, focusing on analyzing, improving, and documenting financial reports, participating in projects to enhance reporting solutions, and leveraging programming skills to implement new technologies. The Analyst will develop and optimize scripts, use cloud-based solutions, and employ tools such as Python, SQL, and BI platforms to create automated and efficient reporting systems. Additionally, the role requires proficiency in data warehousing, ETL processes, and API integrations to ensure seamless data flows. The Analyst collaborates with IT and business units to optimize financial reporting systems and drive continuous improvements and innovation.

DETAILED RESPONSIBILITIES:

1.    Integrate and standardize financial reports from Regional, Country, and Corporate Teams into the FP&A FSP Reporting Team, ensuring consistency and accuracy through advanced data integration techniques.2.    Design, develop, and maintain OneStream cube views and reports to meet organizational needs, automating repetitive reporting tasks using programming languages such as Python to enhance efficiency and reduce manual errors.3.    Identify and implement optimization opportunities for existing reports and financial analysis processes, applying predictive modeling, machine learning, and statistical methods to improve the accuracy and relevance of financial reports.4.    Conduct comprehensive fit/gap analyses to assess current system capabilities and provide detailed recommendations for system enhancements that align with business objectives and improve reporting automation.5.    Develop and maintain thorough documentation on requirements, functional specifications, testing procedures, and system configurations, ensuring all documentation adheres to industry best practices and internal standards.6.    Continuously monitor the performance of financial reporting systems, identifying and resolving issues proactively while collaborating with the IT team to implement performance tuning measures and troubleshoot application problems effectively.

7.    Work closely with IT professionals to coordinate and test system infrastructure improvements, liaising with business units to gather requirements, provide training, and ensure effective use of reporting tools.8.    Drive the development of innovative reporting solutions leveraging the latest technologies and methodologies, staying updated with emerging trends in technology and financial reporting to introduce new ideas and improvements to the team. 

Job Qualifications

REQUIRED QUALIFICATIONS:

Skills:

•    Basic- intermediate Microsoft Excel•    Proficiency in Python and SQL for data analysis, automation, and ETL processes.•    Expertise in BI tools like Power BI, Tableau, or Looker for data visualization and reporting.•    Familiarity with cloud platforms (AWS, Azure, Google Cloud) for scalable solutions.•    Software development skills languages (Python, VB.NET)•    Strong collaboration, communication, and documentation skills.

Languages: •    English intermediate

Experience:

•    6 months of experience using programming language such as Python & VB.NET.•    Experience using BI reporting tools.

Education:

•    BS degree in Software Engineering, Cross-Platform Software Development Engineering or Finance Engineering related field

PREFERRED QUALIFICATIONS:

•    One Stream Knowledge.•    Certification in Business Intelligence Tools.•    Experience with API Integrations.•    Proficiency in VB.NET and XBRL.