Rose International INC Business Intelligence Developer in Maryland Heights, Missouri

Desired Skill Set:

Cognos, Oracle, PL/SQL, SQL

Position Description:

Position Title: Senior Business Intelligence Specialist Duration: 3-6 month Right to Hire Location: Maryland Heights, MO 63043

“"U.S. Citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time."”

Education Level: Bachelor''s Degree


Business Analyst / Cognos BI developer that can support reporting and analytics within a large Data Warehouse environment. The following skills are pretty much a must from that perspective.

(Highlighted Items are required):

  • Domain Analysis experience using SQL or PL/SQL (Must have strong SQL, PL/SQL Skills).

  • Prior experience as a report programmer/ETL Analyst Specialist in support of large-scale data warehouse and reporting projects (2TB and above).

  • Business Requirements gathering and Analysis experience, as well as documentation.

  • Mapping experience to support ETL within a large Data Warehouse environment.

  • Creation / Execution / and Documentation of Test Plans for Transformation Processes.

  • Strong experience in creating and published packages in Framework Manager from various data sources. Prefer experience using multiple databases and tools and using leading or bleeding edge technologies. Familiarity with a broad range of database and Business Intelligence environments using IBM Cognos in Oracle, Netezza and SQL Server databases.

  • Working / hands-on knowledge of data warehousing and business intelligence concepts, including various forms of modeling (dimensional and relational) and warehousing strategies.

  • Well-versed in developing reporting applications using Cognos Business Intelligence components like Report Studio, Framework Manager, and Workspace Advanced. Must have minimum of 3-5 years developing with Cognos with a heavy concentration of experience in Cognos Framework Manager.

  • Good Communication Skills are a must in this position as well as some minor PM skills as in some cases they will be the main contact for any process they are working on

  • Strong experience in client interaction and understanding business application, business data flow and data relations from them.

  • Working with the development team on Process Flows for ETL processing.

  • Familiarity with Implementation Plans and Documentation.

  • Experience in documenting processes of this nature, in order to write Turnover Documentation to support this on our Production Support Team.

As far as Tools that our staff is currently using, most are listed below:

  • Embarcadero Rapid SQL.

  • Quest Toad.

  • Cognos BI Suite (Framework Manager, Report Studio, Workspace Advanced).

  • Microsoft Suite (MS Word, Excel, Project, Visio, Power Point, Outlook and Access).

Our environments are broken out at about 65% Oracle, and 20% SQL, and 15% Netezza - so skills in Oracle and SQL are a must, with Netezza being a nice to have.


  • Participates in Business Intelligence projects, and works with analytical group and IT to ensure implementation using agile methodologies. (Scrum/Kanban).

  • Proven track record to drive rapid prototyping and design for new projects and analytic R&D; environments. Ability to translate broader business initiatives into clear team objectives and concrete individual goals, aligning appropriately with other groups for efficient, coordinated action.

  • Experience with other tools and technologies like Java Script, R programming, Mongo DB, QlikView, Tableau, Snap logic etc would be a plus.


Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, arrest and conviction records, or any other characteristic protected by law. Positions located in San Francisco, California will be administered in accordance with the Fair Chance Ordinance.

Position Title: Business Intelligence Developer

Position Number: 243301

Location: Maryland Heights, MO