Data Analyst
Data & Analytics | Limerick, Ireland (Onsite) | Full-Time | 3-5 Years Experience
ROLE OVERVIEW
We are seeking a Data Analyst to extract, validate, and analyze data across our manufacturing data lake within a GxP-regulated environment. Source systems span SAP, MES, L&D, and other operational platforms feeding a shared lake/lakehouse architecture. This role turns disparate operational data into actionable insight for Operations and Quality stakeholders, while maintaining full compliance with data integrity standards (ALCOA+).
KEY SKILLS & KEYWORDS
- Data Lake
- Data Warehouse
- Lakehouse
- SQL
- Power BI
- Tableau
- Databricks
- SAP
- MES
- JIRA
- Data Validation
- GxP
- ALCOA+
- ETL
- Data Governance
KEY RESPONSIBILITIES
Data Lake Analysis & Reporting
- Extract and analyze data from the manufacturing data lake, spanning SAP, MES, L&D, and other operational source systems
- Build and maintain Power BI/Tableau dashboards sourcing from lake/lakehouse layers (e.g., Databricks) and other enterprise systems
- Own recurring reporting packages covering production, quality, and operational KPIs across multiple source systems
- Reconcile and validate data across disparate systems feeding the data lake to ensure consistency
Data Integrity & Compliance
- Apply ALCOA+ principles to all data extraction, transformation, and reporting workflows
- Support audits and inspections by providing traceable, validated data sets across source systems
- Document data lineage, extraction logic, and validation steps per GxP standards
- Flag and escalated data discrepancies between source systems and the data lake
Cross-Functional Collaboration
- Partner with Manufacturing, Quality, IT, and platform teams to define data lake reporting requirements
- Translate business questions into structured queries, lakehouse reports, or BI visualizations
- Support root cause analysis for data discrepancies flagged across source systems
- Track and manage analysis tasks and workflows using JIRA
Process Improvement
- Identify opportunities to automate recurring data pulls and manual reconciliation tasks
- Contribute to data governance standards across the data lake and its source systems
SKILLS PROFILE
MUST-HAVE HARD SKILLS
- SQL (intermediate/advanced)
- Power BI or Tableau
- Data lake / lakehouse concepts (bronze-silver-gold, schema-on-read)
- Excel (Advanced formulas, pivot tables)
- Data validation across multiple source systems
- Clear communication with non-technical stakeholders
- Attention to detail under GxP scrutiny
- Ownership of end-to-end reporting cycles
- Comfortable reconciling data across disparate sources
GOOD-TO-HAVE HARD SKILLS
- Databricks (notebooks, SQL warehouses, Delta Lake)
- JIRA for task/workflow management
- SAP ERP data exposure (MM/PP/SD/QM)
- MES or L&D system data exposure
- Python (Pandas, PySpark)
- Cross-functional stakeholder management
- Continuous improvement mindset
- Adaptability in a fast-changing regulated setting
- Mentoring junior analysts
GOOD-TO-HAVE SOFT SKILLS
- JIRA for task/workflow management
- Python (Pandas, PySpark)
- Cross-functional stakeholder management
- Continuous improvement mindset
- Adaptability in a fast-changing regulated setting
- Mentoring junior analysts
QUALIFICATIONS
Required
- 3–5 years' experience as a Data Analyst, working across multiple operational/enterprise source systems
- Proven proficiency in SQL and at least one BI tool (Power BI or Tableau)
- Working knowledge of data lake, data warehouse, or lakehouse architectures
- Advanced Excel skills including formulas, pivot tables, and data modeling
- Working knowledge of data integrity principles (ALCOA+), ideally in a regulated (pharma/medtech) setting
- Bachelor's degree in Data Science, Statistics, Engineering, or related field
Preferred
- Experience with Databricks (notebooks, SQL warehouses, Delta Lake)
- Familiarity with JIRA for task and workflow management
- Exposure to SAP, MES, or L&D systems as data sources
- Python (Pandas, PySpark) for data manipulation
- Experience supporting regulatory audits or inspections in a GxP environment
CORE COMPETENCIES
- Multi-Source Data Proficiency
- Regulatory Awareness (GxP)
- Analytical Problem-Solving
- Stakeholder Communication
- Data Visualization
- Attention to Detail
- Process Automation
- Cross-Functional Collaboration