Role: Lead Data Analyst
Location: Columbus, OH/Buffalo, NY (Day 1 On-site – All 5 days' Work from Office) (Locals Must)
Duration : Long Term Contract
Position requirements
100% On-site (No Remote option)

Job Description

Relevant Experience: 9+ Years

Mandatory Skills: SSIS, SSRS, Azure

Required Skills:

• Must have work experience in SSIS and SSRS and SQL Server.
• Proficient in Azure Synapse, Python, Pyspark and ADF.
• Strong in writing SQL query, Stored procedure and functions with hands-on in Power BI.
• Experience in creating SQL Server Database tables, Indexes, Views and ETL scripts for data replication from non-relational database to SQL Database.
• Good agile scrum delivery management Must have hands-on in offshore team management/coordination experience Extremely good communications.
• Should have rich experience with design, build and deployment of SSIS packages.
• Work Experience in performance optimization techniques using MSBI tool set SQL Server, SSIS and SSRS.
• Hands-on on azure Devops (ADO) , familiar with concepts like cherry picking, checking/merging code etc.
• Troubleshooting and debugging skills in SQL Agent Job, SSIS packages and complex T-SQL queries