Guidesoft Inc. dba Knowledge Services

Oracle BI Consultant

1 month ago
Job ID
Job City
Carson City
Job State


Knowledge Services offers a great Senior level Oracle BI Programmer Analyst opportunity for a 12 month contract with possible extention. 70% development - re-engineering/discovery/redesign and 30% data modeling.


Knowledge Services,  established in 1994 and headquartered in Indianapolis IN, is a certified woman-owned (WBE) professional services organization with over 1500 employees located in offices throughout North America.  Founded by Julie Bielawski, CEO, Guidesoft, Inc. DBA Knowledge Services is an industry leader in Managed Service Programs (MSP), Employer of Record / Payrolling Services, National Recruitment, and Staffing Services.  We provide outstanding services to major organizations in various industries, including; IT, Healthcare, Entertainment, Media, Federal and State Governments, Public Utilities, Telecom, Manufacturing and more.


As such, Knowledge Services is committed to providing opportunities for growth – in our company, in each team member and in our relationships.  We believe titles do not define a person, but provide a framework to each person’s endless potential.  Our focus on improving our team, product and processes drive us every day.  We are guided by our four Pillars that set the foundation of who we are and how we conduct business:  Knowledge, Integrity, Innovation, and Service. 



Our client organization is seeking a Senior Oracle BI Programmer Analyst opportunity on a long-term contract basis.





Consultant must have the capability to perform the following functions:


  • Coordinate and work with other vendors;
  • Coordinate and work with client staff and contractors
  • Requirements gathering on the business side;
  • Requirements gathering on the technical side;
  • Review existing documentation;
  • Thorough analysis and re-engineering of current model and processes;
  • Thorough analysis of current model of separate databases;
  • Thorough analysis of the multiple field data collection processes;
  • Thorough analysis of the lack of field validation events on field data collection processes;
  • Data model design;
  • All phases of data model lifecycle including QA;
  • Data mart and database design;
  • All phases of data mart lifecycle including QA;
  • Data load process design and implementation for the databases;
  • Automation of the database load process;
  • Propose transition efforts to achieve rollout;
  • Thorough analysis of the current application interfaces;
  • Thorough analysis of the current reporting interfaces; and
  • Implement approved modifications to system.


  • Analyze and re-design the system and implement an updated model with improvements to data collection and data management, database and data mart design, and the associated system and application interfaces.
  • There will be approximately 70% development and 30% data modeling. The 70% comes from the re-engineering/discovery/redesign that needs to be done.
  • The agency uses Oracle Data Integrator (aka ODI) for ETL purposes. The agency uses Toad and SQL Developer for data modeling purposes.




  • Strong knowledge with five (5) years of experience using Oracle 11g with PL/SQL in a Windows based environment and strong knowledge with experience using SQL Server 2014;
  • Three (3) years of experience in business and technical requirements gathering and translating those requirements into effective data design;
  • Five (5) years of experience in the implementation of data marts, data mart lifecycles, and systems using data marts is essential;
  • Three (3) years knowledge of Oracle Business Intelligence Enterprise Edition Suite (OBIEE, 11g); Oracle Data Integrator (ODI), TOAD is essential;
  • Five (5) years knowledge of PC-based data tools (MS Excel, MS Access and XML file formats);
  • Excellent English written and verbal communication skills. Prefer experience with Oracle 12C




Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Need help finding the right job?

We can recommend jobs specifically for you! Click here to get started.