305 King St W
Suite 1100
Kitchener, ON N2G 1B9
Canada
Senior Data Integration Engineer Bucharest, Romania or Remote
Senior Data Integration Engineer Description
DESCRIPTION
We are looking for a new teammate, a Senior data engineer, supporting a Snowflake data warehouse and Matillion jobs built. They will also be key in improving or developing our data warehouse solution further. Training for Snowflake and Matillion will be provided based on experience. The key skills to this role are SQL knowledge and a solid ability to create and understand ETL data flows.
What You’ll Do
- Design & run snowflake database objects (tables, views)
- Design, build, and maintain extract-transformation-load (ELT) processes in Matillion
- Implement and test solution in non-production environments
- Move supporting data between non-production environments
- Assist other developers with SQL questions as needed
- Performance review and tuning on pending, new and, production database objects
- Maintain database objects in a software version control system
- Support Testing efforts from a database perspective
- Identifies and drives improvements to code
- Creates technical documentation for reference and reporting in Confluence
- Provides production support for existing and newly deployed software including an out-of-hours on-call rota
What You Have
- Degree in Computer Science, Software Engineering or Electronics / Electrical Engineering, or equivalent
- Min 2-3 years of Data Warehouse and database experience
- Extensive experience in database design, data warehouse design, query performance tuning, writing stored procedures, etc
- Experience developing ETL processes loading Data Warehouses/Data Marts
- Knowledge of development standards and software development process
- Experience supporting a multi-database environment
- Superb interpersonal skills
- Good planning and work prioritisation skills
- Should be able to follow pre-existing development coding standard and build upon them
Nice to have
- Experience in software development methodologies and Agile based delivery eg: Jira, Confluence etc
- Any experience Snowflake a bonus
- Support and administration of Snowflake databases in the Cloud (SaaS)
- Any experience of Bash/Shell scripting
- Any Experience in Scripting languages such as Python a bonus
We Offer
- We believe that the greatest strength of the company is its people. EPAM is fully committed to help its employees to reach their full potential and achieve their professional goals through continues learning. With this in mind, we would like to introduce to you few of the many opportunities and services which we believe will help you expand your current knowledge:
- Full access to cutting-edge tools and technologies
- Competitive compensation depending on experience and skills
- All-around Social package: professional & soft skills training, medical & family care programs, sports
- Relocation opportunities
- Free English classes
- Unlimited access to LinkedIn learning solutions
- Continuous experience exchange with experts and professionals worldwide
- Friendly team and comfortable working environment
- Engineering, corporate, and social events within and outside the Company
- Flexible working schedule
- Opportunities for self-realization