IT recruitment agency MindHunt connects companies and IT professionals

BI Engineer

ABOUT COMPANY
Global FinTech company with 100+ development professionals in the Kyiv office and 500+ employees around the world (Miami, San Diego, New York, Kyiv, London, Chicago, and Houston). The company's customers are leading Wall Street and alternative investment firms that have diverse needs that are not met by off-the-shelf solutions.

ABOUT PROJECT

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.

Office Location

Kyiv/Remote

Conditions

  • Competitive compensation with an annual review, annual performance-based bonus
  • Medical insurance, life insurance
  • 32 day-offs per year, 15 sick leave days
  • English language school, Udemy courses, certification reimbursement
  • Corporate events and team buildings
  • PE accounting support

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.

Requirements

  • Minimum of 3 years of relevant experience working in MS SQL
  • Strong knowledge of 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
  • 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

Preferred/Nice to have skills

  • Background knowledge in finance, economics, statistics or mathematics a plus.
  • As a plus: Experience with BIML.
  • As a plus: Basic knowledge in Node.js, TypeScript, YAML, Snowflake

Why is this professional opportunity an excellent career step for you?

  • 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
Don’t miss your chance & send your resume