Position: Middle Data Engineer for Ciklum Digital
Company: Ciklum
Experience required: 2y
Category: SQL
English level: upper
Published: 2021-12-01T00:00:00+02:00

You will join a highly motivated team and will be working on a modern solution for our existing client. We are looking for technology experts who want to make an impact on new business by applying best practices and taking ownership

Project description: Client is a world leader travelling company. This project’s team includes cross functional members who operate in the area of customer experience. Role of the Data Engineer is to work on the delivery of data solution along with engineers, analytics, BI developers. Data Engineer will keep close contact with the stakeholders (business, IT function, analytics team) to ensure truly data driven decision processes that meet the needs of the business.

Technology Stack: SQL, AWS, Snowflake, DBT

**Responsibilities**

Responsible for managing the pipelining (collection, storage, access), engineering (cleansing, feature creation / selection) and understanding (documentation, exploration) of the data
Acquire, create and manage innovative data assets for the team. These assets will draw from various sources – internal and external systems, flat files, databases and external APIs
Evaluate user requests for new or re-engineered analytics and reporting solutions to determine their feasibility, time requirements and their compatibility with current systems and architecture standards
Active participation in the development of the data lake, data marts and subsequent enhancements, including the creation of new data solutions to support development of analytic capabilities
Interact with stakeholders regarding data availability and report format/presentation, to ensure the report provides the information the stakeholders need without compromising the report’s accuracy
Deliver new capabilities to the business through agile methods – experiences with Scrum and Jira are a plus

**Requirements**

2+ years of experience coding in SQL, Python, with solid CS fundamentals including data structure and algorithm design
1+ years contributing to production deployments of large backend data processing and analysis systems as a team lead
1+ years of experience in cloud data platforms (AWS)
The ability to design, implement and use effective database structures to ensure data is organised effectively and ready for downstream development of data science and analytics
Experience working in a structured environment and desire for good documentation, exceptional delivery, effective organisation, and high-quality communication
Experience of Big Data platforms, enabling non-technical users to gain insights into key business metrics
Hands on experience with modern data storage systems (e.g. S3, Snowflake, Athena, Glue)
Feeling comfortable using AWS, Kubernetes, Docker and Airflow
Strong SQL and data profiling skills
Hands-on ELT experience using tools like Streams and Tasks or DBT
Familiarity with a traditional BI application such as Power BI, Tableau or Spotfire
Knowledge of data types including JSON, XML, YAML is a plus
Solid understanding of data warehousing principles, concepts and best practices (e.g. ODS, Data Mart, Data Lakes, Data Vault)
Strong problem solving and analytic skills

**Desirable**

Understanding of cloud infrastructure design and implementation
Experience in data science and machine learning
Experience in backend development and deployment
Experience in CI/CD configuration

**Personal skills**

Curious mind and willingness to work with client in consultative manner to find areas to improve
Upper-Intermediate or Advanced English
Good analytical skills
Good team player, motivated to develop and solve complex tasks
Self-motivated, self-disciplined and result-oriented
Strong attention to details and accuracy

**What's in it for you**

A Centre of Excellence is ultimately a community that allows you to improve yourself and have fun. Our centers of excellence (CoE) bring together all Ciklumers from across the organization to share best practices, support, advice, industry knowledge and to create a strong community
Close cooperation with client
A constant flow of new projects
Dynamic and challenging tasks
Ability to influence project technologies
Projects from scratch
Team of professionals: learn from colleagues and gain recognition of your skills
European management style
Continuous self-improvement