Description

You design, develop, and maintain Microsoft SQL Server environments across development, data warehouse, test, and production stages.

This role is on-site.

Responsibilities

• Design and implement database schemas using star and snowflake models for relational, dimensional, and multidimensional modeling.
• Develop ETL processes for data extraction, transformation, and loading using Microsoft BI Studio products.
• Construct T-SQL objects including tables, triggers, user functions, and views.
• Manage data integrity, user profiles, and data dictionaries within OLTP and OLAP systems.

Required Skills

• 5+ years of IT experience in system design and development.
• Expertise in Microsoft SQL Server (2012, 2014, 2016, or 2017).
• Advanced T-SQL for complex database modeling and object construction.
• Proficiency with SSIS for ETL implementation.
• Proficiency with SSRS for reporting requirements.
• Experience with OLTP and OLAP system analysis.
• Knowledge of star schema and snowflake schema design.
• Any Graduate degree.

Key Skills

Education

Any Graduate