Join us to contribute to our Data Warehouse solution based on Microsoft Technologies for one of the largest e-commerce destinations in the US. You'll be working in a mutli-location Agile team. The position is in Riga, Latvia.
Primary Duties And Responsibilities
Develop complex stored procedures, functions, triggers, views and queries in support of application development
Develop integrations with 3rd party systems like Google Analytics, BigQuery, Funnel.IO, Workday, etc. using linked servers, API calls, files and other communication methods
Participate in application development projects and be responsible for the database architecture and design
Review and optimize existing stored procedures, functions, triggers and queries
Convert existing embedded SQL code into stored procedures
Develop custom scripts to automate various database management processes
Develop PowerBI reports
Define and review best practice standards for data integrity
Develop various ETL jobs for our Data Warehouse
Skills & Requirements
At least 3 years of professional work experience
Strong problem solving skills
Positive attitude and strong work ethic
Strong written and verbal English communications skills (to communicate with partners in USA)
A degree in Computer Science, IT or related field is considered a plus
Qualification
Strong experience in T-SQL, procedures, functions, triggers, views and queries
Experience with Microsoft SQL Server 2017/2019/2022
Knowledge of PowerBI is considered a plus
Strong experience in query/process optimization and database maintenance
Experience with SSRS, SSAS, SSIS, & SSDT
Working knowledge of MySQL databases
Knowledge and experience of Data Warehouse concepts
C# knowledge is considered a plus
We Provide
Agile culture, continuous improvement process
Friendly and highly-qualified colleagues
Challenging international projects
Competitive salary, yearly reviewed
Real possibilities of growth
Direct employment by Latvian company with full social-security, paid vacations & sick leaves
Flexible work schedule, option to combine work with studies
Remote Work possibilities
Excellent working conditions
Modern top-floor spacious office in Riga with large terrace
Lounge zone in the office with ping-pong, gaming console and other entertainment
Powerful hardware: Apple or Lenovo laptops, choice of macOS/Windows/Linux, best software/tools
Company paid office parking, bicycle parking available
Free snacks and variety of drinks in the office
Monthly company events
Large Summer & Winter parties
Learning and innovations - internal demos & trainings, individual mentorship
Ability to attend local & international conferences
If you would like to work in a great team with the latest technologies on really challenging international projects, we look forward to seeing your resume.
Apply for position View other Positions
How strong is your resume?
Upload your resume and get feedback from our expert to help land this job
How strong is your resume?
Upload your resume and get feedback from our expert to help land this job