Octapharma Plasma, Inc.
Data Engineer
Octapharma Plasma, Inc., Charlotte, North Carolina, United States, 28245
Charlotte Corporate10644 Westlake DriveCharlotte, NC 28273, USA
Octapharma Plasma offers professional opportunities that make a meaningful difference. We enhance the lives of patients who need our life-saving medicines. We reward the donors who provide the plasma we collect to make them. And we inspire growth and development in the teams at our donation centers, offices, and labs. We invite you to do the same in this role:Charlotte, North CarolinaThis Is What You’ll Do:We are seeking a Data Engineer to join our growing biopharmaceutical company. Reporting to the Business Intelligence Manager of Development, this position is responsible for analyzing, designing, developing, implementing, maintaining, and supporting SSIS Scripts, Stored Procedures, and other related ETL structures to meet the company’s needs.Additional responsibilities of the Data Engineer role include:Consulting with data management teams to get a big-picture idea of the company’s data storage needs.Presenting the company with warehousing options based on their storage needs.Designing and coding the data warehousing system to desired company specifications.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.Conducting preliminary testing of the warehousing environment before data is extracted.Extracting company data and transferring it into the new warehousing environment.Testing the new storage system once all the data has been transferred.Troubleshooting any issues that may arise.Providing maintenance support.Help determine level of effort and time required for solution delivery.Create documents and other artifacts to promote sustainable knowledge management within the organization.This Is Who You Are:A natural leader who displays strong character and integrity.An excellent communicator and team player.A person committed to excellent customer service all day, every day.Excellent technical, conceptual, interpersonal, written, and verbal communication skills.Work well under pressure and with demanding deadlines and demonstrates ability to adapt to changing priorities and respond to problems creatively.A decision-maker with the ability to positively influence people.This Is What It Takes:Bachelor degree in computer science or information systems science, or equivalent experience and a minimum of four (4) years’ experience in design, programming, database design, and communication techniques.Must have a minimum of four (4) years of experience extracting and transforming data within a Business Intelligence environment.Two (2) + years of experience with Microsoft SQL Server, including SQL Agent jobs, SSIS packages.Two (2) + years of experience with SQL programming objects, including stored procedures, user-defined functions, and common table expressions.Two (2) + years of experience with SharePoint PerformancePoint.Two (2) + years of experience with database tuning and optimization.Three (3) + years of comprehensive data warehouse analysis and design experience, with full knowledge of data warehouse methodologies and data modeling.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.More About Octapharma Plasma, Inc.With donation centers and team members throughout the U.S., Octapharma Plasma, Inc. collects plasma to create life-saving medicines for patients worldwide. We are growing at an impressive pace, and so is the positive impact of our work. Our community relies on teamwork, compassion, and expertise to get things done the right way, while making a meaningful difference in the lives we touch.Interested? Learn more online and apply now at:octapharmahiring.com
#J-18808-Ljbffr
Octapharma Plasma offers professional opportunities that make a meaningful difference. We enhance the lives of patients who need our life-saving medicines. We reward the donors who provide the plasma we collect to make them. And we inspire growth and development in the teams at our donation centers, offices, and labs. We invite you to do the same in this role:Charlotte, North CarolinaThis Is What You’ll Do:We are seeking a Data Engineer to join our growing biopharmaceutical company. Reporting to the Business Intelligence Manager of Development, this position is responsible for analyzing, designing, developing, implementing, maintaining, and supporting SSIS Scripts, Stored Procedures, and other related ETL structures to meet the company’s needs.Additional responsibilities of the Data Engineer role include:Consulting with data management teams to get a big-picture idea of the company’s data storage needs.Presenting the company with warehousing options based on their storage needs.Designing and coding the data warehousing system to desired company specifications.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.Conducting preliminary testing of the warehousing environment before data is extracted.Extracting company data and transferring it into the new warehousing environment.Testing the new storage system once all the data has been transferred.Troubleshooting any issues that may arise.Providing maintenance support.Help determine level of effort and time required for solution delivery.Create documents and other artifacts to promote sustainable knowledge management within the organization.This Is Who You Are:A natural leader who displays strong character and integrity.An excellent communicator and team player.A person committed to excellent customer service all day, every day.Excellent technical, conceptual, interpersonal, written, and verbal communication skills.Work well under pressure and with demanding deadlines and demonstrates ability to adapt to changing priorities and respond to problems creatively.A decision-maker with the ability to positively influence people.This Is What It Takes:Bachelor degree in computer science or information systems science, or equivalent experience and a minimum of four (4) years’ experience in design, programming, database design, and communication techniques.Must have a minimum of four (4) years of experience extracting and transforming data within a Business Intelligence environment.Two (2) + years of experience with Microsoft SQL Server, including SQL Agent jobs, SSIS packages.Two (2) + years of experience with SQL programming objects, including stored procedures, user-defined functions, and common table expressions.Two (2) + years of experience with SharePoint PerformancePoint.Two (2) + years of experience with database tuning and optimization.Three (3) + years of comprehensive data warehouse analysis and design experience, with full knowledge of data warehouse methodologies and data modeling.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.More About Octapharma Plasma, Inc.With donation centers and team members throughout the U.S., Octapharma Plasma, Inc. collects plasma to create life-saving medicines for patients worldwide. We are growing at an impressive pace, and so is the positive impact of our work. Our community relies on teamwork, compassion, and expertise to get things done the right way, while making a meaningful difference in the lives we touch.Interested? Learn more online and apply now at:octapharmahiring.com
#J-18808-Ljbffr