SK pharmteco is a global Contract Development and Manufacturing organisation (CDMO) with state-of the-art facilities in Korea, US, France and Ireland. We are part of SK Inc., a Korea company with revenues of $99 billion in 2023. Our mission is to ‘produce and deliver life-changing therapies that improve patient outcomes and save lives’. The SK pharmteco Small Molecule, Europe, facility located in Swords, Co Dublin, Ireland has led the way in the development, scale-up and commercial manufacture of Active Pharmaceutical Ingredients (APIs) and Chemical Intermediates for over 60 years. With a talented workforce, exceptional technical capabilities and facilities we have made some of the world’s most important medicines and continue to do so. Further information on SK pharmteco can be found at www.skpharmteco.com
Current Need:
Our Business Excellence Team are looking to recruit a Business Intelligence Analyst to join our team based in Swords, Co. Dublin on a temporary (contractor) 12-month basis.
Overview:
As a member of the Operational Excellence and Digital Transformation team, you will serve as a BI/Data Analyst and support on multiple digitalisation projects' implementation, playing a pivotal part in designing, developing, and implementing digital solutions contributing to our overall site strategy.
The role involves integrating digital technology into all our business areas, empowering our business leaders to streamline their processes, increasing operational efficiencies, and driving growth through low-code automation and data-driven solutions. To achieve this, you will collaborate closely with cross-functional teams, including department managers and SMEs across all areas of our business, such as Safety & Environmental, Operations, Quality, Engineering, R&D, Supply Chain, Project Management, Finance, Strategy and Operational Excellence; and you will support the mapping of current manual and time-consuming processes, propose, and deploy digital solutions.
This position provides opportunities to learn and develop business and interpersonal skills, as well as a deep understanding of the industry.
Main Activities & Responsibilities:
·Collaborate with cross-functional teams to understand business requirements and translate them into effective data visualisations, reports and visually appealing Power BI dashboards that drive actionable insights to various stakeholders.
· Develop and implement custom solutions and Automate workflows and business processes using MS-365 and Power Platform, such as Power Bi, Power Apps and Power Automate.
· Implement best practices for data modelling, transformation, and aggregation; Ensure availability and reliability of data sources, troubleshoot technical issues.
· Lead and support the implementation of digitalisation projects such as Data analytics platform, AI tools/solutions, Data Lake, Electronic Batch Record (EBR), among others.
· Contribute to data governance and document data strategy;
· Assist in project documentation, solution validation, SOP updates, create work instructions, training materials and presentations.
· Collaborate with vendors and partners to identify technical solutions, create detailed business requirement documents, use cases, functional specifications and develop technical documentation and training materials
Requirements:
·Bachelor’s Degree in STEM, Business, Supply Chain, or related field with specialisation in Business/Data analytics, or equivalent experience.
· Minimum 3 years of experience in Data Analytics or Business Analytics with strong hands on delivery using Microsoft Power BI, including data ETL, Power Query, report and visualization development, and DAX calculations and row level security.
· Experience managing Power BI Service environments, including workspace administration, access control, role based security, deployment pipelines, dataset refresh scheduling, and lifecycle management across workspaces.
· Desirable experience with Microsoft Fabric Lakehouse, including Data Pipelines and medallion concept.
· Preferred hands on experience with Microsoft Power Platform, including Power Apps and Power Automate, with a focus on automation and process enablement.
· Strong proficiency in SQL and relational database technologies, and working knowledge of integration patterns and API based data access.
· Experience with SAP Hana reporting automation is an advantage.
· Experience in life science sector, GMP solutions deployment and validation and FDA's regulations for electronic documentation (FDA 21 CFR Part-11) will be a distinct advantage.
· Understanding of Operational Excellence Concepts and Continuous Improvement Methodologies, with a Yellow Belt or Green Belt certification, or demonstrate a willingness to pursue certification upon joining the team.
· Strong analytical and technical skills, proficiency in Microsoft Excel and PowerPoint.
· Excellent communication skills and the ability to work in a cross functional collaborative environment