Data Architect

Description

Job Summary: We are seeking a Data Architect to define the analytical strategy for high-impact solutions, building robust and scalable architectures. Key Highlights: 1. Technical and personal challenges for continuous growth 2. Culture of continuous improvement with support and learning 3. Physical and mental wellness programs (Happy Kaizen, WeSofka) Are you **looking for new challenges** and a place where you can enjoy a close-knit environment while continuously **learning**? Welcome to a team with a clear purpose: **"TRANSFORM** people's lives by being the most trusted **TECHNOLOGICAL** partner"! ### **Get ready and join this adventure!** **What will you find?** --------------------- * **Technical challenges** and personal opportunities that keep you growing continuously. * A connected team focused on **your physical and mental well-being**. * A **culture of continuous improvement**, fresh and collaborative, with learning opportunities and people ready to support you. * **KaizenHub**, a program designed to enhance your talents, offering **feedback**, mentoring, and coaching through **Sofka U**. It will be both a challenge and a game! * **Programs such as Happy Kaizen and WeSofka**, caring for your physical and emotional well-being. **What are we looking for?** ------------------ A **Data Architect** with at least 5 years of experience in analytical data architecture, proficient in designing multi-entity models with granular access control, and with solid hands-on experience provisioning services on AWS. Strong technical depth in dimensional modeling, transformations, and DAX, along with the ability to lead strategic conversations with clients. This role is critical to defining the analytical strategy for high-impact solutions—from the functional model to final delivery to the client. If you're passionate about building robust, scalable, and well-governed architectures, this is your opportunity to make an impact on large-scale projects. #### **Responsibilities** * Design analytical data models under star schema patterns, correctly sizing fact and dimension tables for organizations with multiple entities. * Build and manage data transformations in Azure Data Factory, ensuring quality and integrity across each pipeline layer. * Develop highly complex DAX metrics and advanced SQL queries supporting business analytical requirements. * Implement Row\-Level Security (RLS) and optimize data model performance to ensure smooth and secure user experiences. * Provision, configure, and parameterize AWS services (Lambda, S3, Glue, Athena) and integrate them with Power Query in data flows. * Serve as the primary client liaison for all matters related to AWS provisioning and solution architecture. * Define the analytical strategy and functional model of the solution, aligning technical design with business objectives. * Validate technical deliverables prior to client presentation, ensuring quality, accuracy, and consistency. * Govern the data model and maintain up-to-date, accessible technical documentation for the team. #### **Requirements** * **Education:** Degree in Systems Engineering, Data Engineering, Computer Science, or related fields. * **Experience:** Minimum 5 years in analytical data architecture, with proven participation in dimensional modeling projects for multi-entity organizations with granular access control. Experience in provisioning and configuring AWS services. #### **Technical Knowledge** * Star schema design: fact and dimension tables * Azure Data Factory — building transformations and pipelines * Advanced DAX — highly complex metrics in Power BI * Highly complex SQL (analytical queries, optimization) * Row\-Level Security (RLS) and data-level security implementation * AWS services: Lambda, S3, Glue, Athena * Source integration with Power Query (PQ) * Data model governance and technical documentation * Analytical strategy definition and functional solution modeling ### **APPLY NOW and become part of this story!** **Conditions** --------------- * **Indefinite-term contract or Contractor** — We aim for long-term relationships and want you to be part of our family for many years! * **Seeking professional growth?** At Sofka, we offer a **learning ecosystem** with multiple tools to bridge skill gaps and boost your capabilities. You decide how you want to grow!