Business Intelligence Analyst

Description

Job Summary: Join the Melnick team to transform the way people live, work, and connect by developing data solutions and impacting the city. Key Highlights: 1. Develop data pipelines using Databricks and Spark (PySpark/SQL). 2. Model data following the medallion architecture (Bronze, Silver, and Gold). 3. Create dimensional models and dashboards in Power BI. **Join the Melnick Team** We are a transformation movement. We believe in continuous development and in the strength of our people to collectively create outstanding products and experiences—transforming how people live, work, and connect. If you want to grow, learn, and leave your mark on projects that impact the city and people’s lives, come transform with us! **Responsibilities and Duties:** * Develop and maintain data pipelines using **Databricks** and **Spark (PySpark / SQL);** * Model data following the **medallion architecture (Bronze, Silver, and Gold);** * Ensure quality, governance, and performance of analytical data; * Build **dimensional models** (Star Schema / Snowflake) for analytical consumption; * Develop dashboards and reports in **Power BI**, focusing on performance and storytelling; * Collaborate with stakeholders to gather business requirements; * Use **Figma** for dashboard prototyping, layout definition, and user experience (UX/UI); * Implement best practices for version control, documentation, and metric standardization; * Support strategic decision-making through exploratory analysis and performance indicators (KPIs). **Requirements and Qualifications:** * Bachelor’s degree in Information Technology fields, such as Systems Analysis, Information Systems, or related disciplines. * Experience with **Databricks;** * Solid knowledge of the **medallion architecture;** * Proficiency in **SQL** and familiarity with **PySpark;** * Experience with **Power BI** (DAX, modeling, performance); * Hands-on experience with **analytical data modeling;** * Experience with **Figma** for dashboard prototyping or analytical interface design; * Knowledge of cloud-based data environments (preferably **Azure**) **Additional Information:** At Melnick, you will receive: * Transportation allowance or fuel assistance; * Meal or food allowance; * Health and dental insurance; * PPR (Profit Sharing Program); * Life insurance; * Partnerships with educational institutions;