Data Modelling & SQL Expert
Job Description
• Develop and maintain data models including conceptual, logical, and physical models.
• Design and optimize database schemas such as star and snowflake models.
• Translate business requirements into scalable data architecture solutions.
• Perform SQL development including complex queries, CTEs, window functions, and stored procedures.
• Optimize database performance through indexing, query tuning, and schema refinement.
• Implement data validation rules and ensure data quality and governance standards.
• Create and maintain data dictionaries, metadata repositories, and ER diagrams.
• Collaborate with data engineers, ETL teams, and analysts for data integration.
• Work with relational databases such as Oracle, SQL Server, PostgreSQL, and MySQL.
• Support ETL processes and data warehousing implementations.
