DWH DEVELOPER

  • Full-time
  • Latvia

SUN FINANCE DESCRIPTION

At Sun Finance you will be a part of a company where everything is possible. Here we set only the highest goals and work hard to reach them. Our team's success-oriented mindset has allowed us to land a spot in the prestigious ranking of Europe's fastest-growing companies recognized by The Financial Times for four consecutive years. We believe in the power of companionship - supporting our colleagues and sharing knowledge is an important part of our every day life. Managed by seasoned professionals in finance, IT, risks and fintech, Sun Finance will offer an opportunity for you to grow along with us. Join Sun Finance!


P.S. We also know how to have fun.

JOB MISSION

Looking for an experienced DWH developer who will participate in the development of a corporate Datawarehouse. Will be working closely with Data Analysts, BI, and Data Science teams, addressing their needs to power insight and decisions for the business

 


AS A DWH DEVELOPER, YOU WILL

  • Perform the design and extension of data marts and data models
  • Design and implement ETL processes and data architecture to ensure the proper functioning of analytics applications and corporate dashboards
  • Integrate New data source
  • Carry out monitoring, tuning, and database performance analysis
  • Manage data warehouse
  • Work with Oracle (vendor) to identify and resolve technical limitations and issues
  • Ensure high data quality, integrity, and timely availability to data warehouse users
  • Provide best practices and technical expertise to data warehouse users
  • Support business and operational reports, Tableau visualization dashboards


REQUIREMENTS

  • Experience with design of DWH data models (Dimensional, Data Vault)
  • 3 – 5 years experience with developing ETL processes using technologies such as Oracle Data Integrator, SSIS, SAP BO, and similar.
  • Strong experience with RDBMS like Oracle, SQL Server, PostgreSQL
  • Outstanding knowledge of SQL.
  • Knowledge of Oracle Cloud, Oracle Autonomous data warehouse
  • Semi-structured (JSON) data processing
  • Experience with BI visualization tools such as Tableau, PowerBI, or similar

 

As advantage:

  • Experience with Kafka Connect / similar streaming technologies
  • Hands-on experience with Java, Python, or other programming/scripting languages
  • Good knowledge of the English language


BENEFITS

  • Be a part of Top 1 Europe financial company
  • Ability to work for an employer that will motivate, appreciate, and care for you
  • Flexible working hours start as late as 10 am
  • Ability to work from home 2 days per week
  • Friendly and collaborative environment and modern office
  • Health insurance
  • Team buildings, company events, and an active social life
  • Training opportunities, seminars, webinars, workshops etc.
  • Receive gifts for birthdays and other important events
  • Receive bonuses for long-term cooperation like Extra holidays, etc.
  • Enjoy fresh beverages in the office
  • Enjoy the private gym
  • Salary range 3570-5750 EUR gross depending on work experience, and skills