Job Description

Job Title:

Lead SQL Data Analyst - P&C Domain

Location:

Remote - USA / Canada

Type:

Contract / Full-Time

Role Summary

Seeking a seasoned Data Analyst/Technical Lead with 10+ years of experience to support

BI and data platform migration

initiatives in an onshore role. The ideal candidate will have

deep SQL expertise

, strong communication skills, and experience leading or coordinating projects across global teams. A background in BI/reporting migration and working closely with business stakeholders is essential.

Key Responsibilities

Act as onshore lead, coordinating with business users and offshore teams for BI/data migration projects. Analyze and optimize complex SQL queries; lead the migration of legacy logic to AWS Redshift. Redesign and consolidate legacy queries to create scalable, efficient, and maintainable solutions. Collaborate with stakeholders to gather data requirements and translate them into technical solutions. Prepare quick design documents and participate in workshops to review with stakeholders. Ensure data integrity, reporting continuity, and performance optimization post-migration. Participate in Agile ceremonies and lead sprint execution from an onshore perspective. Mentor and support offshore team members, ensuring alignment and delivery quality.

Required Skills & Qualifications

10+ years of experience in data analysis, SQL development, and data platform projects. Strong experience working as an onshore tech lead or coordinator on large-scale data initiatives.

Expert-level SQL skills

--comfortable analysing, writing, and optimizing complex queries.

Hands-on experience with Amazon Redshift, including SQL migration

and performance tuning.

Proven track record in BI and data migration projects

(e.g., Teradata/Hadoop to Redshift). Solid understanding of data modelling, ETL pipelines, and modern data architectures. Familiarity with BI tools such as

Tableau and/or SAP BusinessObjects

(Must Have).

Agile mindset

--proactive, accountable, and delivery-focused. Excellent communication and

stakeholder management

skills. Collaborative team player comfortable working across technical and business domains.

Nice to Have

Exposure to AWS Glue, S3, Athena. Experience with Git, CI/CD for data workflows. Understanding of the Insurance (P&C)
Job Types: Full-time, Permanent, Fixed term contract
Contract length: 12 months

Pay: $60.00-$80.00 per hour

Experience:

Microsoft SQL Server: 10 years (required) Business intelligence: 10 years (required) Data analytics: 10 years (required)
Work Location: Remote