About the role
Xpand IT is seeking an Analytics Engineer to transform raw data into analysis-ready datasets and scalable data products. You will design Star Schema/Snowflake models, build data pipelines with SQL and Spark, and deliver dashboards in Power BI or Tableau to drive key metrics.
You will work with Azure and/or GCP data services, ensure data quality, and collaborate with cross-functional teams to translate business needs into precise technical specs. Fluency in Portuguese and English is required.
Designing and implementing efficient data models (Star Schema, Snowflake) within Cloud and Lakehouse environments. Developing data transformation processes using advanced SQL and Spark (Databricks, Dataproc) to ensure scalability. Creating high-impact data visualizations and dashboards in tools such as Power BI or Tableau that address critical KPIs. Ensuring data integrity, quality, and governance throughout the entire analytical pipeline. Collaborating with multidisciplinary teams to translate business needs into precise technical specifications, utilizing best practices for each cloud provider. Bachelor’s or Master’s degree in Information Systems Management, Management Informatics, Engineering, or related fields. Solid experience in designing relational data models (normalized and denormalized) and data warehousing architectures. Proficiency in visualization tools (Power BI/Tableau) and solid experience in Business Intelligence projects. Advanced proficiency in SQL for large-scale data analysis, manipulation, and transformation. Hands-on experience with Azure data services (ADF, Synapse, Fabric) or GCP (BigQuery, DataProc) and the Databricks platform. Mandatory fluency in both Portuguese and English (written and spoken).