Senior Data Analyst

Cpl Group; Connacht; On-site; EUR 70,000 - 110,000; Full time

Job summary

Cpl Group is seeking a Senior Data Modeler/Data Analyst to drive scalable data design solutions across operational and analytical platforms in Ireland.

You will partner with business and technical teams to understand data flows, build conceptual/logical/physical models, and ensure adherence to governance and standards. The role emphasizes collaboration with DBAs, architects and domain owners in an agile setting.

Qualifications

• Engage with business/tech partners to understand requirements and data gaps.
• Assess objectives and data requirements from analysis documents.
• Analyze data flows and processes to map data creation, transformation and consumption.

Responsibilities

• Define conceptual and logical data models to cover multiple subject areas.
• Create physical designs from logical models for OPS systems, data warehouses, and data lakes.
• Document and present database solutions for stakeholder approval.
• Promote reuse of data APIs and standardized data terms in catalog tools.
• Collaborate with DBAs/architects to build scalable data models.
• Identify opportunities to reuse enterprise data models for new projects.

Skills

Requirements gathering

Data analysis

Data modeling

Data governance

Data integration

Cross-functional collaboration

Agile/teamwork

Education

Bachelor’s or Master’s degree in Computer Science/IT

Tools

SAP PowerDesigner

Job description

The Role

As a Senior Data Modeler/Data Analyst, you will work closely with business and technical teams to drive the creation of scalable and documented data design solutions.

You will be responsible for understanding how business processes generate, consume and transform data across operational and analytical platforms. You will analyse source systems, data flows, integrations and business processes to develop conceptual, logical and physical data models that meet business needs and are capable of easily adapting to future business requirements.

The Expertise and Skills You Bring

Requirements and Analysis:

• Engage with business and technology partners to understand the business requirements, analyze data gaps, and recommend appropriate solutions.


• Assess objectives, use cases, data requirements and specifications documents created by other analysts.


• Analyze operational systems and business processes to understand how data is created, transformed and consumed across the enterprise.


• Analyze and resolve major data issues that arise during the course of projects or in production environments.

Data Design:

• You are an experienced enterprise data modeler who can define conceptual and logical data models, with strong definitions, to capture organizational data needs across multiple subject areas


• Create physical design from logical data models for different types of systems such as operational systems, data warehouses, data lakes and others


• Research to identify effective data designs, new tools and methodologies for data analysis


• Document and present database solutions to product partners for approval.


• Promote common data API adoption and reuse.


• Map Technical terms to Business terms in data catalog tool.

Technical Leadership:

• Ensure technology decisions align with enterprise standards and strategy.


• Collaborate with DBAs, architects, subject area owners to create scalable data models.


• Find opportunities to utilize enterprise data model for new projects to minimize work and data redundancy

Education and Experience:

• A Bachelor’s or Master's degree in Computer Science, Information Technology, or equivalent experience


• 5+ years’ experience with data design, analysis and development. Development experience weighted towards PL/SQL and data loading tool/concepts.


• Demonstrated experience in the following areas: Data API design and implementation, PL/SQL, data warehouses, data modeling and data profiling.


• Experience analyzing operational systems, understanding data flows and data consumption patterns.

Skills and Knowledge:

• Demonstrable experience with SAP Power Designer or similar data modeling tool.


• Proficient analytical and problem solving skills


• Solid understanding of the database development process including analysis, design, coding, testing, problem resolution and planning, and full competency in all relevant coding environments, languages, tools, and platforms


• Good interpersonal skills and strong verbal and written skills to effectively communicate with technical and non-technical associates in the company


• Proven interpersonal skills, including the ability to work across the organization and interact/influence/negotiate optimally at all levels of management and peers.


• Experience working in cross-functional agile development teams.


• Understanding of Financial Services.