Responsibilities

• Develop complex stored procedures, functions, triggers, views and queries in support of application development
• 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

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
• A degree in Computer Science, IT or related field is considered a plus

• Strong experience in T-SQL, procedures, functions, triggers, views and queries
• Experience with Microsoft SQL Server 2012/2014/2016 and newer
• Knowledge of PowerBI is considered a plus
• Experience with SSRS, SSAS, SSIS, & SSDT
• Working knowledge of MySQL databases
• Knowledge and experience of Data Warehouse concepts

We offer

• 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

• Excellent working conditions
• Modern top-floor spacious office in Riga with large terrace
• Powerful hardware, 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
• Potential business trips to USA
• Free Office Library and ability to order books

• Premium Health insurance
• Company paid flu vaccination