Job Summary: We are seeking a Data Analyst to transform our Data Lake into structured insights for decision-making within the Finance and Credit team. Key Highlights: 1. Bridge the gap between Data Engineering and Business 2. Simplify, professionalize, and digitize financial life 3. Innovate, learn, and grow in the condominium market Condominiums face a unique financial reality—distinct from that of corporations or individuals. It was precisely this challenge that gave rise to **CondoConta**, the first fintech created exclusively to transform the condominium market. More than just a bank, we offer transparency, security, and technology—enabling syndics, management companies, and residents to enjoy a modern, trustworthy experience with solutions tailor-made for this ecosystem. Our purpose is clear: to simplify, professionalize, and digitize condominiums’ financial lives while strengthening trust between management and residents. We’ve already impacted thousands of condominiums across Brazil—and we’re just getting started. Headquartered in Florianópolis and driven by an innovative spirit, we’re growing rapidly—without losing our essence, which values autonomy, fresh ideas, and the energy of those who want to build the future alongside us. If you’re looking for a place to innovate, learn, and grow, **CondoConta** is your next step. **Your Day-to-Day** At CondoConta, data is one of our most critical assets. We’re seeking a Data Analyst to serve as the technical intelligence arm of the Finance and Credit (FP\&A and Controller) team. Your mission will be to transform our *Data Lake* (Databricks) into structured, actionable insights for decision-making. You’ll operate at the intersection of Data Engineering and Business, ensuring that the complexity of millions of transactions reaches the end-user (Google Sheets/Dashboards) in an auditable, simple, and high-performance manner—for executives and investors alike. **Challenges and Responsibilities:** * **Analytics Engineering:** Translate business requirements from the Finance and Credit team into optimized SQL queries to support corporate financial analysis. * **Financial Data Modeling:** Design and maintain views and tables in Databricks that consolidate transactional data, ensuring historical consistency. * **Dashboard and Reporting Management:** Maintain and evolve executive data visualizations (automated Google Sheets and Power BI), guaranteeing numerical consistency. * **Data Consumption (APIs):** Extract and process data from our core systems (ERPs, CRM, banking platforms) using Python/SQL scripts, integrating these sources into our data ecosystem. * **Governance \& Quality:** Serve as the guardian of data integrity—proactively monitoring anomalies before they escalate into financial reporting issues. **What’s Essential?** * **Advanced SQL (Mandatory):** Proficiency in Window Functions, complex Joins, and query optimization in Big Data environments (Databricks/Spark SQL). * **Advanced Google Sheets:** Ability to connect spreadsheets to external data sources (BigQuery/Databricks connectors), use advanced QUERY functions, and deliver clean visualizations for non-technical stakeholders. * **Python for Data:** Intermediate-level knowledge (Pandas/Requests) for data manipulation, cleaning, and API consumption when SQL alone is insufficient. * **Business Logic Understanding:** Ability to comprehend relationships among tables from diverse sources (Sales, Finance, Accounting) and identify logical gaps. * Willingness to work on-site in **Florianópolis \- SC**, with flexibility for remote days. **You’ll Stand Out If You Have:** * Prior experience with **Big Data** tools (Databricks, Snowflake, or BigQuery). * Familiarity with **SaaS or Fintech** metrics (Unit Economics, Reconciliation, Cash Flow). * An **Automation/AI mindset:** Using AI tools to accelerate code writing and scenario analysis. **Benefits of Joining CondoConta:** * Employment terms designed to support your financial autonomy; * On-site day reimbursement (for hybrid employees based in Florianópolis); * Equipment to ensure comfortable remote work; * Gympass and Conexa Saúde for physical and mental well-being; * Home office allowance; * Birthday and tenure-based time-off days; * …and other benefits supporting your journey both inside and outside of work. Here, you’ll find purpose, innovation, and room to grow. Come join us—with no need for a **CondoPower**—and help build the future of condominium life!
João Silva
Indeed · HR
João Silva
Indeed · HR
