Sr. Business Intelligence Developer

SERB Pharmaceuticals - Philadelphia, PA

Full-time - Mid Level

Philadelphia, PA

251-500 employees

About the position

The Senior Business Intelligence Developer at SERB Pharmaceuticals will play a crucial role in modernizing the company's data and reporting platform to enhance business intelligence and decision-making processes. This position involves delivering end-to-end solutions that cater to the organization's global needs, while collaborating with various stakeholders and ensuring data integrity and security.

Responsibilities

• 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 using 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.

Requirements

• 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 modelling 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
• 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.

Nice-to-haves

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

Benefits

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