Description

You will develop and support production systems through advanced SQL database management and ETL processes.

Responsibilities

• Build and maintain stored procedures, views, triggers, functions, indexes, and cursors using T-SQL.
• Design and implement ETL packages using SSIS for data extraction and migration.
• Optimize system performance through performance tuning and SQL Profiler.
• Collaborate with Product Owners and SMEs to scope requirements, identify constraints, and mitigate risks.
• Develop automated tests for unit and regression testing while documenting all developed code.

Required Skills

• 7+ years of experience in SQL development.
• 5+ years of experience writing stored procedures and SSIS ETL packages.
• 5+ years of experience in ETL development and data extraction/migration tools.
• 5+ years of experience working within Agile process development.
• Advanced knowledge of SSRS for report development.
• Proficiency in T-SQL, SSIS, ETL, and the full System Development Life Cycle (SDLC).
• Bachelor's degree.

Preferred Skills

• Experience with SSAS.

Key Skills

Education

Bachelor's degree