Job Description
As a Senior Architect with strong Data experience, you will develop and maintain conceptual data models (Financial Services related) and evaluate and select appropriate modeling methodologies (e.g. Star Schema vs. Data Vault). You will collaborate with stakeholders to frame analytical questions and translate them into metrics. You will identify and catalog the Data Universe: source systems, data domains, and key entities. You will also design canonical schemas and logical models with consistent naming conventions, data types, and partitioning strategies; architect and recommend a Lakehouse solution (e.g. Delta Lake, Apache Iceberg, Hudi).
Moreover, you will leverage and extend existing Data Lake assets to build out the Data Universe and implement dimensional modeling patterns (star schemas or Data Vault) with defined grain, keys, and SCD handling. You will specify and oversee ETL/ELT pipelines to populate and refresh models, ensuring data quality, lineage, and observability; establish governance standards for data stewardship, access controls, and metadata management; and optimize schemas and storage layouts for query performance, scalability, and cost efficiency. You will also maintain up-to-date documentation, including data dictionaries, ER diagrams, and architecture diagrams.
About CI&T
We are tech transformation specialists, uniting human expertise with AI to create scalable tech solutions.