Oracle Fusion Reporting Lead
Impact Advisors Mexico
Recibe más respuestas de empleadores
Envía un currículum específico para el puesto de trabajo en cuestión de minutos.
Ventajas ofrecidas por este puesto de trabajo
Descripción de la vacante
Impact Advisors Mexico seeks an Oracle Fusion Reporting Lead to design and deliver reporting, analytics, and data solutions for healthcare clients using Oracle Fusion Cloud. Lead the reporting workstream across Oracle Fusion apps, translating complex requirements into scalable reports and dashboards that provide accurate, actionable insights to business and executive stakeholders.
This role blends technical leadership, architecture, hands‑on development, and client consulting, collaborating with
Formación
- 8+ years in business intelligence, reporting, analytics, data, or related tech roles.
- 5+ years hands‑on Oracle Fusion Cloud reporting and analytics experience.
- Proven experience as Reporting Lead, BI Lead, Reporting Architect, or similar.
- Experience leading technical reporting teams through at least 2 Oracle Fusion Cloud implementations.
- Strong experience across Oracle Fusion domains including Financials, HCM, SCM, or CX.
- Client-facing experience with stakeholders, consultants, and technical teams.
- Advanced English proficiency for U.S.-based client interaction.
Responsabilidades
- Lead end-to-end strategy and delivery of Oracle Fusion reporting and analytics solutions.
- Serve as reporting technical lead across Oracle Fusion Cloud applications (ERP, HCM, SCM, CX).
- Design and develop reports, dashboards, analytics, and data extracts using OTBI, BIP, and related tools.
- Translate business requirements into technical reporting specs, data models, and KPIs.
- Collaborate with functional leads, analysts, and clients to align solutions with business goals.
- Design data extraction strategies for downstream apps and warehouses using BICC and APIs.
- Develop and optimize OTBI analyses, dashboards, and BI Publisher reports.
- Create BI Publisher data models, bursting, and scheduled reports.
- Troubleshoot SQL, data models, and report logic; tune performance.
- Establish standards, documentation, security, and governance for reporting.
- Mentor and transfer knowledge to junior developers.
- Participate in design reviews, testing, and go-live activities.
- Support client issues and continuous improvement of reporting assets.
Conocimientos
Educación
Herramientas
Descripción del empleo
Turn Your Talent into a High-Impact Healthcare Career.
Oracle Fusion Reporting Lead
Location: Colonia Del Valle, Mexico City
Schedule: Monday to Friday, 7:00 AM – 4:00 PM
Salary: Competitive / Based on experience
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.
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.
- 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.
- Establish reporting standards, reusable development patterns, documentation practices, security guidelines, and governance processes.
- Ensure reporting solutions maintain data accuracy, integrity, security, consistency, and compliance.
- Provide technical leadership, mentoring, and knowledge transfer to report developers and technical team members.
- Participate in solution design sessions, technical reviews, project planning, testing, and go-live activities.
- Collaborate with implementation and support teams to resolve reporting issues and provide ongoing client support.
- Identify opportunities to automate reporting processes, improve data accessibility, and enhance the overall reporting experience.
- Provide clear technical recommendations to clients and stakeholders, acting as a trusted advisor in Oracle reporting and analytics.
- Contribute to the development of reusable reporting assets, methodologies, and best practices across Impact Advisors Mexico.
- Support continuous improvement and contribute to innovative solutions that improve healthcare clients' financial, operational, and business outcomes.
- 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.
- Deep hands‑on expertise with Oracle Transactional Business Intelligence (OTBI), including:
- Subject areas
- Analyses
- Logical SQL
- Dashboards
- Filters and prompts
- Strong experience with Oracle BI Publisher (BIP), including:
- Data models
- RTF and Excel templates
- Bursting
- Scheduled reports
- Parameterized reporting
- 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.
- 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.
- Proactive approach to identifying risks, data issues, and opportunities for improvement.
- Strong collaboration and mentoring skills.
- Customer‑service mindset with a commitment to delivering high‑quality client outcomes.
- Ability to communicate effectively with both technical and non‑technical audiences across Mexico and the United States.
Because we believe great professionals deserve great benefits:
- 15 days of year‑end bonus (Aguinaldo)
- 12 days of paid vacation + vacation premium
- Paid public holidays
- Overtime pay
- Social security (IMSS)
- 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
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
