Senior Data Analyst

Position - Data Analyst Location - Bangalore/ Bengaluru office - Hybrid Experience- 6+ years Clairvoyant is a global technology consulting, services, and product company. We help organizations build innovative products and solutions using enterprise stack, big data, analytics, and the cloud. Our global team consists of experienced professionals, with backgrounds in design, software engineering, analytics, and data science. Each member of our team is highly energetic and committed to helping our clients achieve their goals. Must Have: Min. 5+ years of Experience on SQL Experience on working with very large datasets Skilled with writing, tuning, and troubleshooting SQL queries (Must Have) Experience with BI tools like Quicksight, Tableau, Power BI, etc. Strong organizational skills and planning prowess, with excellent attention to detail Good analytical and problem-solving skills, ability to triage technical issues and drive resolution with cross-functional teams Hands on experience in analytics driven projects involving data exploratory analysesGood to have: Data modeling, data warehousing, and building ETL pipelines Detailed knowledge of cloud-based data warehouses (primarily AWS), architecture, infrastructure components, ETL and reporting/analytic tools and environments. Must have experience with Big Data technologies such as Hive/Spark, AWS Glue, AWS Lambda , Redshift Strong Python, Spark skills Role & Responsibilities: Work with the concerned Amazon teams, including Amazon s Business, Data Engineering and Continuous Integration teams, to understand existing datasets. Provide the database architect detailed information of the datasets to create a uni ed warehouse schema that cuts across use cases Write ETL (Extract, Transform, Load) scripts to load facts and dimensions data using SQL (Structured Query Language) queries, document catalog data Education: Minimum of 15 years of formal education - BE/BTech or Graduate / Postgraduate in Computer Science / Information TechnologyYou are important to us, let s stay connected! Every individual comes with a different set of skills and qualities so even if you don t tick all the boxes for the role today, we urge you to apply as there might be a suitable/unique role for you tomorrow!