The site navigation utilizes arrow, enter, escape, and space bar key commands. Left and right arrows move across top level links and expand / close menus in sub levels. Up and Down arrows will open main level menus and toggle through sub tier links. Enter and space open menus and escape closes them as well. Tab will move on to the next part of the site rather than go through menu items.
Coordinate activities to optimize the Duke Health Technology Solutions (DHTS) Service Based Costing (SBC) and Reporting functions. This includes the management of the overall process for generating internal and external allocations for the annual budgeting process, preparation of the cost allocation financial reporting deliverables, and participation in the development and management of service pricing and expenses for Community Connect partners. This role will also partner with DHTS Service Owners and service operations managers to audit and evaluate consumption data models that will ultimately be used to generate appropriate cost metrics serving as the basis to charge customers at the appropriate service levels. This role will also be critical in continuing to enhance and evolve the organization's service pricing model as the IT organization continues to evolve while maintaining a consistent pricing structure for IT customers.
In addition to the SBC activities, this role will support the maintenance and database administration functions of the Apptio Technology Business Management tool (including its various modules). Apptio is critical in managing several of DHTS's finance related functions such as budget management, forecasting, service consumption reporting, and tracking cost investments made in applications and infrastructure. This role will be responsible for developing and integrating other functionality available within Apptio in order to optimize transparency, value, and cost savings/cost avoidance.
A successful applicant must possess the ability to adapt to a constantly evolving environment, possess relevant accounting and audit experience, and be very detail oriented. Prior experience with Duke Health entities is a plus.
Service Based Costing Allocations:
Formally document the Service Operations financial costing strategy, related processes, and overall assumptions
Coordinate annually with the DHTS Service Owners to review, validate, and assist with the refinement of the service models and service level metrics
Continuously evaluate the need for new cost allocation methodologies, assist with implementing change in these areas, and identify any weaknesses in current service level allocation methodologies as business models change
Manage the cost allocation process to facilitate allocating service consumption to the appropriate customers (internal and external) based on a calculated unit price
Facilitate customer reviews and validation of annual statistics
Prepare the annual budget allocation booklet for entity CFOs
Partner with DHTS financial analysts to ensure a shared understanding of charges to customers
Participate in Community Connect projects to develop and manage customer service cost budgets, work with the DHTS community connect team to understand circumstances and restrictions that may impact these financial estimates, and research and evaluate various complex scenarios
Provide required allocation related financial reports as needed
Perform other related duties incidental to the work described herein
Apptio TBM Database Administration:
Transfer allocation metrics and statistics into Apptio annually and as needed during the year
Validate the monthly transfer of consumption data from Service Now
Validate the upload of monthly financial data from SAP
Create and manage database reports, visualizations, and dashboards
Create automation for repeating database tasks
Diagnose, troubleshoot, and correct database errors
Install, upgrade, and manage database applications
Manage database access
Performance tuning of database systems.
Recommend and implement emerging database technologies via Apptio Community
Provide customer database support as needed
Complete necessary training to obtain an Apptio TBMA Certification
Business Information Systems or Computer Science also desired as a related field;
Minimum of 3 years Business Information Systems or Database administration experience highly desired, but not required.
Auditing experience is preferred but not required.
Knowledge, Skills, and Abilities: High proficiency with Microsoft Excel in order to build complex formulas and pivot tables.
Distingushing Charateristics of this Level: Highly detailed oriented, able to multitask an work independtly in a fast-paced enviornment.
Required Qualifications at this Level
Education: Work requires a Bachelor's degree in Accounting, Finance, Economics, Business Administration or a related field. CPA is desirable.
Experience: Work requires a minimum of six year's experience in financial management, cost accounting or a field directly related to specialized area of assignment.
Degrees, Licensure, and/or Certification: N/A
Knowledge, Skills, and Abilities: N/A
Distinguishing Characteristics of this Level
Job Code: 00005043 FINANCIAL ANALYST III Job Level: G2
Duke is an Affirmative Action/Equal Opportunity Employer committed to providing employment opportunity without regard to an individual's age, color, disability, gender, gender expression, gender identity, genetic information, national origin, race, religion, sex, sexual orientation, or veteran status.
Duke aspires to create a community built on collaboration, innovation, creativity, and belonging. Our collective success depends on the robust exchange of ideas—an exchange that is best when the rich diversity of our perspectives, backgrounds, and experiences flourishes. To achieve this exchange, it is essential that all members of the community feel secure and welcome, that the contributions of all individuals are respected, and that all voices are heard. All members of our community have a responsibility to uphold these values.
Essential Physical Job Functions: Certain jobs at Duke University and Duke University Health System may include essential job functions that require specific physical and/or mental abilities. Additional information and provision for requests for reasonable accommodation will be provided by each hiring department.
As a world-class academic and health care system, Duke Health strives to transform medicine and health locally and globally through innovative scientific research, rapid translation of breakthrough discoveries, educating future clinical and scientific leaders, advocating and practicing evidence-based medicine to improve community health, and leading efforts to eliminate health inequalities.