Position: Datawarehouse Architect (BI end-to-end, ETL)
Category: Lead
English level: upper
Years of experience: 11


Berlin Brand Group
Solution Architect Data warehouse
Responsibilities:
-	Architecting and designing large data platforms, data warehouses, data lakes, streaming applications, data ingestion and distribution pipelines
-	Migrate existing Data Warehouse to cloud Data Warehouse using best practices
-	Supporting the BI with real-time process reporting and allowing the business stakeholders to interact with operational processes
-	Interfacing with different HQs to adjust and to adapt existing solutions to entire global Data Warehouse
-	Evaluating, testing, and realizing modern data solutions offerings
-	Design and implement cloud-based solutions for existing solutions and new ones

Jean Edwards Consulting, Latvia
Database Architect
Insurance/Reinsurance clients
The projects were dedicated to migrating financial data (contracts, accounting) from different sources to target system SICS.
Responsibilities:
-	ETL design and implementation
-	Design DWH structure
-	Data validation, Data Quality
-	Data migration
-	Data reconciliation
-	SQL performance tuning

Accenture, Latvia
Pharma client
Technical Team Lead
The project was dedicated to providing support for multiple different applications and enhance existing data flow.
Responsibilities:
	Coordinate work of cross ST team (15 ppl)
	Technical point of contact for the offshore team in supporting to solve tasks according to existing SLA
	Continuous improvement for Trade Marketing
applications
	Key contributor in communication between business and team
	Participating in Due Diligence, Knowledge
Transition sessions
	Clarify business requirements for incoming business requests for change requests to team
	Manage risks and issues on the service

EPAM, Belarus
UK Insurance client
Senior DWH developer

The project was dedicated to reorganizing old DWH structure for a new ETL process for extracting data including writeback operations to check and edit existing data in older system.
Responsibilities:
	ETL design and implementation
	Design DWH structure
	Data validation, Data Quality
	Integration with Azure
US Legal Tracker
ETL / DWH Developer

The project was dedicated to implement multidimensional SSAS cube, adjust existing ETL process and DWH structure.
Responsibilities:
	Design of SSAS cube
	DWH modeling
	Implementation and maintenance of ETL
	Performance tuning of the implemented ETL solution
	Architecture design
	Azure integration