ETL Data Architect

You should have at least 10+ years of experience in Data Architecture and leading data driven projects. Your responsibilities will include having a strong understanding of various Data Modelling paradigms like Kimball, Inmon, Data Marts, Data Vault, Medallion, etc. You should also have solid expertise in Cloud Based data strategies with a preference for AWS, as well as big data technologies. Designing data pipelines for ETL will be a key part of your role, so expert knowledge on ingestion, transformation, and data quality is a must. Hands-on experience in SQL is necessary, along with a deep understanding of PostGreSQL development, query optimization, and designing indexes. You should be able to understand and manipulate intermediate to complex levels of SQL. Thorough knowledge of Postgres PL/SQL for working with complex warehouse workflows is also required. Using advanced SQL concepts such as RANK, DENSE_RANK, and applying advanced statistical concepts through SQL is necessary. Working experience with PostGres SQL extensions like PostGIS is desired. Expertise in writing ETL pipelines that combine Python and SQL is a requirement. An understanding of data manipulation libraries in Python like Pandas, Polars, DuckDB is desired. Additionally, you should have experience in designing Data visualization using tools such as Tableau and PowerBI.,