Data Warehouse Engineer - up to £/€90,000 - Barcelona, Spain or London, UKA leading social gaming company is looking for a Data Warehouse Engineer to work on a greenfield project building a data warehouse for its C-Level team to view reports on finance and gaming performance. The Data Warehouse Engineer will be responsible for designing and implementing the DWH, dashboards and data pipelines for real-time streaming of data.Key Benefits for a Data Warehouse EngineerSalary up to £/€90,000 plus 10% bonus (been paid for the last 5 years)Working at a leading social gaming companyThe ability to be exposed to and gain experience in Looker, LookML, Snowflake, GCP, etc.ResponsibilitiesAs the Data Warehouse Engineer, you will be responsible for selecting and integrating any Big Data tools and frameworks required to provide the requested capabilities.You will be monitoring performance and advising any necessary infrastructure changes.The data warehouse engineer will define data retention policies.Enhancing & improving the quality of the company's data lake.Implementing ETL processes.Designing and planning data orchestration and structure.Leading a small team of DWH engineers.Key SkillsUnderstanding of the full software development lifecycle and experience integrating data architecture and data governance into the analytics lifecycle.Strong competency in data modelling and data design, including logical and physical modelling, partitioning strategies for large tables, and other database optimisations.Solid experience with relational databases.Understanding of pros and cons of different data warehouse methodologies and architectures (Kimball/Inmon/Data Lake/Hybrid).Experience designing Star, Snowflake Schemas, Dimensional Data Modelling, SCD (Slowly Changing Dimensions), and CDC (Change Data Capture).Other BenefitsHealth insurancePension25 days holidayTech StacksData Pipeline: Pub-Sub, Snowflake, SnowpipeETL: Job orchestration with Apache Airflow and Python, ETL logic in SQLPython: Jupyter notebooks, pandas, numpy, scikit-learn, matplotlibSQL/DWH: SnowflakeDashboarding: LookerKEYWORDS: Data Warehouse/Data Pipeline/Data Visualization/SQL/Python/Looker/LookML/GCP/Snowflake/Pub-Sub
#J-18808-Ljbffr