Description

You will design, develop, and implement software solutions and database objects to improve system performance. You will gather business requirements, create technical documentation, and own the end-to-end delivery of data solutions.

Responsibilities

• Design, develop, test, and implement complex SQL queries, stored procedures, views, and indexing strategies.
• Build and maintain ETL processes using SSIS to extract, transform, and load data from various sources.
• Create and deploy reports using SSRS to support business intelligence needs.
• Perform code reviews for ETL, reporting, and SQL processes to ensure quality and best practices.
• Optimize and tune system performance, including database maintenance, job monitoring, and security configuration.

Required Skills

• 5+ years of experience in business intelligence or database development.
• Expertise in SQL Server Integration Services (SSIS) for robust ETL development.
• Strong experience with SQL Server Reporting Services (SSRS) for report creation and deployment.
• Advanced SQL programming skills, including complex stored procedures, partitioning, and compression.
• Proven ability to optimize and tune SQL Server performance.
• Experience with database maintenance, security roles, and job configuration.
• Bachelor's degree in Computer Science, IT, or a related field.

Key Skills

Education

Bachelor's Degree