Middle Data Engineer

**DIRECTION:
**BIG DATA

**PERSONAL RECRUITER:
**VIKTORIIA KHARCHENKO

**LOCATION:
**MEDELLIN

**TECHNICAL LEVEL:
**INTERMEDIATE

**WE ARE**:
SoftServe isn’t just about technology — it’s about open-minded people who love technology and have everything they need to pursue their passion to create innovation.

**YOU ARE**:

- Possessing 2-3 years of experience with one of the relational DB (MS SQL)
- A person with strong knowledge of SQL
- With knowledge in DB DEV and experience in ETL, SSIS, Tableau
- Having experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, etc.
- Understanding the principles of building ETL processes and their support, while having practical experience with at least one ETL tool
- Comprehending the concept and principles of building and maintaining a data warehouse
- A person with excellent communication skills and the ability to communicate at all levels of the organization
- Initiative, detail-oriented person
- Able to translate business requirements into technical deliverables
- An active team player
- Good at time-management
- Ready to learn
- Would be a plus: skills and experience with_
- Matillion
- AWS technologies (S3, AWS Glue, Redshift Spark, EMR)
- Source control systems such as Git or Perforce
- Principles of interaction through the API, working with Postman Responsibilities: design, development and administration of MSSQL, REDSHIFT databases
- Performance monitoring, reporting, and tuning of databases
- Creation and maintenance of SQL queries and routines
- Reviewing and tuning SQL
- Developing Matillion solution, configuring data load via AWS technics
- Maintenance of database server, replication, and client environments
- Security and access control
- Provisioning of (database) development and testing environments
- Working and preparing API requests, fixing API issues
**YOU WANT TO WORK WITH**:

- Participating in exciting projects in all phases of the process
- Developing, upgrading error correction
- Data analysis, defect identification, and resolution
- Keeping up-to-date with new technologies and industry standards, seeking self-development, and opportunities to progress, learning new skills, and maintaining high-quality work
- Resolving all development tasks within the specified timeframe, reporting to IT Data Manager if the timescale cannot be met
- Effective usage of feedback from business users to keep the team connected to any issues before they become bigger problems
- Feeding and translating the feedback into the development tasks to improve the quality of the deliverables
- Attending meetings as required
- Displaying a great team spirit and loyalty towards colleagues whilst maintaining a high-performance level
- Creating documentation and management
- Identifying and investigating data quality/integrity problems determines the impact and provides solutions to problems
**TOGETHER WE WILL**:

- Support your technical and personal growth — we have a dedicated career plan for all roles in our company
- Enjoy flexible working hours — whether you are a morning bird or a sleepy-head it is ok with us
- Take part in internal and external events where you can build and promote your personal brand
- Give you access to experienced specialists who are very willing to share their knowledge
- Show you our casual atmosphere — no dress code
- Care about your individual initiatives — we are open for them, just come and share your ideas
- Share many other advantages with you such as an attractive salary, modern office, a package of benefits, language classes