Data Analyst (Python)

Andersen Lab; Cataluña; Híbrido; EUR 35.000 - 65.000; Jornada completa

Descripción de la vacante

An established industry player is looking for an experienced Data Analyst to join their team. This role involves developing a web-based application for manpower forecasting and resource management, requiring strong analytical skills and technical expertise. You will work with a global leader in high-tech facilities and have the opportunity to collaborate with professionals from various domains like FinTech and Healthcare. The position offers flexible working conditions, including remote and hybrid options, and promises professional growth and access to a comprehensive training portal. If you're eager to make a significant impact in a dynamic environment, this opportunity is perfect for you.

Servicios

Private health insurance

Compensation for sports activities

Access to corporate training portal

Referral program

Professional growth opportunities

Formación

• 3+ years of experience as a Data Analyst with strong technical skills.
• Ability to work with stakeholders and communicate effectively.

Responsabilidades

• Collect and document data quality requirements and metrics.
• Map data flows and document data structures and formats.
• Identify and classify data entities, including PII and GDPR compliance.

Conocimientos

Data Analysis

Technical Expertise

Communication Skills

Collaboration Skills

English (Intermediate+)

Descripción del empleo

The IT company Andersen invites an experienced Data Analyst to join its team for working with a company from Germany.

The customer is a global leader in the design, engineering, and delivery of high-tech facilities. It specializes in controlled and regulated environments, providing solutions for the semiconductor, life sciences, and chemical industries, as well as data centers. The company has significantly expanded its presence worldwide, especially in Europe and the USA, with strong growth in sales and order intake.

The project is the development from scratch of a web-based application for manpower forecasting, project management, resource management, and budgeting, while also offering a wide range of reports to track resource utilization and operational effectiveness.

Responsibilities:

• Collecting requirements related to data quality, defining DQ metrics to be collected and tracked.
• Compiling a comprehensive list of all data sources and assets (databases and data stores).
• Identifying and listing all data entities, their formats, foreign keys, indexes, storage locations, and their attributes.
• Describing and documenting the logic of stored procedures and functions (and triggers if any).
• Documenting the structure, schema, and format of data loaded from the integration points or traversing the systems (APIs, DB links, files) and is the subject of focus.
• Mapping data flows between systems and processes by digging deeper into the semantic data model.
• Determining the list and scope of the OLTP entities to be reengineered (database names, schemas, modified tables/columns, new tables/columns).
• Reviewing data entities to identify sensitive information.
• Tagging data elements containing Personally Identifiable Information (PII).
• Identifying data that falls under GDPR terms and conditions.
• Classifying data entities as Master, Transactional, or Reference data.
• Documenting the purpose and usage of each data category.
• Categorizing data entities as Static, Slowly Changed, or Frequently Changed.
• Assessing the rate of change and update frequency for each data entity.
• Determining the list and scope of the entities to be relocated from OLTP to OLAP.
• Preparing mapping tables to itemize physical specifications for data migrated from the old database towards the new OLTP schema, including data transformation rules.
• Preparing mapping tables to itemize physical specifications for data moving from the replicated OLTP sources to OLAP destinations, including data transformation rules.

Must-haves:

• Experience as a Data Analyst for 3+ years.
• Experience on the project from scratch.
• Strong technical expertise.
• Good communication and collaboration skills to work with stakeholders.
• Level of English – from Intermediate+ and above.

Reasons why this job would be interesting to you:

• Experience in teamwork with leaders in FinTech, Healthcare, Retail, Telecom, and others.
• The opportunity to change the project and/or develop expertise in an interesting business domain.
• Job conditions – you can work both fully remotely and from the office or can choose a hybrid variant.
• Guarantee of professional, financial, and career growth!
• Access to the corporate training portal, where the entire knowledge base of the company is collected and which is constantly updated.
• Referral program.
• Private health insurance and compensation for sports activities.