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

Participate 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 pipelines

Define 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