No experience
Employment Type:
Full time
Job Category:
Information Services
BI Engineer
(This job is no longer available)
Octapharma Plasma, Inc. | Charlotte, NC
Grad Date

Not sure what types of jobs you are interested in?

Explore Jobs
Based on Your Education

Follow This Company

Job Description

Business Intelligence Engineer

Job Responsibilities

We are seeking aBusiness Intelligence Engineer to join our growing biopharmaceutical company. Reporting into the Business Intelligence Supervisor, 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 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 seond tier support for BI, reporting and/or all assigned systems as needed.
  • Assist developers and provide data access guidance as needed.
  • Create reports and dashboards with the technologies available at Octapharma Plasma.
  • 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.
  • Create ETL packages to load the data into the data warehouse with the technologies available at Octapharma Plasma. 
Business Intelligence 

Job Requirements

Qualified candidates of this role must offer a Bachelor’s degree in computer science or information systems, or equivalent experience and a minimum of four (4) years' expereince in design, programming, database design, and communication techniques.

Technical skills and experience required of the BI Engineerrole include:

  • 4+ years of experience with Microsoft SSAS/SSIS/SSRS.
  • 4+ years of experience extracting and transforming data within Business Intelligence environment.
  • 2+ years of experience with Microsoft SQL Server, including SQL Agent jobs, SSIS packages.
  • 2+ years of experience with SQL programming objects, including stored procedures, user defined functions, and common table expressions.
  • 2+ years of comprehensive data warehouse analysis and design experience, with full knowledge of data warehouse methodologies and data modeling.
  • 2+ years of experience in Microstrategy report and dashboard development. 
  • Must have working knowledge of general business, quality/regulatory requirements, and/or manufacturing systems.
  • Must demonstrate proficiency with technical, conceptual, interpersonal, written, and verbal communication skills..
  • Must demonstrate ability to adapt to changing priorities and respond to problems creatively. 
  • Participate in on-call rotation and assist with after-hours issues, as required. 
  • 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