MSD AHIT Aera Software Engineer 

Czechia 

207667129

Job Description

Key Responsibilities

Database Development

• Develop and maintain complex SQL queries.

• Develop ETL processes to extract data from various sources, transform it according to business requirements, and load it into target databases.

• Maintain existing ETL processes, ensuring they remain functional after changes in the source datasets.

• Work with large datasets and manage data migrations between systems.

Data Integration

• Integrate data from multiple sources into our data warehouse, including relational databases, flat files, and external APIs.

• Ensure seamless data flow and integration with data warehouses and business intelligence tools.

Collaboration

• Collaborate with business analysts, data scientists, and other stakeholders to understand data requirements and translate them into technical specifications.

• Provide support and troubleshooting for database and ETL-related issues.

Documentation

• Document database designs, ETL processes, and data integration workflows, in accordance with GxP regulations.

• Understands good coding practices, especially related to code legibility and understandability.

Qualifications:

• Bachelor’s degree in Computer Science, Information Technology, or a related field.

• Proficiency in SQL and experience with database management systems such as MySQL, SQL Server, or Oracle.

• Knowledge of data warehousing concepts and architectures, data modelling, and database design

• Knowledge of scripting languages like Python or R is preferred.

• Ability to troubleshoot and resolve database and ETL-related issues efficiently.

• Experience with developing software in a highly regulated environment is a plus.

• Data Analytics, SQL Developer with ERP Knowledge.

• Excellent communication and collaboration skills.

• Strong attention to detail.

• Ability to work independently and as part of a team in a fast-paced environment.

Preferred Experience

• Experience with developing database solutions using SQL.

• Experience in developing and maintaining ETL processes for large-scale data systems.

• Knowledge of business intelligence tools and reporting systems (e.g., Power BI, Tableau, Aera).

What we offer:

• Exciting work in a great team, global projects, international environment

• Opportunity to learn and grow professionally within the company globally.

• Hybrid working model, flexible role pattern (e.g., even 80% full-time is possible in justified cases)

• Pension and health insurance contributions

• Internal reward system plus referral program

• 5weeks annual leave,5sick days,15days of certified sick leave paid above statutory requirements annually,40paid hours annually for volunteering activities,12weeks of parental contribution.

• Cafeteria for tax free benefits according to your choice (meal vouchers, Lítačka, sport, culture, health, travel, etc.), Multisport Card

• Vodafone, Raiffeisen Bank, Foodora, and Mall.cz discount programs.

• Up-to-date laptop and iPhone

• Parking in the garage, showers, refreshments, massage chairs, library, music corner

• Competitive salary, incentive pay, and many more.

Current Contingent Workers apply

*A job posting is effective until 11:59:59PM on the dayBEFOREthe listed job posting end date. Please ensure you apply to a job posting no later than the dayBEFOREthe job posting end date.

A job posting is effective until 11:59:59PM on the day BEFORE the listed job posting end date. Please ensure you apply to a job posting no later than the day BEFORE the job posting end date.