Senior SQL Developer and Data Modeller

Key Responsibilities

1. Dimensional Data Modeling:

• Design and develop dimensional data models using Erwin with a focus on Star Schema and BUS architecture (Fact and Dimension tables).
• Ensure models align with business requirements and provide scalability, performance, and maintainability.

2. SQL Development:

• Implement data models in SQL using best practices for view creation, ensuring high performance.
• Write, optimize, and refactor complex SQL queries for efficiency and performance in large-scale databases.
• Develop solutions adhering to Information Mart and Data Vault 2.0 standards. (Dimensional model that is built using Raw Data vault tables Hubs, Links, satellites, Effectivity satellites , Bridge and PIT tables from Data Vault.)

3. Data Analysis & Relationship Metrics:

• Perform in-depth data analysis to identify patterns, relationships, and metrics at different levels of granularity.
• Ensure data integrity and quality by validating data models against business expectations.

4. Performance Optimization:

• Conduct performance tuning of existing data structures, queries, and ETL processes.
• Provide guidance on database indexing, partitioning, and query optimization techniques.

5. Collaboration:

• Work closely with business stakeholders, data engineers, and analysts to understand and translate business needs into effective data solutions. Support cross-functional teams to ensure seamless integration and delivery of data solutions

Key Competencies Technical Expertise:

1. Proficiency in Erwin for data modeling.

2. Advanced SQL skills with experience in writing and optimizing performancedriven queries.

3. Hands-on experience with Data Vault 2.0 and Information Mart standards is highly preferred. 4. Solid understanding of Star Schema, Facts & Dimensions, and Business Unit (BU) architecture.

Analytical Skills:

5. Strong data analysis skills to evaluate data relationships, metrics, and granularities.

6. Capability to troubleshoot and resolve complex data modeling and performance issues. Soft Skills:

7. Strong problem-solving and decision-making skills.

8. Excellent communication and stakeholder management abilities.

9. Proactive and detail-oriented with a focus on delivering high-quality result