Senior Data Engineer (MS SQL)

Job title: Senior Data Engineer (MS SQL)

Department: Engineering

Reporting to: Engineering Manager

Location: Poland

Purpose of Role

We’re looking for a Senior Data Engineer to join our Market Performance Group in transforming our real-world raw data into valuable and credible industry leading metrics that provide insights to our analysts and our customers. 

What you will be doing

• Own and improve our data pipelines in MS SQL/DBT, Python or Scala Spark. 
• Assemble large, complex data sets that meet business requirements, with engineering best practices in mind.
• Build scalable and resilient data infrastructure, as well as tools to extract and transform data used by stakeholders and customers.
• Work closely with our data scientists and our data engineers to create and evolve products that measure market dynamics in the Telecommunication space that drive our customers short term marketing campaign tactics and their longer-term customer acquisition and retention strategies. 

We're looking for: 

• 5+ years of advanced SQL and Stored Procedures
• 3+ years of experience with MS SQL
• 3+ years of experience in writing unit tests
• Strong analytic skills in working with unstructured datasets.
• Experience in root cause analysis of data when asked to answer specific business questions
• Experience working with cross-functional teams
• Strong communication and collaboration skills
• Bachelor’s degree
• English (B2 or higher) 

It'd be nice to have:

• Experience with DBT
• Experience with building and optimizing data pipelines using Python Spark or Scala Spark
• Experience with AWS cloud services like EC2, S3, EMR or equivalent
• Experience with Redshift, Aurora, or PostgreSQL
• Experience with data pipeline / workflow tools i.e. Apache Airflow
• Experience in AWS solution architecture 
• Experience in implementing complex clustering and classification models on large datasets to support new product development

About Us

Opensignal is the leading global provider of independent insight and data into network experience and market performance. Our user-centric approach allows communication providers to constantly improve their network and maximize commercial performance. Leading analysts, investors and financial institutions place a high value on our independent analysis and we are regular contributors to their reports.

Real network experience is our focus and ultimately that’s what influences customer choice. Our mission is to advance connectivity for all and here at Opensignal, the team is leading the industry in enabling operators to link their network experience and market performance in a way that has never before been possible.

With offices in London, Boston and Victoria, British Columbia, we are truly global, with employees working across four continents and representing over 25 nationalities. We are an equal opportunity employer dedicated to building an inclusive and diverse workforce.

Benefits

We believe we are stronger when we not only celebrate our many differences, values, and voices but include them in everyday practice. Having a diverse and inclusive culture is essential, which is why we offer a flexible approach to work-life balance, operating in a remote-hybrid way. We also offer an attractive range of additional benefits, including:

• 95% remotely - the team meets in the Warsaw office for 1 day/month
• Warsaw office at Marina Mokotów in a leafy and quiet estate just around the corner from Pole Mokotowskie. 
• Kitchen, free coffee, shower, summer barbecues.
• Comprehensive private family health care package
• Multisport Card

Tech stack

• SQL, SQL Stored Procedures, MS SQL, DBT, Python or Scala Spark, Redshift, Airflow

Salary ranges:

• 23 000 PLN – 27 000 PLN on B2B