BTG plc
Sr. Business Intelligence Developer
BTG plc, Phila, Pennsylvania, United States, 19117
Come and Save Lives with Us!
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 80+ rescue medicines make a real difference in the lives of patients and their caregivers and that gives every one of our employees a sense of purpose.
Our Purpose is supported by our 4 key values:We make patients our priorityWe act with integrity and accountabilityWe work together as one teamWe look for better ways forwardBroad 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 SERBs 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.
US citizenship required
As the Sr. BI Developer, some of your responsibilities will incl
ude:
Maintain data warehouse and operational databases in MS SQL Server on premise, SQL Azure Cloud, and SnowflakeCreate and support data ETL across all internal and external data sourcesDesign, develop, and maintain business intelligence solutions (Power BI)Support delivery of reporting, ad hoc, and analytics requests via ad-hoc data pulls when neededUnderstand all Business Unit's unique businesses and their data to aid in the development of efficient data modelingCollaborate 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 solutionsEngage in master data management to ensure data quality, integrity, and securityWork 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 field5+ years of Information Technology experience with a strong focus on data warehousing and reporting solutions5+ years of experience with data modelling and ETL implementations5+ years of experience with developing applications, reports, and dashboardsExperience with business requirements gathering across cross-functional teamsExperience with report development using Power BIStrong knowledge of relational databases and writing SQL analytical queriesWorking 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 SyncariBe proactive in identifying data issues and solve problems with minimal supervisionExcellent communication and listening skills with the ability to document requirements, methodologies, and processesStrong problem-solving and critical thinking skills to grasp existing and new conceptsVeeva CRM Data expereince nice to have, not requiredUS citizenship requiredHighly Preferred:
Pharma Industry ExperienceFamiliarity with cloud data platformsKnowledge of Data Governance frameworks and best practicesCompany Benefits:
Vacation, Sick and Personal TimeMedical, Dental, Vision and other Voluntary benefitsPaid Parental LeaveTuition AssistanceDiscretionary Bonus PlanCompetitive 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.
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 80+ rescue medicines make a real difference in the lives of patients and their caregivers and that gives every one of our employees a sense of purpose.
Our Purpose is supported by our 4 key values:We make patients our priorityWe act with integrity and accountabilityWe work together as one teamWe look for better ways forwardBroad 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 SERBs 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.
US citizenship required
As the Sr. BI Developer, some of your responsibilities will incl
ude:
Maintain data warehouse and operational databases in MS SQL Server on premise, SQL Azure Cloud, and SnowflakeCreate and support data ETL across all internal and external data sourcesDesign, develop, and maintain business intelligence solutions (Power BI)Support delivery of reporting, ad hoc, and analytics requests via ad-hoc data pulls when neededUnderstand all Business Unit's unique businesses and their data to aid in the development of efficient data modelingCollaborate 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 solutionsEngage in master data management to ensure data quality, integrity, and securityWork 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 field5+ years of Information Technology experience with a strong focus on data warehousing and reporting solutions5+ years of experience with data modelling and ETL implementations5+ years of experience with developing applications, reports, and dashboardsExperience with business requirements gathering across cross-functional teamsExperience with report development using Power BIStrong knowledge of relational databases and writing SQL analytical queriesWorking 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 SyncariBe proactive in identifying data issues and solve problems with minimal supervisionExcellent communication and listening skills with the ability to document requirements, methodologies, and processesStrong problem-solving and critical thinking skills to grasp existing and new conceptsVeeva CRM Data expereince nice to have, not requiredUS citizenship requiredHighly Preferred:
Pharma Industry ExperienceFamiliarity with cloud data platformsKnowledge of Data Governance frameworks and best practicesCompany Benefits:
Vacation, Sick and Personal TimeMedical, Dental, Vision and other Voluntary benefitsPaid Parental LeaveTuition AssistanceDiscretionary Bonus PlanCompetitive 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.