Technical Data Analyst with SQL (Need 12+ years exp)

Stamford, CT, US • Posted 17 days ago • Updated 17 days ago

Contract W2

Contract Independent

Contract Corp To Corp

No Travel Required

On-site

Depends on Experience

Fitment

Dice Job Match Score™

🔗 Matching skills to job...

Job Details

Skills

SQL
Data Analysis
Technical Analysis
Stored Procedures
ETL
CTE

Summary

Position: Sr Technical Analyst with strong SQL and ETL

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:

Ability to explain complex technical concepts (like ETL logic or a complex SQL query) to non-technical stakeholders (business users, executives) clearly and concisely.
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:

A detective-like approach to finding the root cause of data discrepancies or reporting errors.
Proactive identification of potential issues in data pipelines before they cause major outages.

Stakeholder Management:

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.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 10122703
Position Id: 8862482
Posted 17 days ago

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Technical Data Analyst with SQL (Need 12+ years exp)

Dice Job Match Score™

Job Details

Skills

Summary

Similar Jobs