Onsite Lead – SSIS
Dheeresh VatsUnited StatesLEADPosted 2h ago
Microsoft SQL Server Integration Services (SSIS)T-SQLstored procedurestriggersviewsfunctionsSQL Server Management Studio (SSMS)ETL/ELTdata integrationSQL Server Agentdata warehousingstar schemadimensional modelingSAPsupply chain
About the Role
We are seeking an experienced Onsite Lead to manage client interactions and support enterprise data integration, reporting, and analytics solutions using the Microsoft SQL Server BI stack.
Key Responsibilities
• Strong experience with Microsoft SQL Server Integration Services (SSIS).
• Proficiency in T-SQL, stored procedures, triggers, views, and functions.
• Experience with SQL Server Management Studio (SSMS). Knowledge of ETL/ELT methodologies and data integration best practices.
• Experience with SQL Server Agent job scheduling and automation.
• Experience with data warehousing concepts such as star schema and dimensional modeling.
• Work with Solution Architects to understand customers' business requirements and implement solutions.
Requirements
• 10+ years of experience in SQL Server BI technologies, data integration, and support.
• Prior client-facing leadership experience preferred.
• Experience working in onsite-offshore delivery models.
• Exposure to enterprise reporting and BI environments.
• Knowledge of SAP and supply chain fundamentals and terminology.
Soft Skills
• Excellent verbal and written communication skills.
• Strong stakeholder management and customer-facing experience.
• Ability to lead technical discussions and coordinate cross-functional teams.