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 – 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