Blog

Position Details

Requirement

CREQ

CREQ195896

No of Positions

1

Role

Lead Data Analyst

Location

Columbus, OH/Buffalo, NY (Day 1 On-site – All 5 days’ Work from Office) (Locals Preferred)

Type of Hire – Contract/ C2H

Contract/C2H

Rate (Max)

$57/hr

Duration

Long Term Contract

Number of Interviews

2

In person interviews Yes/No

No

Client Interview Yes/No

Yes

No of submission (example not more than 3 resumes)

2 Submissions

Timeline for submission

EOD

Position requirements

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.