Data Warehouse Engineer

Job Description

Data Warehouse Engineer (Data Warehousing, Power BI Cloud)

Technicolor Creative Studios is the division with Technicolor, which contains Technicolor's world-leading Visual effects and Animation brands such as MPC, Mr. X, The Mill, and Mikros.

Technicolor's brands have worked on the spectacular scenes and tiny details that make movies, advertising campaigns and Animation movies genuinely mind-blowing. We're the people behind the effects in countless blockbuster films like The Lion King, The SpongeBob Movie: Sponge on the Run and advertising campaigns for clients such as Samsung, Audi, Nike and Apple. We are continually looking for the best talent globally, enthusiastic people who come in every day to be a part of some of the industry's best work.

Technicolor's artists are wildly creative, uber-talented and passionate about the possibilities of VFX, Experiential, Animation and Technology. When you join the team, you'll be working with and learning from the most skilled people in the business.

Technicolor Production Services is the division that contains our world-leading Visual effects and Animation brands such as MPC, Mr X, The Mill, and Mikros. Key to the success of our division and its brands is winning the war on talent through acquiring and growing a community where artistry meets technology.

Responsibilities:

Design and Development
• Harmonising our data architecture from Power BI Report Server with Power BI Cloud.
• Architect, develop, test and maintain scalable data warehouses and data pipelines.
• Design, develop and test scalable ETL processes, including error handling.
• Creating databases, advanced data modelling, star and snowflake schemas.
• Writing scripts for stored procedures, database snapshots backups and data archiving.
• Preparing data structures for advanced analytics and self-service reporting.
• Delivering projects within an AGILE environment.

Qualifications

Experience:
• Translating business needs to design and develop tools for data analysis.
• Architecting cloud and on-premise data solutions; data warehouses and data lakes.
• Data mining, data modelling and dealing with big data.
• Database management systems (SQL and NoSQL), OLAP and ETL processes.
• Data cleansing, testing and optimising the performance of BI tools.
• Working in staging and production environments.
• AGILE Software Development Lifecycle processes and AGILE tooling (JIRA /Confluence).
• A background in Data Engineering, as part of a Business Intelligence, IT or Data Science team.
• Big Data engineering and Cloud technologies: Elastic Stack, AWS, Google Cloud, Apache Stack.

Skills:
• Analytical thinker with exceptional problem-solving aptitude.
• Communicating complex technical matters in layman's terms to non-technical stakeholders.
• Expertise across Microsoft's Stack including Excel, Power BI, Visual Studio, Azure.
• Expert in Query and program languages MS SQL Server, T-SQL, PostgreSQL, MY SQL, Python, R.
• Excellent working knowledge of ETL packages such as SSIS, Talend.
• Skilled in developing a wide range of APIs.
• Working in Windows and Linux development environments.
• Creating Statistical and Machine Learning models

Jobcode: Reference SBJ-r0bvk8-3-141-30-162-42 in your application.