Oracle Fusion Reporting Lead

About Impact Advisors Mexico

At Impact Advisors Mexico , we turn passion for healthcare into lasting careers. As part of the Impact Advisors network in the U.S., we partner with leading hospitals and healthcare organizations to enhance clinical, financial, and operational outcomes.

Our culture is people-first, inclusive, and growth-driven . We believe in empowering our associates through learning, collaboration, and purpose — creating a space where every idea and every individual matters. Together, we deliver solutions that make a Positive Impact in the world of healthcare.

Your Path to a High-Impact Healthcare Data & Quality Career

As an Oracle Fusion Reporting Lead , you will play a key role in designing and delivering reporting, analytics, and data solutions for healthcare clients leveraging Oracle Fusion Cloud .

You will lead the reporting workstream across Oracle Fusion applications, translating complex business requirements into scalable reporting solutions that provide accurate, actionable insights to business and executive stakeholders.

This position combines technical leadership, reporting architecture, hands-on development, data analysis, and client consulting . You will collaborate closely with functional consultants, business leaders, technical teams, and client stakeholders across areas such as Financials, HCM, SCM, and CX .

What You’ll Do

• Lead the end-to-end strategy, design, development, testing, deployment, optimization, and support of Oracle Fusion reporting and analytics solutions.
• Serve as the reporting technical lead and subject matter expert across Oracle Fusion Cloud applications, including ERP, HCM, SCM, and CX.
• Lead the design and development of custom reports, dashboards, analytics, and data extracts using OTBI, BI Publisher (BIP), BICC , and related Oracle reporting technologies.
• Translate business requirements into technical reporting specifications, data models, reporting strategies, and key performance indicators (KPIs) .
• Partner with functional leads, business analysts, executive stakeholders, and client teams to understand reporting needs and deliver solutions aligned with business objectives.
• Design and manage data extraction strategies for downstream applications, data warehouses, and analytics environments using BICC, REST/SOAP APIs, and other Oracle technologies .
• Develop and optimize complex OTBI analyses, subject areas, logical SQL, dashboards, and BI Publisher reports .
• Design BI Publisher data models, templates, bursting configurations, and scheduled reporting solutions.
• Troubleshoot complex SQL queries, data models, report logic, data discrepancies, and performance issues.
• Perform report and query performance tuning to ensure efficient processing and reliable delivery of business-critical information.
• Ensure reporting solutions maintain data accuracy, integrity, security, consistency, and compliance .

Who You Are

Education & Experience

• 8+ years of experience in business intelligence, reporting, analytics, data, or related technology roles.
• 5+ years of hands-on experience working with Oracle Fusion Cloud reporting and analytics .
• Proven experience serving as a Reporting Lead, BI Lead, Reporting Architect, or similar technical leadership role .
• Experience leading technical reporting teams through at least 2 full-lifecycle Oracle Fusion Cloud implementations .
• Strong experience supporting reporting requirements across one or more Oracle Fusion domains, including Financials, HCM, SCM, or CX .
• Experience working directly with clients, business stakeholders, functional consultants, and technical teams.
• Bachelor’s degree in Computer Science, Information Systems, Business Analytics, Engineering, or a related field preferred.
• Advanced English proficiency with the ability to communicate effectively with U.S.-based clients and stakeholders.

Technical Expertise

• Deep hands-on expertise with Oracle Transactional Business Intelligence (OTBI) , including:
• Logical SQL
• Dashboards
• Strong experience with Oracle BI Publisher (BIP) , including:
• Data models
• Strong experience with BICC (Business Intelligence Cloud Connector) for large-scale data extraction and downstream data integration.
• Advanced SQL / PL-SQL skills.
• Strong understanding of Oracle Fusion Cloud data structures, tables, schemas, views, relationships, and reporting models across ERP, HCM, and/or SCM.
• Experience designing and optimizing complex reporting queries and large-scale data extracts.
• Working knowledge of REST/SOAP APIs for data extraction and reporting requirements.
• Strong understanding of reporting security, data access, roles, and permissions within Oracle Fusion Cloud.
• Experience with data validation, reconciliation, data quality, and troubleshooting.
• Familiarity with Oracle Fusion Analytics Warehouse (FAW) , Oracle Analytics Cloud (OAC) , or Oracle Autonomous Data Warehouse (ADW) is highly desirable.
• Experience with Smart View reporting for Oracle Financials is a plus.
• Oracle Business Intelligence / Cloud Reporting certification is preferred .

Skills & Characteristics

• Strong technical leadership and analytical problem-solving skills.
• Excellent communication and stakeholder-management abilities.
• Comfortable working in a client-facing consulting environment .
• Ability to translate complex reporting and data requirements into practical business solutions.
• Strong attention to data accuracy, quality, and detail .
• Excellent organization, documentation, and project-management skills.
• Ability to prioritize multiple reporting initiatives in a fast-paced consulting environment.

What You’ll Get

Because we believe great professionals deserve great benefits:

Law Benefits:

· 15 days of year-end bonus (Aguinaldo).

· 12 days of paid vacation + vacation premium.

· Paid public holidays.

· Overtime pay.

· Social security (IMSS).

Above-the-Law Benefits:

· MXN $4,000 grocery vouchers monthly.

· Major and minor medical insurance through Sofía Salud.

· TotalPass gym membership discounts.

· 5 vacation days before completing your first year.

· Paid training and continuous mentorship.

· Employee Savings Box.