Description

You will design, develop, and optimize data warehouse solutions to support business analytics and reporting needs. This role is remote.

Responsibilities

• Design and maintain data warehouse schemas, tables, views, and materialized views.
• Write complex MS SQL scripts for ETL processes, ensuring data integrity and accuracy.
• Optimize database performance through query tuning, indexing, and partitioning.
• Develop and maintain stored procedures, functions, triggers, and packages.
• Document ETL workflows, data mappings, and database structures.

Required Skills

• 10+ years of hands-on experience in MS SQL Server development.
• Strong expertise in data modeling, including star/snowflake schemas and dimensional modeling.
• Proven experience building and maintaining efficient ETL processes.
• Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent experience).
• Experience with Python.
• Strong analytical and troubleshooting skills for production support.

Key Skills

Education

Any Graduate