Description

Design and implement end-to-end Business Intelligence solutions using the Microsoft stack and cloud data platforms.

Responsibilities

• Develop and optimize T-SQL objects including stored procedures, functions, triggers, views, and cursors.
• Build and maintain SSIS packages for data migration and ETL processes.
• Design and deploy SSRS reports to meet specific business requirements.
• Manage database operations including DDL, DML, indexing, backups, restores, and transaction monitoring.
• Implement data modeling through the design of database tables and schemas.

Required Skills

• 10+ years of experience in Business Intelligence development.
• Expertise in T-SQL programming and dynamic SQL.
• Hands-on experience with SQL Server Integration Services (SSIS).
• Proficiency in SQL Server Reporting Services (SSRS).
• Experience with Snowflake and ADF pipelines.
• Knowledge of Databricks cluster creation.
• Ability to perform SQL debugging and error handling in stored procedures.
• Competency in DDL and DML operations within SQL Server.

Preferred Skills

• Experience with UNIX scripting using Shell, Perl, or Python.

Key Skills

Education

Bachelor's degree