MS SQL Technical Lead

HCL America Inc.
United States
25 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Compensation
$148,000.0
Working hours
Regular working hours
Job source

Tech stack

Data Analysis Data Integration Extract Transform Load (ETL) Microsoft SQL Server Performance Tuning SQL Stored Procedures SQL Databases SQL Server Reporting Services SQL Server Integration Services Systems Integration Transact-SQL Performance Monitor
+1 more
Tools for Reporting

Job description

Contribute to the technical design, development, and implementation of Microsoft SSIS, SQL Server Reporting Services (SSRS), and SQL Server projects. Lead a team of developers, coordinate with stakeholders, and ensure successful delivery of projects within the defined scope and timeline., 1. Lead and mentor a team of developers in creating, enhancing, and maintaining ssis packages and ssrs reports.

  1. Collaborate with business analysts and stakeholders to gather requirements and translate them into technical solutions.
  2. Design and develop complex etl processes using microsoft ssis for data integration and transformation.
  3. Create and optimize sql queries, stored procedures, and views in sql server to support reporting and data analysis needs.
  4. Monitor performance and troubleshoot issues in ssis packages, ssrs reports, and sql server databases.
  5. Ensure data accuracy, integrity, and security in all sql server databases and reporting solutions.
  6. Stay updated on the latest trends and best practices in microsoft ssis, ssrs, and sql server technologies.

Requirements

  1. Proficiency in microsoft sql server integration services (ssis) for etl processes.
  2. Strong expertise in sql server reporting services (ssrs) for creating and managing reports.
  3. In-depth knowledge of sql server, including tsql, stored procedures, functions, and performance optimization.
  4. Experience in leading teams and coordinating with business stakeholders for project requirements.
  5. Excellent problem-solving skills and the ability to analyze complex data and system issues.
  6. Strong communication skills to effectively collaborate with cross functional teams.

Benefits & conditions

3.73.7 out of 5 stars United States $148,000 a year

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.indeed.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

2:48 min

Daily responsibilities and alignment practices for technical engineering leadership

Edoardo Dusi · LIVE

1:14 min

Evolution of distributed SQL database architectures

Wei Hu Wei Hu · WWC 2024

1:48 min

Automating exploratory data analysis within training pipelines

Dora Petrella · WWC 2023

7:52 min

Audience questions on database performance, deployments, and data migrations

Gregor Bauer Gregor Bauer · LIVE

1:36 min

Evolution from key-value stores to distributed SQL

Wei Hu Wei Hu · WWC 2025

1:36 min

Performing exploratory data analysis to uncover underlying patterns

Julian Joseph · LIVE

Videos

See all

Related articles

See all