Senior Data Analyst - ODC

About Capillary:

Capillary offers an Intelligent Customer Engagement platform to retailers and consumer businesses managing the entire life cycle of customer data from acquisition, analysis, insights, and activations.

Over 400 marquee brands across 30+ countries, including global conglomerates like Tata, Shell, VF Brands, Walmart, Al-Futtaim, KFC, Starbucks, Madura Garments, Landmark Group, trust Capillary to enable easy and seamless consumer experiences. With over 600 million consumers and 50000 stores on the platform, Capillary is Asia s leading SaaS Product Company. Over 500 Capillary associates across 14 global offices are continually innovating to find new ways for brands to make their consumers lives easier, and experiences memorable. Capillary is backed by Warburg Pincus, Sequoia Capital, Norwest Venture Partners, Qualcomm Ventures, and American Express Ventures. Capillary s tech stack is always at the forefront of cutting edge technologies that work at a humongous scale.

For more information, please check our website http://www.capillarytech.com/

About Our Offshore Delivery Center (ODC) in Mysore:

Capillary s ODC is a dedicated facility located in Mysore. The center is an upcoming dedicated capability hub set up to handle various aspects of business operations, such as software development, customer services and support, etc. Our ODC offers you a chance to be part of a global team that drives innovation, excellence, and growth, providing you exposure to our diverse clientele and projects.

Located in the quaint city of Mysore, At ODC we promise to provide you excellent professional growth with competitive salaries at the same time ensuring better quality of life with a lesser cost of living, away from the hustle and bustle of overpopulated tier 1 cities.

At our upcoming Offshore Delivery Center, your skills and passion will contribute to groundbreaking projects that shape the future. If you are ready to take on new challenges, work with global leaders, and make a significant impact, we want to hear from you! Apply now.

JOB DESCRIPTION

2+ years of relevant work experience in a ETL/DB management

Advanced SQL Python 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

Tool and Technology Management: Stay abreast of the latest advancements in data

analytics tools and technologies, and make recommendations for their adoption to

improve efficiency and effectiveness within the team..

Data Analysis and Reporting: Collaborate with team members to analyze complex data

sets, identify trends, and derive actionable insights to support decision-making

processes across the organization.

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

KEY RESPONSIBILITIES

Create SQL transformation queries to clean large and complex historical data based on

business requirements

Prepare DUR report to chart out 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