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:
They looking to recruit a Business Intelligence Analyst to join our team based in Swords, Co. Dublin on a temporary (contractor) 12-month basis through Cpl.
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.
As a Business Intelligence Analyst, your core mission will be to deliver ‘the right information to the right people at the right time’. 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 processes, propose, and deploy digital solutions.
Main Activities & Responsibilities:
· Collaborate with cross-functional teams to understand business needs and lead meetings and workshops to gather and assess end-user requirements, translating them into effective data visualisations, reports, and intuitive Power BI dashboards that deliver actionable insights to a wide range of stakeholders and align with business objectives.
· Develop and implement custom solutions and automate workflows using MS-365 and Power Platform, such as Power Apps and Power Automate.
· Identify data requirements for each solution and query multiple data sources using SQL and other techniques. Implement best practices for data modelling, transformation, and aggregation. Ensure data source availability and reliability, and troubleshoot technical issues as needed.
· Lead and support the implementation of digitalisation projects such as Data analytics platform, Data Lake, Implementation of Smarter Planning and Report tools, 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.
Requirements:
· Bachelor’s Degree in STEM, Business, or related field with specialisation in Business/Data analytics, computer science, information technology, or equivalent experience.
· 2+ years’ experience in Data Analytics and/or Business Analytics with hands-on experience in Microsoft Power BI application, including data ETL, Power Query, building visualisations, and writing calculations in DAX, with proven experience with data modelling, connectors, data hub, workspaces and integrating Power Platform with other systems.
· Experience with Power Platform and hands-on experience in Power Apps and Power Automate is preferred.
· Good understanding of SQL, relational database technologies, integration technologies, APIs.
· Experience with SAP Hana reporting automation is a distinct 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.