Director Oracle Analytics
Paramount · New York, NY · 3 wk ago
On-siteAnalyst$157k–$210k/yrFull-time
We need to output HTML fragment with sections: h3 headings for sections present: About the role? The posting has "Role Overview". Could map to "About the role". Also "Key Responsibilities". "Required Qualifications". "Preferred Qualifications". "Additional Information" includes salary range, benefits, etc. We need to include sections only if real content. So we will have sections: About the role (from Role Overview), Responsibilities (Key Responsibilities), Requirements (Required Qualifications), Qualifications (Preferred Qualifications), Benefits (benefits listed), Pay (salary range), maybe Schedule not present, so omit. Also maybe "Additional Information" includes other details like company description; but we can fold into About the role or maybe not needed as separate. We must not repeat job title. Must not include metadata like Job ID. Must remove boilerplate: EEO, legal, application instructions, etc. Also remove duplicated lines. Must preserve all substantive info.
We need to use
- for any list of duties/requirements/benefits. Use
for prose. We need to include h3 headings exactly: e.g.,
About the role
,Responsibilities
,Requirements
,Qualifications
,Benefits
,Pay
. Ensure we don't add empty sections. Now extract content. Role Overview paragraph: "We are seeking an experienced and strategic Oracle Fusion Analytics Director to serve as our primary Subject Matter Expert (SME) for all reporting and analytics across Oracle Fusion Financials and Human Capital Management (HCM). In this role, you will bridge the gap between business needs and technical execution, transforming complex ERP and HCM data into actionable insights. You will own the end-to-end reporting architecture, leveraging your deep expertise in Fusion Data Intelligence (FDI), Oracle BI Publisher, Oracle Transactional Business Intelligence (OTBI), Financial Reporting Studio (FRS), and SmartView to enable our finance and HR teams with high-quality, reliable, and scalable reporting solutions." That's prose ->. Responsibilities: list under "Key Responsibilities" with subheadings: Strategic Leadership & SME Guidance, Design & Development, Support & Continuous Improvement. Each has bullet points. We need to output a
- list. Should we keep subheadings inside li? Probably just list each bullet as li. Could include the subheading as part of li text. We'll preserve all details.
Let's extract bullet points:
Strategic Leadership & SME Guidance:
- Act as the primary Reporting SME for Oracle Cloud Financials (GL, AP, AR, FA, Cash Management) and Oracle Cloud HCM (Core HR, Recruitment, Compensation, Payroll, Talent Management).
- Partner with cross-functional business leaders to understand strategic objectives and translate them into robust analytical solutions.
- Define and enforce best practices, naming conventions, and governance standards for enterprise reporting.
- Lead the transition from legacy reporting systems to modern Oracle Fusion Analytics frameworks.
Design & Development:
- Fusion Data Intelligence (FDI): Design, build, and deploy interactive dashboards, KPIs, and data visualizations.
- Extend FDI pre-built content by bringing in external data sources or custom Fusion objects.
- Oracle BI Publisher: Architect and develop pixel-perfect, highly formatted operational reports, documents, and bursting configurations.
- Financial Reporting Studio (FRS): Construct complex, compliance-ready financial statements (e.g., Balance Sheets, Income Statements, Cash Flow).
- SmartView: Develop custom SmartView templates and train finance business users on multi-dimensional ad-hoc analysis.
- Write and optimize complex SQL queries to extract and manipulate data from Oracle Cloud infrastructure.
Support & Continuous Improvement:
- Manage the full reporting lifecycle: requirements gathering, design, testing, deployment, and post-production support.
- Troubleshoot and resolve complex data, security, and performance issues within the reporting environments.
- Stay current with Oracle's quarterly release cycle, assessing new analytics features and guiding the business on adoption.
We'll put all these as li items.
Requirements (Required Qualifications):
- Experience: 10+ years of hands-on experience in Oracle BI/Analytics, with at least 3+ years specifically leading reporting solutions in an Oracle Fusion Cloud environment.
- Tool Expertise: Deep, verifiable proficiency in: Fusion Data Intelligence (FDI) / Oracle Analytics Cloud (OAC) Oracle BI Publisher (Data models, RTF/eText templates, bursting) Financial Reporting Studio (FRS) OTBI (Oracle Transactional Business Intelligence) reports in Fusion Oracle SmartView for Office
- Domain Knowledge: Strong understanding of the underlying data models, tables, and subject areas for both Oracle Cloud Financials and Oracle Cloud HCM.
- Technical Skills: Advanced SQL skills and experience with OTBI (Oracle Transactional Business Intelligence).
- Communication: Excellent verbal and written communication skills, with the ability to explain complex technical concepts to non-technical business stakeholders.
We'll list each as li.
Preferred Qualifications:
- Bachelor’s or Master’s degree in Computer Science, Information Systems, Finance, or a related field.
- Relevant Oracle Certifications (e.g., Oracle Cloud Infrastructure, Oracle Analytics Cloud).
- Experience configuring data security and role-based access controls.
Benefits: from Additional Information: "The benefits available for this position include medical, dental, vision, 401(k) plan, life insurance coverage, disability benefits, tuition assistance program and PTO or, if applicable, as otherwise dictated by the appropriate Collective Bargaining Agreement. This position is bonus eligible." Also later: "What We Offer: Attractive compensation and comprehensive benefits packages. Check out our full list of benefits here: https://www.paramount.com/careers/benefitsGenerous paid time off. An exciting and fulfilling opportunity to be part of one of Paramount’s most dynamic teams. Opportunities for both on-site and virtual engagement events. Unique opportunities to make meaningful connections and build a vibrant community, both inside and outside the workplace."
We need to extract substantive benefits: medical, dental, vision, 401(k) plan, life insurance coverage, disability benefits, tuition assistance program, PTO, bonus eligible. Also generous paid time off (maybe same as PTO). Also mention opportunities etc but those are not benefits per se but could be considered benefits? The instruction: include Benefits section only if posting actually states them. It does state benefits list. We'll include those.
We'll create
- for each benefit.
Pay: Hiring Salary Range: $157,000.00 - 210,000.00. Also note starting pay depends on factors. We'll include that as prose maybe
. Since it's a single range, we can put in
. Schedule: not present, omit. Also we might include a short paragraph about location? The posting includes Location: [New York/LA/SFO]. Should we include? It's metadata but maybe considered substantive. The instruction: do NOT put Job ID / requisition numbers as headings — fold minor metadata into a short
or drop it. Location is minor metadata; we could fold into a short p under About the role or separate? Probably include as a brief p after About the role? But we must not create extra sections. Could add a
after About the role: "Location: New York, Los Angeles, or San Francisco." However the instruction says "fold minor metadata into a short
or drop it." So we can add a
after About the role. We must not include boilerplate like EEO, equal opportunity, scam warning, etc. Also remove duplicated lines, navigation, cookie, legal. Now produce HTML fragment. Structure:
About the role
We are seeking an experienced and strategic Oracle Fusion Analytics Director to serve as our primary Subject Matter Expert (SME) for all reporting and analytics across Oracle Fusion Financials and Human Capital Management (HCM). In this role, you will bridge the gap between business needs and technical execution, transforming complex ERP and HCM data into actionable insights. You will own the end-to-end reporting architecture, leveraging your deep expertise in Fusion Data Intelligence (FDI), Oracle BI Publisher, Oracle Transactional Business Intelligence (OTBI), Financial Reporting Studio (FRS), and SmartView to enable our finance and HR teams with high-quality, reliable, and scalable reporting solutions.
Location: New York, Los Angeles, or San Francisco.
Responsibilities
- Act as the primary Reporting SME for Oracle Cloud Financials (GL, AP, AR, FA, Cash Management) and Oracle Cloud HCM (Core HR, Recruitment, Compensation, Payroll, Talent Management).
- Partner with cross-functional business leaders to understand strategic objectives and translate them into robust analytical solutions.
- Define and enforce best practices, naming conventions, and governance standards for enterprise reporting.
- Lead the transition from legacy reporting systems to modern Oracle Fusion Analytics frameworks.
- Fusion Data Intelligence (FDI): Design, build, and deploy interactive dashboards, KPIs, and data visualizations.
- Extend FDI pre-built content by bringing in external data sources or custom Fusion objects.
- Oracle BI Publisher: Architect and develop pixel-perfect, highly formatted operational reports, documents, and bursting configurations.
- Financial Reporting Studio (FRS): Construct complex, compliance-ready financial statements (e.g., Balance Sheets, Income Statements, Cash Flow).
- SmartView: Develop custom SmartView templates and train finance business users on multi-dimensional ad-hoc analysis.
- Write and optimize complex SQL queries to extract and manipulate data from Oracle Cloud infrastructure.
- Manage the full reporting lifecycle: requirements gathering, design, testing, deployment, and post-production support.
- Troubleshoot and resolve complex data, security, and performance issues within the reporting environments.
- Stay current with Oracle's quarterly release cycle, assessing new analytics features and guiding the business on adoption.
Requirements
- Experience: 10+ years of hands-on experience in Oracle BI/Analytics, with at least 3+ years specifically leading reporting solutions in an Oracle Fusion Cloud environment.
- Tool Expertise: Deep, verifiable proficiency in: Fusion Data Intelligence (FDI) / Oracle Analytics Cloud (OAC) Oracle BI Publisher (Data models, RTF/eText templates, bursting) Financial Reporting Studio (FRS) OTBI (Oracle Transactional Business Intelligence) reports in Fusion Oracle SmartView for Office
- Domain Knowledge: Strong understanding of the underlying data models, tables, and subject areas for both Oracle Cloud Financials and Oracle Cloud HCM.
- Technical Skills: Advanced SQL skills and experience with OTBI (Oracle Transactional Business Intelligence).
- Communication: Excellent verbal and written communication skills, with the ability to explain complex technical concepts to non-technical business stakeholders.
Qualifications
- Bachelor’s or Master’s degree in Computer Science, Information Systems, Finance, or a related field.
- Relevant Oracle Certifications (e.g., Oracle Cloud Infrastructure, Oracle Analytics Cloud).
- Experience configuring data security and role-based access controls.
Benefits
- Medical insurance
- Dental insurance
- Vision insurance
- 401(k) plan
- Life insurance coverage
- Disability benefits
- Tuition assistance program
- Paid time off (PTO)
- Bonus eligible
Pay
Hiring salary range: $157,000.00 – $210,000.00 (starting pay depends on geographic location, market demands, experience, training, and education).
Check
- for each benefit.
Pay: Hiring Salary Range: $157,000.00 - 210,000.00. Also note starting pay depends on factors. We'll include that as prose maybe
- list. Should we keep subheadings inside li? Probably just list each bullet as li. Could include the subheading as part of li text. We'll preserve all details.
Let's extract bullet points:
Strategic Leadership & SME Guidance:
- Act as the primary Reporting SME for Oracle Cloud Financials (GL, AP, AR, FA, Cash Management) and Oracle Cloud HCM (Core HR, Recruitment, Compensation, Payroll, Talent Management).
- Partner with cross-functional business leaders to understand strategic objectives and translate them into robust analytical solutions.
- Define and enforce best practices, naming conventions, and governance standards for enterprise reporting.
- Lead the transition from legacy reporting systems to modern Oracle Fusion Analytics frameworks.
Design & Development:
- Fusion Data Intelligence (FDI): Design, build, and deploy interactive dashboards, KPIs, and data visualizations.
- Extend FDI pre-built content by bringing in external data sources or custom Fusion objects.
- Oracle BI Publisher: Architect and develop pixel-perfect, highly formatted operational reports, documents, and bursting configurations.
- Financial Reporting Studio (FRS): Construct complex, compliance-ready financial statements (e.g., Balance Sheets, Income Statements, Cash Flow).
- SmartView: Develop custom SmartView templates and train finance business users on multi-dimensional ad-hoc analysis.
- Write and optimize complex SQL queries to extract and manipulate data from Oracle Cloud infrastructure.
Support & Continuous Improvement:
- Manage the full reporting lifecycle: requirements gathering, design, testing, deployment, and post-production support.
- Troubleshoot and resolve complex data, security, and performance issues within the reporting environments.
- Stay current with Oracle's quarterly release cycle, assessing new analytics features and guiding the business on adoption.
We'll put all these as li items.
Requirements (Required Qualifications):
- Experience: 10+ years of hands-on experience in Oracle BI/Analytics, with at least 3+ years specifically leading reporting solutions in an Oracle Fusion Cloud environment.
- Tool Expertise: Deep, verifiable proficiency in: Fusion Data Intelligence (FDI) / Oracle Analytics Cloud (OAC) Oracle BI Publisher (Data models, RTF/eText templates, bursting) Financial Reporting Studio (FRS) OTBI (Oracle Transactional Business Intelligence) reports in Fusion Oracle SmartView for Office
- Domain Knowledge: Strong understanding of the underlying data models, tables, and subject areas for both Oracle Cloud Financials and Oracle Cloud HCM.
- Technical Skills: Advanced SQL skills and experience with OTBI (Oracle Transactional Business Intelligence).
- Communication: Excellent verbal and written communication skills, with the ability to explain complex technical concepts to non-technical business stakeholders.
We'll list each as li.
Preferred Qualifications:
- Bachelor’s or Master’s degree in Computer Science, Information Systems, Finance, or a related field.
- Relevant Oracle Certifications (e.g., Oracle Cloud Infrastructure, Oracle Analytics Cloud).
- Experience configuring data security and role-based access controls.
Benefits: from Additional Information: "The benefits available for this position include medical, dental, vision, 401(k) plan, life insurance coverage, disability benefits, tuition assistance program and PTO or, if applicable, as otherwise dictated by the appropriate Collective Bargaining Agreement. This position is bonus eligible." Also later: "What We Offer: Attractive compensation and comprehensive benefits packages. Check out our full list of benefits here: https://www.paramount.com/careers/benefitsGenerous paid time off. An exciting and fulfilling opportunity to be part of one of Paramount’s most dynamic teams. Opportunities for both on-site and virtual engagement events. Unique opportunities to make meaningful connections and build a vibrant community, both inside and outside the workplace."
We need to extract substantive benefits: medical, dental, vision, 401(k) plan, life insurance coverage, disability benefits, tuition assistance program, PTO, bonus eligible. Also generous paid time off (maybe same as PTO). Also mention opportunities etc but those are not benefits per se but could be considered benefits? The instruction: include Benefits section only if posting actually states them. It does state benefits list. We'll include those.
We'll create