[Job 23567] Systems Architect (Data Modelling), Brasil

Work set-up: 
Full Remote
Contract: 
Experience: 
Senior (5-10 years)
Work from: 

Offer summary

Qualifications:

Strong experience in designing, developing, and deploying data pipelines and data products., Proficiency with AWS Data Platform services such as Glue and S3., Experience in translating business problems into data solutions, including BI, analytics, and machine learning., Knowledge of data modeling methodologies like Star Schema and Data Vault..

Key responsibilities:

  • Develop and maintain conceptual data models related to Financial Services.
  • Design and implement data schemas and logical models, including Lakehouse architectures.
  • Collaborate with stakeholders to define analytical questions and translate them into metrics.
  • Oversee the development of ETL/ELT pipelines ensuring data quality and governance.

Ci&T logo
Ci&T
5001 - 10000 Employees
See all jobs

Job description

We are tech transformation specialists, uniting human expertise with AI to create scalable tech solutions.
With over 7.400 CI&Ters around the world, we’ve built partnerships with more than 1,000 clients during our 30 years of history. Artificial Intelligence is our reality.

We are looking for a Senior Architect with strong Data experience to be part of our team working for EMEA clients. In this position, you will lead technically and design software solutions, working closely with teams in the EU, Brazil and other countries in Latin America.

We are looking for someone who has:

Solid experience designing, developing and deploying pipelines, datalakes, data meshes and other data products;
Solid experience on understanding, questioning, prioritizing and translating business problems into data solutions (BI, Analytics, deterministic and statistical models, machine learning);
Solid experience with AWS Data Platform (Glue, S3);
Experience with CICD pipelines;
Ability to share your knowledge with more junior team members.

The main responsibilities include, but are not limited to:

Develop and maintain conceptual data models (Financial Services related);
Evaluate and select appropriate modeling methodologies (e.g. Star Schema vs. Data Vault);
Collaborate with stakeholders to frame analytical questions and translate them into metrics;
Identify and catalog the Data Universe: source systems, data domains, and key entities;
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);
Leverage and extend existing Data Lake assets to build out the Data Universe;
Implement dimensional modeling patterns (star schemas or Data Vault) with defined grain, keys, and SCD handling;
Specify and oversee ETLELT pipelines to populate and refresh models, ensuring data quality, lineage, and observability;
Establish governance standards for data stewardship, access controls, and metadata management;
Optimize schemas and storage layouts for query performance, scalability, and cost efficiency;
Maintain uptodate documentation, including data dictionaries, ER diagrams, and architecture diagrams;

We expect candidates to have knowledge in some, but not necessarily all fields below:

Knowledge of nonfunctional requirements (performance, security, privacy, GDPR and etc);
Knowledge of Design Patterns, Clean Architecture and Clean coding;
Knowledge of unit, integration and E2E testing.
Our benefits:

Health and dental insurance
Meal and food allowance
Childcare assistance
Extended paternity leave
Partnership with gyms and health and wellness professionals via Wellhub (Gympass) TotalPass;
Profit Sharing and Results Participation (PLR);
Life insurance
Continuous learning platform (CI&T University);

Required profile

Experience

Level of experience: Senior (5-10 years)
Spoken language(s):
English
Check out the description to know which languages are mandatory.

Related jobs