DB/BI engineer Middle to Senior @ VisiQuate Inc in VisiQuate Inc

Weare looking for adynamic, forward thinking SQL developer tojoin our development team working with the latest technology. The ideal candidate is a driven individual, who is not afraid to take on large projects and is excited about honing their development skills. In this position, you will be responsible for managing existing ETL process to ensure accuracy and reliability as well as performing daily ETL and DBA tasks in support of the business and create new ETL. The successful candidate will have solid bedding of SQL Developer skills, T-SQL and an understanding of, or experience with the Microsoft BI Stack including SSIS. Experience with DBA functions including general maintenance, tuning, replication, and query optimization is a plus. Project description VisiQuate isadaily SaaS-based service for healthcare and enterprise clients that makes the volume, variety, and velocity ofBig Data simple and actionable. VisiQuate has data scientists, visual scientists, and subject matter experts who integrate Terabytes ofincompatible Big Data onto asingle platform. We are using cutting edge technologies in order to deliver the best SaaS BI platform. We offer Work in a team of smart and talented people; Be a part of a fast-growing product company; Comfortable office in the city center or hybrid remote type of work; Holidays per Ukrainian calendar; Flexible work schedule within Ukrainian business hours and a friendly atmosphere in the office; Free English classes; Computer devices. DB/BI engineer Krakow (Poland), remote Minimum 1 years’ ETL process and solution implementation experience with numerous project successes demonstrating a strong aptitude in all aspects of data integration and data warehousing; Minimum of 3 years’ 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; BS and/or MS degree in Computer Science or equivalent combination of education and experience; Proficient in Microsoft Office business applications; English — Intermediate level or higher. As a plus Knowledge and expertise with Snowflake; 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. Weare looking for adynamic, forward thinking SQL developer tojoin our development team working with the latest technology. The ideal candidate is a driven individual, who is not afraid to take on large projects and is excited about honing their development skills. In this position, you will be responsible for managing existing ETL process to ensure accuracy and reliability as well as performing daily ETL and DBA tasks in support of the business and create new ETL. The successful candidate will have solid bedding of SQL Developer skills, T-SQL and an understanding of, or experience with the Microsoft BI Stack including SSIS. Experience with DBA functions including general maintenance, tuning, replication, and query optimization is a plus. Project description VisiQuate isadaily SaaS-based service for healthcare and enterprise clients that makes the volume, variety, and velocity ofBig Data simple and actionable. VisiQuate has data scientists, visual scientists, and subject matter experts who integrate Terabytes ofincompatible Big Data onto asingle platform. We are using cutting edge technologies in order to deliver the best SaaS BI platform. We offer Work in a team of smart and talented people; Be a part of a fast-growing product company; Comfortable office in the city center or hybrid remote type of work; Holidays per Ukrainian calendar; Flexible work schedule within Ukrainian business hours and a friendly atmosphere in the office; Free English classes; Computer devices. ,[Work with Client Services team, DBA team, Development Teams and Business Analyst toidentify and understand source data systems, aswell asprovide input for enhancements for standardization and consistency across the Enterprise (Transactional systems, Data Warehouse, etc.);, Map Import/Export Files tosource system data. Map source data todata warehouse models;, Develop and maintain ETL scripts and workflows, SQLqueries, Agent schedules, etc. using SVN orGIT for version control;, Define and capture metadata and rules associated with ETLprocesses;, Modify existing ETL processes toimprove performance and adapt tochanging requirements;, Use SQL Server query techniques and available tools, against the transaction system and the reporting data warehouse, toidentify and analyze data quality issues;, Perform daily review ofproduction data processes toensure successful completion;, Review databases toensure operating atoptimal performance levels;, Supports QA, Developers, Support and others allowing them tocomplete their assignments;, Develop, test, and debug new functionality, and maintain/enhance existing functionality inusing SQL, stored procedures;, Will ensure documentation isupdated and current for all release cycles;, Performs performance tuning ofqueries and stored procedures;, Create solution documentation and provide administrator and end user knowledge transfer/training.] Requirements: BI, SQL, ETL, T-SQL, SSIS, SQL Server, Data warehouse, OLAP, SSAS, Git, Performance tuning, Big Data, Snowflake Tools: Jira, Confluence, GIT. Additionally: Modern office, No dress code, Free coffee.