Solway logo
Solway

Middle/Senior Data Engineer

Start: 1st July

Duration: by the end of the year

Location:

E.U citizens with E.U Passeport (Austria,Belgium, Bulgaria, Croatia, Republic of Cyprus, Czech Republic, Denmark,Estonia, Finland, France, Germany, Greece, Hungary, Ireland, Italy, Latvia,Lithuania, Luxembourg, Malta, Netherlands, Poland, Portugal, Romania, Slovakia,Slovenia, Spain and Sweden)

also Great Britain, England, NorthIreland, Wales, Scotland, Monaco,Liechtenstein, Andorra,

also relocated from Ukraine./CIS andothers countries already relocated in European Countries.

Note: working 9 am-6 pm English time,working on Mac. the client will provide one Mac.

Must to have

  • Must to have relevant experience as DataEngineer at least 5 years
  • Must to have relevant senior experiencewith Snowflake.
  • Must to have relevant senior experiencewith SQL for complex data manipulation, transformation, and analysis.
  • Must to have relevant senior experiencewith dbt core or dbt Cloud
  • Must to have relevant senior experiencewith Python for scripting and custom data ingestion.
  • Must to have relevant senior experiencewith data modelling, ELT development, and data warehousing techniques.
  • Must to have relevant senior experiencewith Git and GitHub Pull Requests.
  • Must to have relevant senior experiencewith supporting QA and User Acceptance Testing processes.

Good to have

  • Good to have experience with GitHubActions
  • Good to have experience with Fivetran,
  • Good to have experience with Terraform.
  • Good to have experience with AWS cloudservices, particularly (e.g., AWS Lambda, S3 and ECS).
  • Good to have experience with with PowerBI.
  • Good to have experience with withMicrosoft SQL Server and SSIS.
  • Good to have experience with with AzureData Factory and Logic Apps.
  • Good to have experience with Understandingof the entertainment or ticketing industry is a plus.
  • Good to have experience with Experiencedata protection laws such as GDPR, CCPA and SOX.

About the role

We have been on a journey to modernise our data technology stack and have moved to a modern data stack that consists of Snowflake, dbt Cloud, Fivetran, Power BI andAWS. We still have many legacy processes based on SQL Server and Azure to migrate to our new stack, all while responding to new requests from our global business. You will report to the Lead Data Engineer and will convert raw data into usable information for analytics and business decision-making across business functions, including Technology, Product, CRM, Loyalty, Venue and DigitalMarketing. You will be involved in all aspects of the delivery including design, implementation, testing, and continuous improvement.

Key Responsibilities

  • As a Data Engineer you will demonstrate your ability to: Design, implement, test, deploy, and maintain highly scalable data management systems and solutions, ensuring proper compliance with client’s architectural standards.
  • Design and build stable, reliable and effective data processing pipelines across the Data Lake and Data Warehouse in Snowflake.
  • Collaborate with Enterprise Data Architect and Business Analysts to integrate systems and automate data collection processes.
  • Develop and update technical documentation, ensuring it is clear and understandable by the wider Data Team.
  • Implement processes and systems to monitor data quality, ensuring production data is always accurate and available for key stakeholders.
  • Recommend ways to improve data reliability, efficiency, and quality.

Related jobs