Data Architect

Total yrs of Exp : 10+ yrs

Location : Balewadi, Pune

Technical skills and core competencies

• Strong understanding of Data Architecture and models and leading data driven projects.
• Solid expertise and strong opinions on Data Modelling paradigms such as Kimball, Inmon, Data Marts, Data Vault, Medallion etc.
• Strong experience with Cloud Based data strategies and big data technologies – AWS Preferred.
• Solid experience in designing data pipelines for ETL with expert knowledge on ingestion, transformation, and data quality is a must
• Hands-on experience in SQL is a must.
• Deep understanding of PostGreSQL development, query optimization and designing indexes is a must.
• An ability to understand and manipulate intermediate to complex level of SQL
• Thorough knowledge of Postgres PL / SQL to work with complex warehouse workflows.
• Ability to use advanced SQL concepts such as RANK, DENSE_RANK along with applying advanced statistical concepts through SQL is required.
• Working experience with PostGres SQL extensions like PostGIS is desired.
• Expertise writing ETL pipelines combining Python + SQL is required.
• Understanding of data manipulation libraries in python like Pandas, Polars, DuckDB is desired
• Experience in designing Data visualization with different tools such as Tableau and PowerBI is desirable.

Responsibilities