Job Summary: We are seeking a Data Scientist to join our team dedicated to a client in the financial market, with a focus on analytical data modeling and pipelines. Key Highlights: 1. Dedicated engagement with financial market clients 2. Focus on analytical data models and pipelines 3. Optimization of data architecture and governance We are looking for a Data Scientist to join our team dedicated to a client in the financial market. **Responsibilities and Duties** * Design, develop, and maintain **analytical data models**, with emphasis on **dimensional modeling (star schema)** to support dashboards and analyses for credit departments. * Build and optimize **data pipelines** using orchestration and distributed processing tools. * Develop data ingestion, transformation, and validation routines in data lake and data warehouse environments. * Collaborate with business, operations, and technology teams to understand requirements and translate them into efficient data structures. * Conduct exploratory analyses, identify patterns, and support data-driven decision-making with actionable insights. * Document data models, transformation rules, data dictionaries, and ingestion flows. * Support squads and stakeholders in building KPIs, metrics, and analytical views. * Monitor database performance and propose continuous improvements in architecture, governance, and data quality. **Requirements and Qualifications** **Mandatory** * **Apache Airflow** for pipeline orchestration. * **PySpark** for distributed processing and large-scale data manipulation. * **Python** applied to data engineering and data science. * **Pandas** and **Numpy** for data manipulation and analysis. * Advanced **SQL** for querying, modeling, and optimization. * Experience with **AWS Cloud**, including: * **AWS Glue** (ETL/ELT) * **Amazon Redshift** (data warehouse) * Queries on data stored in **Amazon S3** * Experience with dimensional modeling (facts, dimensions, star schema). * Experience with data pipelines and best practices in data governance. **Desirable** * Experience in the financial sector, especially in **credit operations or credit products**. * Familiarity with visualization tools (Power BI, Tableau, Looker). * Knowledge of version control (Git) and software development best practices. * Understanding of data quality and cataloging (Data Quality, Data Catalog). **Here, we are \#SangueLaranja!** We have been in the market for 17 years, side by side with our clients, delivering transformative experiences. We are a technology and innovation ecosystem with global expansion; beyond Brazil, we operate in Europe and the UK, with offices in Portugal, London, Dubai, and the Netherlands. **F for Formation: we believe in practicing a culture of knowledge sharing, community spirit, and that knowledge holds the power of transformation!** We run initiatives and social programs promoting development, such as the Orange Juice tech community, the Training Program, our leadership school, and numerous partnerships with NGOs and Edtechs. **At FCamara, everyone is welcome; for us, Diversity, Respect, and Ethics are non-negotiable elements embedded in our DNA.** **So, are you ready to join an amazing team and become the protagonist of your own story?**