Sr. Business Intelligence Developer

Thyroxine SERB; Conshohocken (Montgomery County); Hybrid; EUR 80,000 - 120,000; Full time

Job summary

An innovative pharmaceutical group is seeking a Senior Business Intelligence Developer to modernize its data and reporting platform. This role involves collaborating with cross-functional teams to deliver end-to-end BI solutions, ensuring data integrity, and supporting reporting and analytics requests. The ideal candidate will have extensive experience in data warehousing, ETL processes, and business intelligence tools like Power BI. Join a dedicated team that prioritizes patient care and values integrity, teamwork, and continuous improvement. This is a fantastic opportunity to make a significant impact in the healthcare sector while working in a hybrid environment.

Benefits

Vacation, Sick and Personal Time

Medical, Dental, Vision benefits

Tuition Assistance

Discretionary Bonus Plan

Competitive 401(k)

Qualifications

• 5+ years of IT experience focusing on data warehousing and reporting solutions.
• Strong knowledge of relational databases and SQL analytical queries.

Responsibilities

• Maintain data warehouse and operational databases in MS SQL Server and Snowflake.
• Design, develop, and maintain business intelligence solutions using Power BI.

Skills

Data Warehousing

ETL Implementation

Data Modeling

SQL Analytical Queries

Problem Solving

Communication Skills

Critical Thinking

Education

Bachelor's degree in Computer Science

Higher degree in Information Systems

Tools

MS SQL Server

Power BI

Snowflake

Azure

AWS

SSIS

ADF

Matillion

Syncari

Job description

SERB Pharmaceuticals is a growing international specialty pharmaceutical group that is a dedicated ally to healthcare providers treating patients with critical conditions, focusing on emergency care and rare diseases. We have over 470 employees in 16 countries and a group revenue in excess of €350m.

Our portfolio of 80+ rescue medicines makes a real difference in the lives of patients and their caregivers, giving every one of our employees a sense of purpose.

Our Purpose is supported by our 4 key values:

• We make patients our priority
• We act with integrity and accountability
• We work together as one team
• We look for better ways forward

Broad Overview

The Senior Business Intelligence Developer will be an integral part of an exciting journey to modernize Serb’s data and reporting platform to radically improve business intelligence and decision making. The developer will be responsible for working within the BI team to deliver end-to-end (data to reporting) solutions that meet current and new needs of the organization globally.

This individual will report into SERB's Global Senior Manager, Business Intelligence and is expected to work out of our Conshohocken, PA office on a hybrid schedule.

The successful candidate will demonstrate accountability, flexibility, and adaptability to handle multiple and changing priorities and be able to independently collaborate with key stakeholders and consultants. Excellent organizational, prioritization, communication, and time management skills are a must for this role.

As the Sr. BI Developer, some of your responsibilities will include:

• Maintain data warehouse and operational databases in MS SQL Server on premise, SQL Azure Cloud, and Snowflake
• Create and support data ETL across all internal and external data sources
• Design, develop, and maintain business intelligence solutions (Power BI)
• Support delivery of reporting, ad hoc, and analytics requests via ad-hoc data pulls when needed
• Understand all Business Unit’s unique businesses and their data to aid in the development of efficient data modeling
• Collaborate within cross-functional teams to resolve complex systems, data & data flow issues to ensure data integrity.
• Partner with the Analytics team for continuous evolution and enrichment of BI solutions
• Engage in master data management to ensure data quality, integrity, and security
• Work with IT infrastructure to ensure the security and availability of data.
• Establish and manage BI technical processes to ensure that reports and dashboards are produced on schedule.
• Support and maintain project documentation such as business requirements, technical design, and mapping documents, data flow diagrams, report specifications, etc.

The above duties and responsibilities are not an exhaustive list, and you may be required to undertake any other reasonable duties compatible with your experience and competencies. This description may be varied from time to time to reflect changing business requirements.

To be successful in this role, you should demonstrate:

• Bachelor’s degree or higher in Computer Science, Information Systems, or related field
• 5+ years of Information Technology experience with a strong focus on data warehousing and reporting solutions
• 5+ years of experience with data modeling and ETL implementations
• 5+ years of experience with developing applications, reports, and dashboards
• Experience with business requirements gathering across cross-functional teams
• Experience with report development using Power BI
• Strong knowledge of relational databases and writing SQL analytical queries
• Working knowledge of cloud data platforms (e.g., Azure, AWS, Snowflake) and ETL tools (e.g., SSIS, ADF, Matillion)
• Working knowledge of Master Data Management concepts and tools such as Syncari
• Be proactive in identifying data issues and solve problems with minimal supervision
• Excellent communication and listening skills with the ability to document requirements, methodologies, and processes
• Strong problem-solving and critical thinking skills to grasp existing and new concepts
• Veeva CRM Data experience nice to have, not required

Highly Preferred:

• Pharma Industry Experience
• Familiarity with cloud data platforms
• Knowledge of Data Governance frameworks and best practices

Company Benefits:

• Vacation, Sick and Personal Time
• Medical, Dental, Vision, and other Voluntary benefits
• Tuition Assistance
• Discretionary Bonus Plan
• Competitive 401(k)

SERB Pharmaceuticals is an equal opportunity employer. We offer competitive compensation & benefit packages, challenging opportunities, and a culture of working together in a supportive way built on our strong foundation of values.