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)
Skill Category | Key Technical Keywords (For Search) |
SQL Mastery | Advanced SQL, Stored Procedures, Query Tuning, Window Functions, Execution Plan, CTE |
ETL/Data Pipeline | ETL, ELT, Data Warehouse, Star Schema, Informatica, Talend, SSIS, Airflow, Data Lineage |
| | |
Analysis | Requirements Gathering, Business Intelligence, Data Modeling, UML |
BI Reporting | Tableau, Power BI, Looker |
- 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.
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