Aligned Automation Services logo

Data Analyst - Onsite Limerick

Aligned Automation Services
3 days 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