Data Solutions Architect

Role Overview

• Lead assessment and discovery processes to understand clients’ pain points, context, maturity and opportunities for data and analytics evolution.
• Translate business needs into Data Governance, Data Engineering, Analytics, BI and Artificial Intelligence solutions, always looking beyond what the client explicitly states.
• Act as a bridge between technical teams and the business, ensuring alignment, shared understanding and clarity.
• Design and facilitate workshops, deep-dive sessions and interactive meetings with clients, fostering discussions on architecture, governance, use cases and strategic AI adoption.
• Design scalable, modern data architectures aligned with Somativa’s solution portfolio.
• Prepare technical and functional proposals that connect clients’ real pain points to Somativa’s data, analytics and AI offerings.
• Detail methodological approaches, scope, project phases, deliverables and success criteria.
• Estimate effort and key project risks, supporting team formation and scheduling alongside project and commercial areas.
• Support the commercial team in meetings, presentations, demonstrations and value narratives for prospects and clients.
• Serve as the technical focal point for business opportunities, in partnership with the commercial and projects teams.
• Actively contribute to the evolution of Somativa’s product and service portfolio by bringing field feedback, trends and best practices.
• Support the creation and evolution of frameworks, templates, methodologies and best practices for data architecture and solutions.
• Serve as an internal reference for innovation, inspiring the team to explore new technologies, tools, methodologies, trends and differentiation opportunities.
• Document learnings, experiments and innovative projects, turning them into accelerators, best practices and new Somativa offerings.
• Perform structured knowledge and context handovers to project teams (engineering, data science, BI, AI).
• Ensure objectives, scope, defined architecture, assumptions and constraints are clear to the project team.
• Support the initial stages of execution when necessary, helping to maintain coherence between proposal and delivery.
• Continuously verify that Somativa’s quality standards are present, with determination and a commitment to continuous improvement and excellence.

Requirements

• Practical experience in data projects across governance, engineering, data science, BI/Analytics and data architecture.
• Experience designing data architectures in cloud (AWS, Azure, GCP) and on-premises environments, including concepts such as data lake, data warehouse and lakehouse.
• Proficiency in SQL and strong knowledge of data modeling (relational, dimensional and analytical).
• Familiarity with orchestration, ingestion and data transformation tools (for example: Python, Spark, Dremio, Athena, BigQuery, Airflow, Airbyte, Data Factory, Fabric, Snowflake, Synapse, Databricks, Glue, dbt, Talend, Apache Hop or similar).
• Experience with data visualization and BI tools (for example: Tableau, Power BI, Metabase, Apache Superset or equivalents).
• Understanding of data governance concepts (quality, catalog, lineage, security, LGPD, roles and responsibilities).
• Ability to lead conversations with executives and business stakeholders, structuring problems and proposing solution paths.
• Ability to organize information in clear documents: proposals, architecture visions, roadmaps and presentations.
• Collaborative profile, systems thinking, logical reasoning and a focus on delivering business value.

Tech Stack

• Airflow
• Apache
• AWS
• Azure
• BigQuery
• Google Cloud Platform
• Python
• Spark
• SQL
• Tableau

Benefits

• English classes
• Gympass
• Meals at a partner restaurant when working on-site
• Christmas hamper