DB/BI engineer (offline)

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.

About VisiQuate

VisiQuate, Inc came into existence in 2009 as a California innovative product house working in the area of business analytics and big data. Our products integrate and simplify complex big data from multiple sources and deliver meaningful insights, prediction pathways, and actionable workflows. We have clients in healthcare, finance, energy, and other industries. Today we have offices in the USA and Ukraine.

Every day, we cut through the volumes of big data that overwhelm our clients, and let them see the hidden trends, anomalies, and outliers that make their data a valuable asset. We do this by delivering crisp, clean visualizations. So, to describe an advanced set of benefits simply, we sum it up in two words: “You’ll see.” This describes the way we make actionable insights jump off the screen. It also says we’re confident that we can deliver every benefit we promise, and invite you to let us prove it.

Our Values

Long before we wrote our first lines of code, we thought hard about the kind of company we wanted to be. One memorable night in 2009 (March 11) we wrote down our basic values and have never felt the need to revise them. Why would we?
LEADERSHIP. We lead by example and by empowering our clients, partners and staff.
OPTIMISM. Our glass is decidedly half full…and then some.
CURIOSITY. We approach the who, what, where, when, why, and how questions with an inquisitiveness that delights in discovering fresh ideas.
ZEAL. We approach our work with eagerness, determination, and contagious enthusiasm.
INTEGRITY. We value conscience, character, truth, and honor as fundamental principles.
INNOVATION. We believe in a continuous and relentless pursuit of all which seems unimaginable.
FUN. We believe that hard work and fun go hand in hand.
COMPASSION. We will lead not only with our heads; but with our hearts.
GIVING. We will gladly give our time and money to causes we believe in.


Company Life

We work in close cooperation within our teams. Everybody is welcome to share ideas and suggest improvements. To support cooperative spirit in the company, we travel a lot between our home countries.
We work hard, and we party hard!
Summer parties and New Year outings. Common sport activities, including team marathon runs, weekend bicycle rides, and table football competitions for those who prefer to stay indoors.

Company website:
https://www.visiquate.com/

DOU company page:
https://jobs.dou.ua/companies/visiquate/