• Experience working with any of the following: MS SQL Server/Oracle/MySQL/Vertica, MS SSAS/Mondrian OLAP. Experience with Vertica and Mondrian would be a big plus
• Proficient in ETL and hands-on experience with ETL tools. Must be able to develop and troubleshoot complex queries and handling big data (Data transfer, import/export, storage, performance and security)
• Understanding of OLAP system (multidimensional cubes, fact tables, dimensions, measures etc.)
• 6 months of SQL (Dynamic SQL, stored procedures, window functions etc.) hands-on experience
• English at least Intermediate level (Both spoken and written)
• Familiar with Scrum/Kanban methodology and Agile process
• Ability to work effectively individually and as a part of a team
• Results-oriented, self-motivated and quick-learner
• Good interpersonal communication skills
• Experience with big data technologies such as Hadoop, SPARK, MongoDB etc.
• 1+ years of OLAP system hands-on experience
• Ability to read and troubleshoot
• Understanding of
• Experience with JIRA/Confluence requirements tracking system
• SSRS Hands-on experience
• Experience with Linux as a user
• Familiar with healthcare workflow and coding systems (CPT, HCPCS, ICD, HL7, etc)
Friendly team and enjoyable working environment
Opportunity for self-realization
Career and professional growth
Competitive compensation based on your qualifications, experience and skills
Paid sick leave and vacations
English classes with a certified English teacher
Office in a comfortable business center, located near a subway station
Official journeys abroad with expenses reimbursement
Flexible working hours
Company-owned gym and shower
Convenient parking near the office building
Room for bicycle parking
Corporate events and meetings
Large recreation area
Not an open space office
We work remotely for now
• Design and develop end-to-end BI projects
• Gather, analyze, clean and transform data from different sources for Business Intelligence
• Work with Business Analysts in analyzing business requirements
• Work with Engineers and product teams distributed across multiple locations
• Effectively document and communicate results
• Stay up to date on current trends in big data analytics and healthcare
Client Implementation team transfers clients who used SQL databases to Vertica and OLAP
The syntax changes, sometimes there are simply no alternative functions and you need to come up with a workaround. It is not only about transferring old tables from one database to a new one, but many conditions are also complicated or improved, and often this may concern join logic.