No experience
Employment Type:
Full time
Job Category:
Information Services
See more jobs for students and recent grads who studied:
BI Engineer
Octapharma Plasma, Inc. | Charlotte, North Carolina
Tell Us More About Your Job Preferences
By telling us what you think of this job, we can help find jobs that match your interests. If you want to see more jobs like this, click on the smiley face. Or if this job isn't what you are looking for, click the frowny face. Learn More...

Follow This Company

Job Description

Business Intelligence – Data Warehouse – Architecting & Development

Job Responsibilities

We are seeking aBusiness Intelligence Engineer to join our growing biopharmaceutical company. Reporting into the Application Development Manager, this position is responsible for delivering Business Intelligence solutions as well as supporting, trouble shooting, implementing, and maintaining information systems to meet the company’s needs.

Additional responsibilities of the BI Engineer role include:

  • Assist in determining objectives and business requirements in anticipation of using BI and the data warehouse as a solution to drive business decisions.
  • Design/develop/implement comprehensive BI solutions (from data model to dashboards) to problems assuring system quality, integrity, and performance efficiency.
  • Plan, direct, monitor, and control new development, maintenance, and enhancement of BI interfaces, cubes, reports, dashboards and assigned software modules.
  • Prepare system specifications, data element identification, database design, detailed program specifications, and data model designs.
  • Assist in the development and compliance of departmental programming standards.
  • Analyze data model and interface design specifications for completeness and conformity to standards.
  • Write or oversee the writing of code in compliance with programming standards.
  • Prepare test data and test programs.
  • Delineate project activities from user requirements and system specifications.  Assist in the preparation of plans, schedules, and estimates for projects.
  • Provide support for BI, reporting and/or all assigned systems as needed.
  • Assist developers and provide data access guidance as needed.
  • Create SSRS reports with the data queried/provided.
  • Produce and maintain SQL programming objects such as stored procedures, user defined functions, common table expressions, scheduled SQL Agent jobs, and clustered/non-clustered/covering indexes.
  • Provide data back to the requesting business unit(s) and effectively communicate the results.
  • Help determine level of effort and time required for solution delivery.
  • Create documents and other artifacts to promote sustainable knowledge management within the organization.
  • Participate in on-call rotation and assist with after-hours issues as required.
Business Intelligence – Data Warehouse – Architecting & Development

Job Requirements

Qualified candidates of this role must offer a Bachelor’s degree in computer science or information systems. You must offer excellent communication, technical and project management skills.

Technical skills and experience required of the BI Engineerrole include:

  • 5+ years of experience with Microsoft SSAS/SSIS/SSRS.
  • 5+ years of experience extracting and transforming data within Business Intelligence environment.
  • 5+ years of experience with Microsoft SQL Server, including SQL Agent jobs, SSIS packages.
  • 5+ years of experience with SQL programming objects, including stored procedures, user defined functions, and common table expressions is required.
  • 3+ years of comprehensive data warehouse analysis and design experience, with full knowledge of data warehouse methodologies and data modeling.
  • 2+ years of experience with SharePoint PerformancePoint.
  • Must have a minimum of a MCSA Database certification.
  • Experience with mobile Business Intelligence solutions is a plus.
  • Database tuning and optimization experience is a plus.
  • Excellent partnering skills and ability to develop effective working relationships with various people in business, operations, and IT.
  • Ability to effectively gather and analyze requirements and concisely communicate results.
  • Working knowledge of full lifecycle application development.
  • H1B sponsorship not available


Business Intelligence – Data Warehouse – Architecting & Development

About Octapharma Plasma, Inc.

We believe the growth and success of each of our employees is an important part of the continued growth and success of our company. We create a workplace known for teamwork and recognition based on the following values: Customer Focus Leadership Integrity Team Spirit Self Respect Respect for Others Life Balance Safety

This company profile was created by AfterCollege and is about Octapharma Plasma, Inc.. This page is not endorsed by or affiliated with Octapharma Plasma, Inc.. For questions regarding company profiles, please email: care@aftercollege.com.