The data engineer is responsible for all database administration tasks including requirement elucidation, analysis, design of database objects, and implementation of ETL and data engineering for various ODI projects.
You will regularly work with the Operations Digital Innovation (ODI) Data Science team and will be engaged in a diverse set of project-specific tasks related to the development and deployment of the database. you should possess experience with a variety of database administration responsibilities and technical proficiency in SQL Server and integration services as well as be able to perform ETL and Semantic model creation in an AWS cloud environment
Job Description
- Proactive Monitoring: Monitor SQL Server maintenance tasks, troubleshoot failures, and address issues promptly
- Performance Optimization: Identify and troubleshoot application performance issues, ensuring optimal system performance
- Error Resolution: Respond in a timely manner to user-reported errors and provide prompt resolution
- Database Integration: Integrate SQL Server with corporate applications, design and enhance ETL processes
- Security and Maintenance: Configure and maintain SQL Security controls, manage backups and recovery, and ensure data integrity and protection
- Perform source to target data analysis and mappings
- Stay updated with industry trends and emerging technologies, recommending improvements to existing systems and processes
- Document data engineering processes, guidelines, and best practices
Knowledge, Skills, Abilities
- Bachelor's or Master’s degree in Computer Science, Engineering, related field or equivalent working experience
- Proven experience as a Data Engineer or similar role
- Proficiency in SQL Server, T-SQL, SSIS, and SSRS
- Basic understanding of AWS concepts is a plus
- Databricks, AWS Glue, Redshift, Athena and PySpark are plus
- Solid understanding of data modeling, data warehousing, and ETL processes
- Experience with cloud-based platforms and related data services
- Strong problem-solving skills and ability to work in a fast-paced environment
- Excellent communication and interpersonal skills (including fluency in English)
Benefits:
- Flexible working schedule, 5 weeks of vacation, and 5 sick days/year
- Combination of work from home and from the office
- You will be part of a successful international company specializing in high-tech
- Great working equipment: a notebook of high quality, a company phone, and two monitors are our standard, further office equipment based on personal preferences
- Meal allowance and company canteen
- Free MultiSport card
- Annual bonus
- Pension insurance allowance, possibility of life or health insurance for better prices
- Personal mobile tariff for a friendly price
- Possibility to grow in personal skills and professional language (e.g. free English lessons)
- Modern work environment
- Open and friendly company spirit