BriefCase
BriefCase

Data Analyst Job in Capillary Technologies

Data Analyst

Capillary Technologies 4+ weeks ago
Apply Now
Job Summary JOB DESCRIPTIONCREDENTIALS REQUIRED
  • 1-3 years of relevant work experience in an ETL/DB management
  • Advanced SQL skills(Optimize complex SQL queries) and experience in joining/cleansing datasets from multiple sources
  • Should have knowledge on export and import of Database objects from one database to another database
  • Proficiency in Microsoft Excel and Python-Statistical Programming
  • Data Visualization.
  • Presentation Skills
  • Ability to work in high-pressure situations
  • Ability to escalate problems for any support needed for problem
    resolution
  • Ability to organize and prioritize tasks and meet deadlines
  • Good analytical and problem-solving skills
  • Good oral and written communication skills, analytical skills and a
    highly professional attitude are essential
EXPERTISE AND QUALIFICATIONSKEY RESPONSIBILITIES
  • Create SQL transformation queries to clean large and complex historical data based on business requirements
  • Prepare DUR report to chart out a complete understanding of the existing data and results of the sanity and hygiene check conducted
  • Perform data profiling and data quality assessment to create DQR reports to support data migration and analytics activities
  • Maintain detailed documentation on activities performed to drive data accuracy and sanctity for each client
  • Create and upload import ready file into data warehouse once DQR is approved by the client
  • Perform standard checks to validate data accuracy/data loss between pre and post-import stage
  • Upload the delta data and perform an incremental data check to assess the system integrity post-implementation
  • Stay abreast of new technologies and suggest best practices to build reusable, scalable ETL modules and automation of data
  • Prepare reports on data risk mitigation and escalate any data risks identified in the process
Experience Required :

1 to 3 Year

Vacancy :

2 - 4 Hires

Similar Jobs for you

See more recommended jobs