SAP BI/BO Developer

Summary

The SAP BI/BO Developer is responsible for the design and development of SAP Business Intelligence (BI/BO 4.0+) data universes and reports leveraging data from multiple sources in support of project management decision-making.

Responsibilities
  • Maintain an in-depth knowledge of business practices and complex data sets.
  • Utilize database and technical knowledge to analyze and solve problems and create ad-hoc reports.
  • Responsible for design and maintenance of business intelligence entities, currently SAP Universes and Web Intelligence Reports.
  • Leverage business knowledge of data and data relationships in 6+ major database schemas to design data relationships and analyze and resolve issues.
  • Maintain ongoing comprehensive understanding of organizational business operations, information flow, and reporting needs.
  • Design custom Oracle database data views, scripts, procedures, and SAP report objects.
  • Meet with end-users to capture new business requirements for translation into custom universe and report elements.
  • Work with database administrators, web developers, and network administrators to ensure access to reports and up-to-date data.
  • Troubleshoot data issues using analysis and design of SQL queries utilizing filtering, sorting, grouping, bracketing, comparing, counting, ranking. and other methods.
  • Develop validation plans to ensure accuracy of data.
  • Provide guidance for future BI development.
  • Serve on various work teams to provide guidance on data and reporting plans.
  • Team Lead for Labor Cost Distribution Processing, database side, over four federal lands divisions - merging Delphi accounting system General Ledger (GL) payments with division project labor hours to create project accounting invoices in Delphi system.
  • Perform other development tasks as requested, including Crystal Reports, Dashboards, Adobe LiveCycle Designer Forms, and conversion of raw survey results into reports and metrics.
  • Develop and support Oracle Forms and Reports used for administration of leadership team objectives, including federal employee tracking, employee training, skill and discipline inventories, and organization and individual information.
  • Set user rights, roles, and other system settings on server consoles.
  • Design BI data universe combining all sets of project management data, including fund allocation, internal budgeting and approvals, and financial actuals and project controls system data.
  • Develop Web Intelligence reports relaying a full representation of project measures across data sets.
  • Design additional BI data universes and reports to support additional databases and applications, as well as several employee information data sets.
  • Primary resource for analyzing and troubleshooting data issues on all databases.
  • Provide training on applications and meet with users to observe user's experience and practices.
  • Other duties as assigned

Qualifications
  • High school diploma or GED
  • 6+ years of related experience as a database administrator, specializing in supporting Oracle and SQL environment
  • Background check required with the ability to obtain a public trust security clearance

Knowledge, Skills and Abilities
  • Ability to work independently and yet be effective within a team setting
  • Must be capable of managing multiple efforts with time related constraints in a fast-paced contracting environment
  • Demonstrated ability to effectively communicate and collaborate with diverse internal and external stakeholder groups and individuals
  • Friendly presence, helpful attitude, good interpersonal skills, and ability to work well with others
  • Excellent skills in Microsoft Word, Excel, and other Office applications
  • Experience working in a home office setting
  • Ability to train end users on frequently asked technical issues
  • Ability to provide technical assistance and support over the phone with good phone skills and a professional demeanor
  • Previous customer service experience strongly desired
  • Good problem-solving skills with the ability to visualize a problem or situation and think abstractly to solve it

#NJVC, LLC

Similar searches: Full Time, Administrative, Government and Public Services