Guidesoft Inc. dba Knowledge Services

  • Oracle BI Developer (contract to hire)

    Posted Date 3 months ago(3 months ago)
    Job ID
    Job City
    Job State
  • Overview

    Knowledge Services is actively seeking an Oracle BI Developer for a contract to hire opportunity with our client, the State of IN’s Department of Environmental Management. This position will be in Indianapolis, IN. Candidates must be eligible to convert to full time direct hires of the state without condition for sponsorship.


    This position will be responsible for the development and maintenance of reporting using Oracle BI Publisher. Primary duties include analyzing, writing and maintaining reports using Publisher.  Other duties include developing data visualization dashboards, consulting and assisting staff to determine problems and finding solutions, documenting and monitoring progress of the reports and systems, following schedules, completing assigned tasks within determined deadlines related to agency reporting needs.


    • Develop Oracle PL/SQL Packages for use in Oracle BI Publisher Reporting using RTF templates
    • Develop complex queries and procedures using PL/SQL and Oracle SQL Developer for reports based on report specifications
    • May develop dashboards and reports using Tableau
    • Develop report layouts based on objective of report with focus on usability, clarity, and audience
    • Work with DBAs and Business Analysts (BAs) to ensure that reports meet user requirements
    • May work directly with end users or with BA and Project Management (PM) support
    • Formally document report requirements
    • Work with Database Administrator (DBA) to optimize queries
    • Work with DBAs to develop needed data marts, queries, views, and reporting tables as part of a larger reporting platform initiative
    • Assist with ETL development, data mapping, and data migration documentation including documentation of business processes and how data is stored for new and/or modified applications, including operational procedures and manuals


     Windows Environment (Advanced) – 10+ years’ experience

    • Complete Windows environment for desktop and server


    MS Development (Advanced) – 5+ years’ experience

    • Experience with the Microsoft development stack including Visual Studio, .NET web and desktop development using C#, and SQL Server, and SQL Server Reporting Services preferred
    • Experience developing and using XML and Web Services is preferred
    • Experience mapping and migration tools like Altova MapForce or similar for ETL development is a preferred


    Data Visualization (Advanced) – 3+ years’ experience

    • Advanced knowledge of data visualization tools and techniques
    • Advanced knowledge and experience with data visualization approaches considering objectives, audience, and delivery
    • Experience with Tableau preferred


    Oracle Databases (Expert) – 7+ years’ experience

    • Thorough knowledge of data processing and database concepts; advanced development experience creating and using database objects in Oracle 11g and 12c specifically related to report development
    • Thorough knowledge and ability to analyze and understand entity relationship diagrams (ERDs) and metadata dictionaries for large complex datasets and schemas
    • Advanced experience and ability developing Oracle PL/SQL Packages for use in Oracle BI Publisher Reporting using RTF templates preferred


    SQL (Expert) – 7+ years’ experience

    • Advanced knowledge of SQL query optimization
    • Experience in developing ETLs, services, and migration applications for handling, transforming, and moving data for internal and external facing data is preferred
    • Thorough knowledge and ability to develop queries, procedures, and views for report development


    SDLC (Advanced) – 7+ years’ experience

    • Thorough knowledge of and experience in implementation of Systems Development Life Cycle is required


    Business Analysis (Advanced) – 5+ years’ experience

    • Thorough ability to perform advanced problem solving and analysis is required
    • Advanced knowledge and ability to create and develop layout and report design based on purpose of report and audience
    • Experience with requirements gathering with a focus on report development is required






    Physical Requirements:

    • Job frequently requires sitting, handling objects with hands.
    • Job occasionally requires standing, walking, reaching, talking, hearing, and lifting up to 25 pounds.
    • Vision requirements:  Ability to see information in print and/or electronically.


    We are an Equal Opportunity Employer. We do not discriminate on the basis of race, religion, color, sex, age, national origin or disability.




    Overview of Knowledge Services:

    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. 


    Knowledge Services has benefit offerings to include the following!


    • Medical, dental, and vision coverage
    • Voluntary Life and AD&D coverage
    • Pet Insurance
    • Ticket and Event discounts!
    • The above are available provided contractors meet eligibility requirements



    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.