Database Analys

Detalji posla
OBJAVLJENO
Objavljeno na Feb 25th, 2020
STATUS
Apliciranje omogućeno
TRAJANJE
60 dana
VRIJEDNOST
$3000.00
LOKACIJA
Na lokaciji
TIP
Puno radno vrijeme
PRIJAVE
3
Potrebne vještine
  • Analiza Podataka
Job description MAKING A REPORT BI reports for the user are generated for specific reports not covered by standard Luceed ERP reports. BI reports are retrieved from the Luceed ERP database in 99% of cases. data visualization is done through Luceed dashboards, Luceed BI reports, Luceed Export ETL Transferring new users from old sw to Luceed. From previous sw we download data in various formats (connection to one of sql bases, excel, csv, ...). We analyze the downloaded data and transfer it to our database. MAKING AD-HOC REPORT For various purposes, ad-hoc reports are sometimes made to support / implement additional research on customer data DATA IMPORTS For existing users, various data imports from files that the user sends us (excel, csv, ..) are done. Mostly these are some larger datasets where manually entering through Luceed ERP would take a lot more time UPDATES DATA IN DATABASES ADDITIONAL TASKS (OPTIONAL AND DIVIDED IN ADDITIONAL KPIs): - optimization of existing sql queries - index optimization conditions - Excellent knowledge of SQL - Excellent Excel knowledge DESIRABLE KNOWLEDGE AND SKILLS: - working with data visualization tools (Power BI, Qlik, ...) - knowledge of business processes covered by ERP - Knowledge of MySQL administration and optimization - Experience working with Amazon Auror - programming (C #, Delphi, ...)

Da li ste poslodavac? Postavite sličan posao