Skip to main content
Aligned Automation Services logo

Data Analyst - Onsite Limerick

Aligned Automation Services
1 month ago
Full-time
On-site
Limerick, Limerick, Ireland

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 escalate 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

MUST-HAVE SOFT 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

GOOD-TO-HAVE SOFT 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

QUALIFICATIONS


•  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