Senior Data Scientist

Description

Job Summary: We are seeking a Data Scientist to join our team dedicated to a client in the financial services industry, focused on analytical data modeling, data pipelines, and data optimization. Key Highlights: 1. Expertise in analytical data modeling and dimensional modeling 2. Building and optimizing data pipelines 3. Collaborating with business areas to deliver data-driven insights We are looking for a Data Scientist to join our team, which is exclusively dedicated to a client in the financial services industry. **Responsibilities and Duties** * Design, develop, and maintain **analytical data models**, with emphasis on **dimensional modeling (star schema)** to support dashboards and analytics 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 data analysis, identify patterns, and support data-driven decision-making. * 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 to architecture, data 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) * Querying data stored in **Amazon S3** * Experience with dimensional modeling (facts, dimensions, star schema). * Hands-on 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 data cataloging (Data Quality, Data Catalog). **Here at FCamara, we are \#SangueLaranja!** We have been in the market for 17 years, partnering closely with our clients to deliver 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 sharing knowledge, fostering community, and harnessing the power of knowledge to drive transformation!** We run initiatives and social actions that promote professional development, such as the Orange Juice tech community, our 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 values embedded in our DNA.** **So, are you ready to join an amazing team and become the protagonist of your own story?**