Byram Healthcare Sr Bl & Warehouse Analyst in White Plains, NY at Byram Healthcare

Date Posted: 5/26/2018

Job Snapshot

Job Description



Implements and develops ongoing needs of Byram's Cognos Analytics (Cognos 11) business intelligence platform. Serves in both Cognos development and administrative capacities to build and maintain reporting and analytic applications and support continued growth of the platform. Develops high quality extraction/transformation/load (ETL) programs, creating logical and physical data models, data flow diagrams, entity relationship diagrams and building business intelligence reports using Cognos BI, SQL Server and SQL Server Integration Services (SSIS).


1.       Provides assistance in the ongoing maintenance and administration of the Cognos application and data warehouses, including: user security management; software release management; end user and technical issue troubleshooting; system software upgrade planning; and Cognos portal design and organization.

2.       Works closely with internal business leads and technical resources to design, develop, and maintain Cognos framework and Transformer models; to create and deploy reporting and analytic packages; as well as, to develop reporting content such as reports, dashboards, etc.

3.       Designs and develops enterprise and departmental business intelligence, data warehousing and reporting solutions.

4.       Designs and develops Framework models for ad-hoc query, drill-down, static reporting, managed queries, and dashboards.

5.       Develops standard reporting templates including multi-page reports that utilize prompts.

6.       Converts existing report platforms to Cognos Analytics 11.

7.       Serves as a reporting technical resource and support all reporting activities throughout the development lifecycle.

8.       Cognos administration and user setup.

9.       Tunes up and optimizes the reporting solution.

10.   Designs, develops, tests, implements and manages complex ETL processes sourcing data from a variety of internal and external systems.

11.   Uses expert knowledge in database and report performance engineering to diagnose and tune ETL programs and reports.

12.   Designs, develops, maintains and publishes logical and physical data models, entity relationship diagrams and a common data dictionary.


1.      Performs additional duties as directed.



  • Bachelor's Degree
  • Five or more years of experience working with relational databases
  • At least four years of experience in Cognos development and administration, Framework Manager, Report Studio, Query Studio, Transformer Cubes and Dynamic Cubes
  • SQL development experience
  • Experience with ETL tools such as Microsoft SQL Server Integration Services/SSIS Packages and visual studio
  • Experience in Cognos 11
  • Experience using the Kimball methodologies is a plus


  • Has a passion for data, reporting, analytics and data warehousing
  • Effective communication skills necessary


  • Little or no traveling required (less than 10%)

Not Ready To Apply?

Joining our Talent Network will enhance your job search and application process. Whether you choose to apply or just leave your information, we look forward to staying connected with you.