Our client is an EU subsidiary of a Global Financial Bank working in multiple markets and asset classes.
DWH / ETL developer will work closely with the Development Lead to design, build interfaces and integrate data from a variety from internal and external data sources into the new Enterprise Data Warehouse environment. The ETL Developer will be responsible for developing ETL primarily utilizing Microsoft & Azure technologies within industry recognized ETL standards, architecture, and best practices.
- Act as a technical expert in the designing, coding, unit testing, supporting, and debugging of data warehouse software components in all aspects of SDLC
- Apply cloud and ETL engineering skills to solve problems and design approaches
- Troubleshoot and debug ETL pipelines and creating unit tests for ETL pipelines.
- Assess query performance and actively contribute to optimizing the code
- Write technical documentation and specifications
- Support internal audit by submitting required evidence
- Create reports and dashboards in the BI portal
- Work with Development Lead, DWH Architect and QA Engineers to plan, implement and deliver best ETL strategies
- Work with business analysts to understand requirements to create technical design specifications, gaining a sound understanding of business processes for related applications so that integration processes fulfill the end-user requirements
- Communicate effectively in a collaborative, complex and high performing team environment as per Agile principles
MUST
- Proven work experience as an ETL Developer
- Advanced knowledge of relational databases and dimensional Data Warehouse modelling concepts
- Good understanding of physical and logical data modeling
- Very good understanding of modern SaaS / PaaS data solutions in a cost conscious approach
- Expert level of knowledge of Microsoft Data stack
- Experience in developing and deploying data oriented solutions in Cloud (Azure / Synapse Analytics / Fabric)
- Experience in designing and implementing data transformation and ETL layers using Data Factory, Notebooks
- Experience with PowerBI for report & dashboard creation. PowerQuery and/or DAX is an advantage.
- Experience in / understanding of Azure Data Lake Storage
- Knowledge / use of CI/CD tools and principles, preferably Azure DevOps or Bamboo
- Strong SQL knowledge, able to create complex SQL queries and good understanding of stored procedures, views, indexes, functions, etc.
- Good working knowledge of at least one scripting language. Python is an advantage.
- Experience with GIT repositories and working with branches. GitHub, Azure DevOps or Bitbucket experience are preferable.
- Ability to troubleshoot and solve complex technical problems
- Good understanding of software development best practices
- Working experience in Agile projects; preferably using JIRA
- Experience in working in high priority projects preferably greenfield project experience
- Able to communicate complex information clearly and concisely.
- Able to work independently and also to collaborate across the organization
- Highly developed problem-solving skills with minimal supervision
- Understanding of data governance and enterprise concepts preferably in banking environment
Verbal and written communication skills in English are essential.
NICE TO HAVEMicrosoft Fabric
- Snowflake
- Background in SSIS / SSAS / SSRS
- Azure DevTest Labs, ARM templates
- Azure PurView
- Banking / finance experience
Luxoft Poland
2000
Luxoft, a DXC Technology Company is a global digital strategy and software engineering firm with over 17,000 international employees within its 58 offices in 29 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 13 years. We have offices in Krakow, Warsaw, Wroclaw, and Gdansk. We employ over 2,000 professional experts carrying out projects for over 100 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 almost 80 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!