Position Data Analyst
Experience 01 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. 01 years of Experience.
- 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 problemsolving skills ability to triage technical issues and drive resolution with crossfunctional teams
- Hands on experience in analytics driven projects involving data exploratory analyses
Good to have:
- Data modeling data warehousing and building ETL pipelines
- Detailed knowledge of cloudbased 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 Amazons Business Data Engineering and Continuous Integration teams to understand existing datasets.
- Provide the database architect detailed information of the datasets to create a unied 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 Technology
data,analytics,aws,datasets,etl,skills,teams,big data,cloud,load,python,sql,excel