Sr. Data Engineer

 

 

There are so many ways Octapharma Plasma can enhance your life and your career. Our strong growth is creating great learning and career development opportunities throughout our company, and especially our donation centers. Because you’re someone who loves to learn, enjoys people, and has a real heart to help, we encourage you to join us as a:

 

 

We are seeking a Sr. 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 Data Delivery systems to meet the company’s needs.

Additional responsibilities of the Sr. Data Engineer role include:

• Lead the design, development, and optimization of ETL workflows and data pipelines using SQL Server and stored procedures.
• Utilize stored procedures for data extraction, transformation, and loading processes, ensuring optimal performance.
• Architect and implement data solutions on Azure, leveraging Azure Data Lake and other services.
• Apply dimension modeling principles to create data models that support advanced analytics and reporting requirements.
• Collaborate with stakeholders to understand data needs and translate them into technical solutions.
• Lead and set the direction for data engineering initiatives, ensuring alignment with overall business objectives.
• Mentor and guide junior data engineers, fostering their growth and technical development.
• Implement DevOps practices for data engineering to streamline CI/CD pipelines.
• Utilize Python for data manipulation, automation, and custom data solutions.
• Ensure data quality and consistency through data integration, transformation, and cleansing.
• Participate in on-call rotation and assist with after-hours issues, as required

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

Technical skills and experience required of the Sr. Data Engineer role include:

• Bachelor’s degree in computer science or information systems science, or equivalent experience.
• Seven (7) years of comprehensive data warehouse analysis and design experience, with full knowledge of data warehouse methodologies and data modeling.
• Must have a minimum of two (2) years of experience extracting and transforming data within Business Intelligence environment.
• Seven (7) years of experience with Microsoft SQL Server, including SQL Agent jobs, SSIS packages.
• Seven (7) years of experience with SQL programming objects, including stored procedures, user-defined functions, and common table expressions.
• Seven (7) years of experience with database tuning and optimization.
• Seven (7) years of experience with ETL Development, and/or Python.
• Should have a good familiarity with designing SSIS ETL packages to move data from various sources preferably from Oracle and Flat files.
• Working knowledge of general business, quality/regulatory requirements, and /or manufacturing systems is preferred.
• Exposure and general working knowledge of Azure Data Factory preferred.
• 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.

We’re widely known and respected for our benefits and for leadership that is supportive and hands-on. Managers who truly want you to grow and excel.

• Formal training
• Outstanding plans for medical, dental, and vision insurance
• Health savings account (HSA)
• Flexible spending account (FSA)
• Tuition Reimbursement
• Employee assistance program (EAP)
• Wellness program
• 401k retirement plan
• Paid time off
• Company paid holidays
• Personal time

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.