Position: DB/BI engineer
Company: VisiQuate, Inc.
Category: SQL
Experience required: 3y
Published: 2021-11-01T00:00:00+02:00

**Requirements:**

● ETL process and solution implementation experience with numerous project successes demonstrating a strong aptitude in all aspects of data integration and data warehousing;
● Experience in database concepts, logical modeling, physical design and database installation, configuration, and optimization;
● Process knowledge and experience with SQL Server, SSIS etc;
● Experience in ETL tools such as: MSBI (SSIS), Datastage, Data integrator, Kettle, Informatica etc;
● Experience in Data Migration from database and data warehouse application;
● Experience in Scrum methodology;
● BS and/or MS degree in Computer Science or equivalent combination of education and experience;
● Working knowledge of Windows Server operating systems;
● Strong effort estimation skills supporting input to statement of work (SOW) and project plan documents;
● Proficient in Microsoft Office business applications;
● English — Intermediate level or higher.

**Will be a plus:**

● Knowledge and expertise with OLAP databases: Microsoft SQL Analysis Services (SSAS), Microstrategy, Cognos, etc;
● Understanding US healthcare data governance policies including the protection of protected health information (PHI) or personal information (PI) and the reporting of breaches of defined policies.

**We offer:**

● Learn cutting edge technologies;
● Work in a team of smart and talented people;
● Be a part of a fast-growing product company;
● Comfortable office in the city center;
● Holidays per Ukrainian calendar;
● Flexible work schedule within Ukrainian business hours and a friendly atmosphere in the office;
● Free English classes.

**Challenges:**

● Work with Client Services team, DBA team, Development Teams and Business Analyst to identify and understand source data systems, as well as provide input for enhancements for standardization and consistency across the Enterprise (Transactional systems, Data Warehouse, etc.);
● Map Import/Export Files to source system data. Map source data to data warehouse models;
● Develop and maintain ETL scripts and workflows, SQL queries, Agent schedules, etc. using SVN or GIT for version control;
● Define and capture metadata and rules associated with ETL processes;
● Modify existing ETL processes to improve performance and adapt to changing requirements;
● Use SQL Server query techniques and available tools, against the transaction system and the reporting data warehouse, to identify and analyze data quality issues;
● Perform daily review of production data processes to ensure successful completion
● Review databases to ensure operating at optimal performance levels
● Review and report disk utilization as required input to capacity planning efforts;
● Supports QA, Developers, Support and others allowing them to complete their assignments;
● Develop, test, and debug new functionality, and maintain/enhance existing functionality in using SQL, stored procedures;
● Will ensure documentation is updated and current for all release cycles;
● Performs performance tuning of queries and stored procedures;
● Create solution documentation and provide administrator and end user knowledge transfer/training.