Total yrs of Exp: 8+ yrsLocation:Balewadi, PuneTechnical skills and core competenciesStrong 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 mustHands-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 SQLThorough 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 desiredExperience in designing Data visualization with different tools such as Tableau and PowerBI is desirable.ResponsibilitiesParticipate in the design and developing features in the existing Data Warehouse.Provide leadership in establishing connection between Engineering, product and analytics/data scientists team.Design, implement, update existing/new batch ETL pipelinesDefine and implement data architecture.Partner with both engineers and data analysts to build reliable datasets that can be trusted, understood, and used by the rest of the company.Work with various data orchestration tools (Apache Airflow, Dagster, Prefect and others)Embrace a fast-paced start-up environment.You should be passionate about your job and enjoy a fast-paced international working environment.Background or experience in the telecom industry is a plus but not a requirement.Love automating and enjoy monitoring
Job Title
Data Architect