HCM Analytics & BI Developer

Responsibilities:

• Design and develop Oracle OTBI dashboards delivering real-time workforce metrics including headcount, hiring pipelines, turnover trends, vacancy rates, and demographic insights across multiple federal agencies
• Build Oracle BI Publisher (BIP) reports and templates for structured submissions such as EHRI, GHRR, SF-113, and agency-driven HR compliance requirements
• Create advanced Oracle Analytics Cloud (OAC) dashboards with predictive modeling, trend analysis, and executive-level insights across agencies
• Configure and optimize HCM Extract processes for bulk data extraction and downstream analytics workflows
• Develop interactive org chart visualizations and workforce exploration tools enabling HR specialists and managers to easily navigate federal organizational hierarchies
• Deliver ad hoc reporting capabilities and self-service analytics for agency HR teams
• Build reporting solutions supporting government-wide mandates such as EEO/MD-715, FEVS analytics, DEIA reporting, and human capital accountability standards
• Ensure all analytics outputs meet Section 508 / WCAG 2.1 AA accessibility requirements
• Develop semantic layers and governed data models that ensure consistent definitions of workforce metrics and KPIs
• Translate human capital analytics requirements into detailed technical specifications, wireframes, and reporting architecture
• Support agency onboarding by developing agency-specific reporting templates, migrating historical data, and delivering analytics training
• Operate with significant independence, solving complex technical challenges and mentoring junior team members
• Lead small technical workstreams, conduct deliverable reviews, and guide best practices across Oracle Fusion Cloud HCM
• Qualifications: Required:
• Ability to obtain and maintain a Public Trust clearance (U.S. Citizenship required)
• Bachelor’s degree and 7 years of relevant experience (additional experience may substitute for degree)
• 7+ years of experience in business intelligence, analytics, or enterprise reporting
• 5+ years of hands-on experience with Oracle OTBI, Oracle BI Publisher, or similar enterprise BI tools (Power BI, Tableau, SAP BO)
• Strong SQL proficiency with experience writing analytical queries against large-scale HR/HCM datasets
• Experience building interactive dashboards with drill-downs, parameters, and dynamic visualizations
• Knowledge of core HR/workforce analytics topics such as headcount, attrition, time-to-fill, workforce planning, and span of control
• Experience developing accessible analytics meeting Section 508 / WCAG standards
• Familiarity with Agile/SAFe development practices
• Desired:
• 8+ years of BI development, ideally with Oracle Fusion HCM
• Certifications in Oracle Analytics Cloud or BI Publisher
• Experience with federal HR analytics, including EHRI, GHRR, or federal accountability reporting
• Deep understanding of Oracle Fusion HCM subject areas and data models
• Experience with predictive analytics tools such as R, Python, or OAC machine learning
• Knowledge of federal human capital frameworks, FEVS analytics, and DEIA workforce reporting
• Experience developing HCM Extract solutions for enterprise data warehousing
• Familiarity with Oracle Cloud technologies like OIC or OCI within HCM/ERP environments
• What You Can Expect:
• A culture of integrity.
• At CACI, we place character and innovation at the center of everything we do. As a valued team member, you’ll be part of a high-performing group dedicated to our customer’s missions and driven by a higher purpose – to ensure the safety of our nation.
• An environment of trust.
• CACI values the unique contributions that every employee brings to our company and our customers - every day. You’ll have the autonomy to take the time you need through a unique flexible time off benefit and have access to robust learning resources to make your ambitions a reality.
• A focus on continuous growth.
• Together, we will advance our nation's most critical missions, build on our lengthy track record of business success, and find opportunities to break new ground — in your career and in our legacy.
• Pay Range:
• There are a host of factors that can influence final salary including, but not limited to, geographic location, Federal Government contract labor categories and contract wage rates, relevant prior work experience, specific skills and competencies, education, and certifications. Our employees value the flexibility at CACI that allows them to balance quality work and their personal lives. We offer competitive compensation, benefits and learning and development opportunities. Our broad and competitive mix of benefits options is designed to support and protect employees and their families. At CACI, you will receive comprehensive benefits such as; healthcare, wellness, financial, retirement, family support, continuing education, and time off benefits.
• Since this position can be worked in more than one location, the range shown is the national average for the position.
• The proposed salary range for this position is:
• CACI is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, age, national origin, disability, status as a protected veteran, or any other protected characteristic.