Job Description
- Strong Data Warehousing experience.
- Strong ETL/ELT experience with structured and unstructured (Preferred Mongo DB) data :
1. Strong Data modeling experience (Kimbal). Delivering logical and physical data models.
2. Strong Data modeling experience on relational database platforms like MySQL, Redshift, or any other, preferred Redshift
3. Strong SQL/PLSQL skills, join statements and query optimization
4. Strong in Python
5. Good to have experience in pyspark
6. Awareness of BI tools (preferred LOOKER) and Business Objects is desirable
7. Participate in design reviews and code reviews
8. Troubleshoot and resolve production issues
9. Resolve performance-related issues.
10. Knowledge of Data Science / ML / Analytics would be plus
11. Ability to work with colleagues across global locations remotely
12. Independent and able to work with little supervision
13. Able to mentor and supervise junior team members
14. Documenting all aspects of the data model design and SDLC
15. Gather and process raw data at scale (including writing scripts, web scraping, calling APIs, write SQL queries, etc.).
Required Skills and Qualifications :
- SQL/PLSQL
- ETL/ETL
- Python
- Pyspark (Optional)
- Any BI Tool like SiSense, Looker, Quick Sight, Tableau, Power BI, etc (Preferred LOOKER)
- Dimension Modelling (Kimbal) / Data warehousing
- Redshift (Good to have)
- OLAP Cubes