Sr Technical Business/Data Analyst with strong SQL and ETL

Position: Sr Technical Analyst with strong SQL and ETL (15+ Years of Exp)

Location:  Stamford, CT  (Only On-Site) -

Duration: Long-term 

Candidate ready to take SQL Test (90 mins HackerRank Test)

• Communication & Presentation:

o    Ability to explain complex technical concepts (like ETL logic or a complex SQL query) to non-technical stakeholders (business users, executives) clearly and concisely.

o    Strong documentation skills for defining technical specifications and user guides.

• Advanced SQL Mastery:
• Writing complex, optimized queries using various joins, subqueries, and window functions (e.g., ROW_NUMBER(), LAG(), LEAD()).
• Experience with different database systems (e.g., PostgreSQL, SQL Server, MySQL, Snowflake).
• Proficiency in creating and managing stored procedures, views, and functions for repeatable tasks.
• Understanding of query performance tuning (indexing, execution plans). 

• ETL (Extract, Transform, Load) Development:
• Hands-on experience with ETL/ELT tools.
• Understanding of data warehousing concepts (e.g., Star Schema, Snowflake Schema, dimension tables, fact tables).
• Ability to design and build reliable, scalable data pipelines that handle large volumes of data (batch and real-time).
• Problem-Solving:

o    A detective-like approach to finding the root cause of data discrepancies or reporting errors.

o    Proactive identification of potential issues in data pipelines before they cause major outages.

• Stakeholder Management:

o    Working effectively with Data Engineers, Business Users, and Project Managers to ensure alignment on data definitions and project scope.

Key Responsibilities:

• Collaborate with business stakeholders to understand and analyze their data needs.
• Perform in-depth data analysis using Redshift and other tools to derive actionable insights.
• Write complex SQL queries for data extraction and analysis.
• Create and present clear, concise executive-level presentations to communicate findings and insights.
• Exhibit strong logical and programming skills for data manipulation and analysis.
• Demonstrate curiosity and a willingness to learn, showing enthusiasm for new challenges.

Required Skills and Qualifications (MUST Have):

• Proven experience with SQL and Redshift.
• Experience working with business stakeholders at an executive level.
• Exceptional executive-level communication and presentation skills.
• Sharp analytical skills and the ability to scrutinize details meticulously.
• Ability to quickly grasp new concepts and technologies.

Best Regards,

Thanks,

Abdul Samad