SOLUTION ARCHITECT L1

Job Description

The following responsibilities and qualifications are required for this role:

• Strong understanding of semantic models used in enterprise reporting and analytics.
• Expertise in dimensional modelling, including star and snowflake schema design.
• Practical experience implementing Slowly Changing Dimensions (SCD) Type 1 and Type 2.
• Ability to translate business requirements into scalable data models.
• Advanced Spark SQL knowledge and proficiency in complex joins, aggregations, and transformations.
• Strong command over window functions, ranking functions, and analytical queries.
• Ability to troubleshoot performance issues and optimize Spark SQL queries.
• PySpark development skills, including data ingestion, transformation, and workflow orchestration.
• Ability to write and understand basic PySpark functions.
• Basic und...