Position: BI Engineer
Company: Allvue Systems
Category: SQL
Experience required: 2y
English level: intermediate
Published: 2021-09-01T00:00:00+03:00

**What we value**

•  Intelligent individuals looking to apply themselves creatively
• People who are comfortable speaking up, sharing ideas and driving change
• Innovation and creativity that comes from bringing people together from diverse backgrounds and experiences
• Energetic and passionate teammates looking for more than just a job to pay the bills
• Hard-working individuals who habitually do more than asked

**Job Summary**

BI Engineer will be responsible for support current ETL system, tune and increase performance, create new objects and processes. Will be involved into SQL development of stored procedures, views and code for providing datasets. Also will be involved into cube creation and tuning. Support and improve current ETL processes based on SSIS and BIML.

**Requirements**

•  Minimum of 3 years of relevant experience working in MS SQL
• Strong knowledge ща ETL processes and how to build ETL solutions.
• Strong knowledge and minimum of 3 years experience in SSIS development
• Understanding of principals OLAP/OLTP systems.
• Strong understanding of DWH principals.
• Experience with SSAS
• Knowledge and understanding of relational database design and programming.
• Basic knowledge of DAX, MDX
• Knowledge and production experience with developing, tuning and deploying SSRS reports and Power BI solutions
• Experience in Visual Studio, Microsoft Management Studio, Microsoft Power BI Desktop
• Background knowledge in finance, economics, statistics or mathematics a plus.
• Dedication to complete application development lifecycle including requirements gathering, analysis and design, coding, testing and deployment.
• Self-motivated, able to work within a project-based environment.
• Detail oriented and organized with an ability to meet deadlines
• As a plus: Experience with BIML.
• As a plus: Basic knowledge in Node.js, TypeScript, YAML, Snowflake

**Education**

•  Master’s degree or equivalent experience

**Responsibilities**

•  Develop, design, tune and maintain ETL system based on SSIS + MS SQL DWH.
• Design and develop SQL Server stored procedures, functions, views to be used during the data source creating process.
• Perform problem assessment, resolution and documentation in existing SSRS and Power BI reports.
• Troubleshoot data issues and defects to determine root cause.
• Develop and create transformation queries, views, and stored procedures for ETL processes, and process automations.
• Develop ad-hoc queries and stored procedures for data mining and data validation.

**What We Offer**

•  32 days Paid time off (PTO)
• 10 days Documented Sick Leave
• 5 days Undocumented Sick Leave
• 5 days Bereavement Leave
• 1 day Volunteer Day
• PE accountant support
• Parental Program
• Medical and Life Insurance
• Personal consultation (Psychologist, financier, lawyer)
• Daily practice of English
• English Language Shсool
• Udemy Corporate University
• Certification reimbursement
• Charity Matching Program
• Sport (yoga/pilates)
• Hobby clubs
• Corporate events and Teambuildings