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