The Business Intelligence (BI) team is responsible for designing & developing the technologies that support data warehousing, data mining & reporting for the Group.
CIOracle DatabaseSQL
Main Purpose of the Role :
To enhance the existing Risk data warehouse and associated reporting.
Key Responsibilities:
o Staging additional data from upstream systems into the SQL Server Staging DB
o Writing Stored Procedures to publish the data into the Risk Data Warehouse
o Loading the data into Power BI Data Models
o Enhancing SSRS reports to include the additional data
o Writing Control-M jobs to orchestrate the batch processes
o Documenting changes made in the required format
o Testing and releasing changes
o Diagnosing issues and applying technical changes to remediate
MUST
Skill Overview
Snowflake – Mandatory (At least 1 year project experience is preferred, If there is no significant experience, SnowCore certification would be fine)
SnowPipe / Copy Into
Tasks / Stream
Advanced SQL / Complex transformations in SQL
Cloning
Credit optimisation
Snowflake query history
Multi cluster warehouse / Scale Up etc
Role management
Performance optimisation
Data warehousing knowledge
SCD II
Merge
Data Quality
SQL Server / Oracle Database – At least 2 years’ experience - Mandatory
Database CI / CD pipeline (team city etc) – Good to have
Deployment across multiple environments
Handling DDL and DML changes in DB
NICE TO HAVEOptional Skills:
Python
PowerShell
Azure Data Lake
Azure Data Factory
Azure Functions
Azure Key Vault
Power BI / DAX
Control M – Schedule
Luxoft Poland
2500
Luxoft, a DXC Technology Company, is a global digital strategy and software engineering firm with about 18,000 international employees within its 44 offices in 21 countries. It is headquartered in Zug, Switzerland.
In January 2019, Luxoft was acquired by U.S. company DXC Technology. Luxoft partnered with LG Electronics to create a next-generation Autonomous Mobility concept vehicle that integrates consumers' personalized digital lifestyles into a driving experience. Luxoft enabled Switzerland's first Blockchain based e-vote platform with the City of Zug and Hochschule Luzern's Blockchain Lab.
Luxoft, a DXC Technology Company is a world-renowned company. It has been present on the Polish market for over 11 years. We have offices in Krakow, Warsaw, Wroclaw, and Tri-City. We employ almost 2,500 experienced experts carrying out projects for over 40 clients from the financial, automotive, medical, tourist industries, etc. We work for many international clients, including the USA, Great Britain, and Switzerland.
So far, Luxoft Poland has made a name for itself as a company that offers work on innovative projects, we offer various experiences in the field of IT, opportunities for rapid development, an extensive training program, and attractive benefits for employees.
At present, 62% of Luxoft Poland employees come from Poland, and 38% from around 50 countries, including Ukraine, Brazil, India, Turkey, Spain, Portugal, Italy, Romania, USA, etc.
At Luxoft, a DXC Technology Company, as much as 85 percent of employees are experts with the "Senior" experience level, with at least five years of experience. We care about our employees, so every day we try to provide them with the best possible conditions for work and development.
Technology is our passion! We focus on top engineering talent means that you will be working with the best industry professionals from around the world. Because of that, Luxoft is a global family with an epic atmosphere – we love what we do!