We are looking for people to join our data team and will spend most of the time building and maintaining DWH - data loading, cleaning, transforming and verifying from multiple data sources such as Postgres DB, Google Analytics, Stripe etc. Data from the DWH will be used for further analysis throughout the
Tableau reporting and predictive models. You will have a close collaboration with Engineering and Product teams.
What you need to know/What skills to have
- Solid background working with relational databases (e.g. PostgreSQL, SQL Server, Oracle)
- Proven experience in design, maintenance and testing of ETL/ELT pipelines with multiple data sources
- Hands-on experience with data modeling (dimensional models) and strong knowledge of DWH concepts (e.g. data marts, SCD’s)
- Proficient understanding of code versioning, unit testing tools (e.g. Git)
- Strong analytical skills related to working with both structured and unstructured data
- Ability to identify, design and implement improvements / automation for optimizing data processing, storage and availability, while maintaining scalability
- Detail-oriented mindset
Would be good to know/You want to learn
- Experience/basic knowledge of BI tools (e.g. Tableau, Power BI, QlikView/QlikSense) for development of information rich dynamic dashboards
- Experience/exposure to cloud-based DWH infrastructures (e.g. Redshift, Synapse, BigQuery, Snowflake)
- Machine learning and predictive analytics enthusiast (Python)
What we offer?
- Competitive salary
- Stock options
- Unlimited vacation policy
- Flexible working hours
- Remote or Office work